Excel 2007 Formulas

John Walkenbach

864 pages, parution le 15/02/2007

Ajouter à une liste

Indisponible

Résumé

This book is a single reference that's indispensable for Excel beginners, intermediate users, power users, and would-be power users everywhere
Fully updated for the new release, this latest edition provides comprehensive, soup-to-nuts coverage, delivering over 900 pages of Excel tips, tricks, and techniques readers won't find anywhere else
John Walkenbach, aka "Mr. Spreadsheet," is one of the world's leading authorities on Excel
Thoroughly updated to cover the revamped Excel interface, new file formats, enhanced interactivity with other Office applications, and upgraded collaboration features
Includes a valuable CD-ROM with templates and worksheets from the book

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

Programmation VBA pour Excel 2022 pour les nuls

Excel 2019 et VBA pour les nuls

Programmation VBA pour Excel 2019 pour les nuls

Programmation VBA pour Excel pour les nuls

Découvrir tous les livres de John Walkenbach

Sommaire

Basic Information
- Excel in a Nutshell
- Basic Facts about Formulas
- Working with Names
Using Functions in Your Formulas
- Introducing Worksheet Functions
- Manipulating Text
- Working with Dates and Times
- Counting and Summing Techniques
- Using Lookup Functions
- Tables and Worksheet Databases
- Miscellaneous Calculations
Financial Formulas
- Borrowing and Investing Formulas
- Discounting and Depreciation Formulas
- Financial Schedules
Array Formulas
- Introducing Arrays
- Performing Magic with Array Formulas
Miscellaneous Formula Techniques
- Intentional Circular References
- Charting Techniques
- Pivot Tables
- Conditional Formatting and Data Validation
- Creating Megaformulas
- Tools and Methods for Debugging Formulas
Developing Custom Worksheet Functions
- Introducing VBA
- Function Procedure Basics
- VBA Programming Concepts
- VBA Custom Function Examples
Appendixes
- Appendix A: Excel Function Reference
- Appendix B: Using Custom Number Formats
- Appendix C: Additional Excel Resources
- Appendix D: What's on the CD-ROM

Voir tout

Replier

Caractéristiques techniques

	PAPIER
Éditeur(s)	Wiley
Auteur(s)	John Walkenbach
Parution	15/02/2007
Nb. de pages	864
Format	19 x 23,5
Couverture	Broché
Poids	1225g
Intérieur	Noir et Blanc
EAN13	9780470044025
ISBN13	978-0-470-04402-5