Excel 2007 Bible

Book Description

• 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 liworld’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

Table of Contents

Part I: Getting Started with Excel
Chapter 1: Introducing Excel
Chapter 2: What’s New in Excel 2007?
Chapter 3: Entering and Editing Worksheet Data
Chapter 4: Essential Worksheet Operations
Chapter 5: Working with Cells and Ranges
Chapter 6: Introducing Tables
Chapter 7: Worksheet Formatting
Chapter 8: Understanding Excel’s Files
Chapter 9: Using and Creating Templates
Chapter 10: Printing Your Work

Part II: Working with Formulas and Functions
Chapter 11: Introducing Formulas and Functions
Chapter 12: Creating Formulas That Manipulate Text
Chapter 13: Working with Dates and Times
Chapter 14: Creating Formulas That Count and Sum
Chapter 15: Creating Formulas That Look Up Values
Chapter 16: Creating Formulas for Financial Applications
Chapter 17: Introducing Array Formulas
Chapter 18: Performing Magic with Array Formulas

Part III: Creating Charts and Graphics
Chapter 19: Getting Started Making Charts
Chapter 20: Learning Advanced Charting
Chapter 21: Visualizing Data Using Conditional Formatting
Chapter 22: Enhancing Your Work with Pictures and Drawings

Part IV: Using Advanced Excel Features
Chapter 23: Customizing the Quick Access Toolbar
Chapter 24: Using Custom Number Formats
Chapter 25: Using Data Validation
Chapter 26: Creating and Using Worksheet Outlines
Chapter 27: Linking and Consolidating Worksheets
Chapter 28: Excel and the Internet
Chapter 29: Sharing Data with Other Applications
Chapter 30: Using Excel in a Workgroup
Chapter 31: Protecting Your Work
Chapter 32: Making Your Worksheets Error-Free

Part V: Analyzing Data with Excel
Chapter 33: Using Microsoft Query with External Database Files
Chapter 34: Introducing Pivot Tables
Chapter 35: Analyzing Data with Pivot Tables
Chapter 36: Performing Spreadsheet What-If Analysis
Chapter 37: Analyzing Data Using Goal Seek and Solver
Chapter 38: Analyzing Data with the Analysis ToolPak

Part VI: Programming Excel with VBA
Chapter 39: Introducing Visual Basic for Applications
Chapter 40: Creating Custom Worksheet Functions
Chapter 41: Creating UserForms
Chapter 42: Using UserForm Controls in a Worksheet
Chapter 43: Working with Excel Events
Chapter 44: VBA Examples
Chapter 45: Creating Custom Excel Add-Ins

Part VII: Appendixes
Appendix A: Worksheet Function Reference
Appendix B: What’s on the CD-ROM
Appendix C: Additional Excel Resources
Appendix D: Excel Shortcut Keys

About The Author

John Walkenbach

John Walkenbach, a.k.a. Mr. Spreadsheet, is arguably the world's foremost authority on Microsoft Excel. His fifty-plus Excel books include Excel 2013 Power Programming with VBA, Excel 2013 Formulas, and the bestselling Excel 2013 Bible, all published by Wiley. He has also written hundreds of articles and software reviews, and created the award-winning Power Utility Pak add-in for Excel. John lives in Tucson, Arizona. He also plays the banjo - but don't let that prevent you from buying his books.