Résumé
Microsoft® Excel Version 2002 Inside Out is the
foremost reference to Excel version 2002 for PC "super
users". Complete in one volume, this book provides a
thorough overview of the most-used features and functions
of Microsoft's popular spreadsheet program. The book
provides the information advanced users really need. It
delivers comprehensive information about each major Excel
tool and task, including using worksheets, analyzing data,
interfacing with other applications, using charts, creating
databases and managing lists, and more. The book also shows
how to create macros, use custom functions, and master
Excel by using the Microsoft Visual Basic development
system. Throughout the book you'll find a wealth of
timesaving Excel tips and tricks, troubleshooting
techniques, and indexes, plus a CD-ROM that holds an
electronic version of the book's text, handy Web links,
sample macros and code, tutorials, utilities and additional
third party software. This is the authoritative handbook
you'll keep by your computer and use whenever you're stuck
or stumped!
Contents
- Acknowledgments xxxiii
- We'd Like to Hear from You xxxv
- Conventions Used in This Book xxxvii
- Part 1: Examining the Excel Environment 1
- Chapter 1: What's New in Microsoft Excel 2002 3
- Chapter 2: Running Excel 13
- Chapter 3: Custom-Tailoring the Excel Workspace 65
- Part 2: Building Worksheets 91
- Chapter 4: Worksheet Design Tips 93
- Chapter 5: How to Work a Worksheet 101
- Chapter 6: How to Work a Workbook 133
- Part 3: Formatting and Editing Worksheets 145
- Chapter 7: Worksheet Editing Techniques 147
- Chapter 8: Worksheet Formatting Techniques 199
- Chapter 9: Advanced Formatting and Editing Techniques 245
- Part 4: Adding Graphics and Printing 285
- Chapter 10: Creating Spiffy Graphics 287
- Chapter 11: Printing and Presenting 335
- Part 5: Creating Formulas and Performing Data Analysis 353
- Chapter 12: Building Formulas 355
- Chapter 13: Using Functions 403
- Chapter 14: Everyday Functions 413
- Chapter 15: Formatting and Calculating Date and Time 439
- Chapter 16: Functions for Financial Analysis 455
- Chapter 17: Functions for Analyzing Statistics 471
- Chapter 18: Performing What-If Analysis 499
- Part 6: Collaborating and the Internet 529
- Chapter 19: Collaborating with Excel 531
- Chapter 20: Transferring Files to and from Internet Sites 553
- Chapter 21: Linking and Embedding 569
- Chapter 22: Using Hyperlinks 579
- Part 7: Integrating Excel with Other Applications 589
- Chapter 23: Integrating Excel with Word and PowerPoint 591
- Part 8: Creating Charts 609
- Chapter 24: Basic Charting Techniques 611
- Chapter 25: Enhancing the Appearance of Your Charts 625
- Chapter 26: Working with Chart Data 671
- Chapter 27: Advanced Charting Techniques 687
- Part 9: Managing Databases and Lists 703
- Chapter 28: Managing Information in Lists 705
- Chapter 29: Working with External Data 749
- Chapter 30: Analyzing Data with PivotTable Reports 789
- Part 10: Working with Visual Basic and Macros 831
- Chapter 31: Recording Macros 833
- Chapter 32: Creating Custom Functions 853
- Chapter 33: A Sample Visual Basic Application 863
- Chapter 34: Debugging Macros and Custom Functions 887
- Part 11: Appendixes 901
- Appendix A: Installing Microsoft Excel 903
- Appendix B: Using Speech and Handwriting Recognition 911
- Appendix C: Keyboard Shortcuts 925
- Appendix D: Function Reference 949
- Index of Troubleshooting Topics 983
- Index 987
L'auteur - Craig Stinson
Craig Stinson has been writing about computers since 1981. He is a columnist for PC Magazine the best-selling author of several editions of Running Microsoft Windows, and co-author of Running Microsoft Windows NT and Running Microsoft Excel.
Caractéristiques techniques
| PAPIER | |
| Éditeur(s) | Microsoft Press |
| Auteur(s) | Craig Stinson, Mark Dodge |
| Parution | 26/03/2002 |
| Nb. de pages | 1056 |
| Format | 18,5 x 23,5 |
| Couverture | Broché |
| Poids | 1676g |
| Intérieur | 2 couleurs |
| EAN13 | 9780735612815 |
| ISBN13 | 978-0-7356-1281-5 |
Avantages Eyrolles.com
Livraison à partir de 0,01 € en France métropolitaine
Paiement en ligne SÉCURISÉ
Livraison dans le monde
Retour sous 15 jours
+ d'un million et demi de livres disponibles
Consultez aussi
- Les meilleures ventes en Graphisme & Photo
- Les meilleures ventes en Informatique
- Les meilleures ventes en Construction
- Les meilleures ventes en Entreprise & Droit
- Les meilleures ventes en Sciences
- Les meilleures ventes en Littérature
- Les meilleures ventes en Arts & Loisirs
- Les meilleures ventes en Vie pratique
- Les meilleures ventes en Voyage et Tourisme
- Les meilleures ventes en BD et Jeunesse
