Déjà client ? Identifiez-vous

Mot de passe oublié ?

Nouveau client ?

CRÉER VOTRE COMPTE
Excel 2002
Ajouter à une liste

Librairie Eyrolles - Paris 5e
Indisponible

Excel 2002

Excel 2002

Inside Out

Craig Stinson, Mark Dodge

1056 pages, parution le 26/03/2002

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
satisfait ou remboursé
Satisfait ou remboursé
Paiement sécurisé
modes de paiement
Paiement à l'expédition
partout dans le monde
Livraison partout dans le monde
Service clients sav@commande.eyrolles.com
librairie française
Librairie française depuis 1925
Recevez nos newsletters
Vous serez régulièrement informé(e) de toutes nos actualités.
Inscription