Excel 2007 Bible

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 "e;Mr. Spreadsheet,"e; 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 Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

* This book is a single reference that's indispensable forExcel beginners, intermediate users, power users, and would-bepower users everywhere* Fully updated for the new release, this latest edition providescomprehensive, soup-to-nuts coverage, delivering over 900 pages ofExcel tips, tricks, and techniques readers won't findanywhere else* John Walkenbach, aka "Mr. Spreadsheet," is one of theliworld's leading authorities on Excel* Thoroughly updated to cover the revamped Excel interface, newfile formats, enhanced interactivity with other Officeapplications, and upgraded collaboration features* Includes a valuable CD-ROM with templates and worksheets fromthe bookNote: CD-ROM/DVD and other supplementary materials arenot included as part of eBook file.

Part I: Getting Started with Excel 1Chapter 1: Introducing Excel 3Chapter 2: What's New in Excel 2007? 25Chapter 3: Entering and Editing Worksheet Data 35Chapter 4: Essential Worksheet Operations 53Chapter 5: Working with Cells and Ranges 71Chapter 6: Introducing Tables 95Chapter 7: Worksheet Formatting 109Chapter 8: Understanding Excel's Files 131Chapter 9: Using and Creating Templates 145Chapter 10: Printing Your Work 155Part II: Working with Formulas and Functions 173Chapter 11: Introducing Formulas and Functions 175Chapter 12: Creating Formulas That Manipulate Text 205Chapter 13: Working with Dates and Times 223Chapter 14: Creating Formulas That Count and Sum 249Chapter 15: Creating Formulas That Look Up Values 273Chapter 16: Creating Formulas for Financial Applications 291Chapter 17: Introducing Array Formulas 313Chapter 18: Performing Magic with Array Formulas 333Part III: Creating Charts and Graphics 349Chapter 19: Getting Started Making Charts 351Chapter 20: Learning Advanced Charting 381Chapter 21: Visualizing Data Using Conditional Formatting421Chapter 22: Enhancing Your Work with Pictures and Drawings441Part IV: Using Advanced Excel Features 459Chapter 23: Customizing the Quick Access Toolbar 461Chapter 24: Using Custom Number Formats 465Chapter 25: Using Data Validation 481Chapter 26: Creating and Using Worksheet Outlines 491Chapter 27: Linking and Consolidating Worksheets 499Chapter 28: Excel and the Internet 513Chapter 29: Sharing Data with Other Applications 521Chapter 30: Using Excel in a Workgroup 531Chapter 31: Protecting Your Work 539Chapter 32: Making Your Worksheets Error-Free 551Part V: Analyzing Data with Excel 573Chapter 33: Using Microsoft Query with External Database Files575Chapter 34: Introducing Pivot Tables 591Chapter 35: Analyzing Data with Pivot Tables 609Chapter 36: Performing Spreadsheet What-If Analysis 635Chapter 37: Analyzing Data Using Goal Seek and Solver 649Chapter 38: Analyzing Data with the Analysis ToolPak 667Part VI: Programming Excel with VBA 679Chapter 39: Introducing Visual Basic for Applications 681Chapter 40: Creating Custom Worksheet Functions 703Chapter 41: Creating UserForms 715Chapter 42: Using UserForm Controls in a Worksheet 733Chapter 43: Working with Excel Events 745Chapter 44: VBA Examples 757Chapter 45: Creating Custom Excel Add-Ins 771Part VII: Appendixes 783Appendix A: Worksheet Function Reference 785Appendix B: What's on the CD-ROM 799Appendix C: Additional Excel Resources 809Appendix D: Excel Shortcut Keys 815Index 823Wiley Publishing, Inc. End-User License Agreement 869