Résumé
- The most comprehensive guidebook available on the most popular spreadsheet program, fully updated to include all-new "X" features
- Written by the leading Excel guru known as "Mr. Spreadsheet," John Walkenbach, who has written more than thirty books and 300 articles on related topics and maintains the popular Spreadsheet Page at www.j-walk.com/ss
- The definitive reference book for beginning to advanced users, featuring expert advice and hundreds of examples, tips, techniques, shortcuts, work-arounds, and more
- Covers expanded use of XML and Web services to facilitate data reporting, analysis, importing, and exporting information
- Explores Excel programming for those who want advanced information
- CD-ROM includes all templates and worksheets used in the book, as well as sample chapters from all Wiley Office "X" related Bibles and useful third party software, including John Walkenbach's Power Utility Pak
Contents
- Getting Started with Excel
- Introducing Excel
- Entering and Editing Worksheet Data
- Essential Worksheet Operations
- Working with Cells and Ranges
- Worksheet Formatting
- Understanding Files and Templates
- Printing Your Work
- Working with Formulas and Functions
- Introducing Formulas and Functions
- Creating Formulas That Manipulate Text
- Working with Dates and Times
- Creating Formulas That Count and Sum
- Creating Formulas That Look Up Values
- Creating Formulas for Financial Applications
- Introducing Array Formulas
- Performing Magic with Array Formulas
- Creating Charts and Graphics
- Getting Started Making Charts
- Learning Advanced Charting
- Enhancing Your Work with Pictures and Drawings
- Analyzing Data with Excel
- Working with Lists
- Using External Database Files
- Analyzing Data with Pivot Tables
- Performing Spreadsheet What-If Analysis
- Analyzing Data Using Goal Seek and Solver
- Analyzing Data with the Analysis ToolPak
- Using Advanced Excel Features
- Using Custom Number Formats
- Customizing Toolbars and Menus
- Using Conditional Formatting and Data Validation
- Creating and Using Worksheet Outlines
- Linking and Consolidating Worksheets
- Excel and the Internet
- Sharing Data with Other Applications
- Using Excel in a Workgroup
- Making Your Worksheets Error-Free
- Programming Excel with VBA
- Introducing Visual Basic for Applications
- Creating Custom Worksheet Functions
- Creating UserForms
- Using UserForm Controls in a Worksheet
- Working with Excel Events
- VBA Examples
- Creating Custom Excel Add-Ins
- Appendixes
- Appendix A: Worksheet Function Reference
- Appendix B: What's on the CD-ROM
- Appendix C: Just for Fun
- Appendix D: Additional Excel Resources
- Appendix E: Excel Shortcut Keys
- Index
- End-User License Agreement
L'auteur - John Walkenbach
Surnommé Mr. Spreadsheet (Monsieur Tableur), John Walkenbach est un spécialiste reconnu des tableurs, et plus particulièrement d'Excel, Auteur de plus de 30 ouvrages et de 300 articles, il a été récompensé pour son utilitaire Power Utility Pak.
Autres livres de John Walkenbach
Caractéristiques techniques
| PAPIER | |
| Éditeur(s) | Wiley |
| Auteur(s) | John Walkenbach |
| Parution | 23/10/2003 |
| Nb. de pages | 932 |
| Format | 18,7 x 23,5 |
| Couverture | Broché |
| Poids | 1375g |
| Intérieur | Noir et Blanc |
| EAN13 | 9780764539671 |
| ISBN13 | 978-0-7645-3967-1 |
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
