Technical details
Genre |
Office software |
Number of pages |
840 pages |
Written by |
John Walkenbach |
Excel 2007 Formulas, February 2007
- This book is a single reference that’s indispensable for Excel beginners, intermediate users, power users, and would-be power users everywhere\n- 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\n- John Walkenbach, aka "Mr. Spreadsheet," is one of the world’s leading authorities on Excel\n- Thoroughly updated to cover the revamped Excel interface, new file formats, enhanced interactivity with other Office applications, and upgraded collaboration features\n- Includes a valuable CD-ROM with templates and worksheets from the book\n\nNote: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.\n\n\nJohn Walkenbach, arguably the foremost authority on Excel, has written hundreds of articles and created the award-winning Power Utility Pak. His 40-plus books include Excel 2003 Power Programming with VBA, Excel Charts, and John Walkenbach's Favorite Excel Tips & Tricks, all published by Wiley. Visit his popular Spreadsheet Page at www.j-walk.com/ss.\n\n\n<b>Table of Contents</b>\n\n\n<b>Part I: Basic Information.</b>\n\nChapter 1: Excel in a Nutshell.\n\nChapter 2: Basic Facts about Formulas.\n\nChapter 3: Working with Names.\n\n<b>Part II: Using Functions in Your Formulas.</b>\n\nChapter 4: Introducing Worksheet Functions.\n\nChapter 5: Manipulating Text.\n\nChapter 6: Working with Dates and Times.\n\nChapter 7: Counting and Summing Techniques.\n\nChapter 8: Using Lookup Functions.\n\nChapter 9: Tables and Worksheet Databases.\n\nChapter 10: Miscellaneous Calculations.\n\n<b>Part III: Financial Formulas.</b>\n\nChapter 11: Borrowing and Investing Formulas.\n\nChapter 12: Discounting and Depreciation Formulas.\n\nChapter 13: Financial Schedules.\n\n<b>Part IV: Array Formulas.</b>\n\nChapter 14: Introducing Arrays.\n\nChapter 15: Performing Magic with Array Formulas.\n\n<b>Part V: Miscellaneous Formula Techniques.</b>\n\nChapter 16: Intentional Circular References.\n\nChapter 17: Charting Techniques.\n\nChapter 18: Pivot Tables.\n\nChapter 19: Conditional Formatting and Data Validation.\n\nChapter 20: Creating Megaformulas.\n\nChapter 21: Tools and Methods for Debugging Formulas.\n\n<b>Part VI: Developing Custom Worksheet Functions.</b>\n\nChapter 22: Introducing VBA.\n\nChapter 23: Function Procedure Basics.\n\nChapter 24: VBA Programming Concepts.\n\nChapter 25: VBA Custom Function Examples.\n\n<b>Part VII: Appendixes.</b>\n\nAppendix A: Excel Function Reference.\n\nAppendix B: Using Custom Number Formats.\n\nAppendix C: Additional Excel Resources.\n\nAppendix D: What’s on the CD-ROM.\n\nIndex.