Office 2010 Bible

John Walkenbach aka "Mr. Spreadsheet" is the principal of J-Walk and Associates, Inc. and a Microsoft Excel MVP. He is a leading authority on spreadsheet software and the creator of the award-winning Power Utility Pak. John has written more than 50 books, as well as articles and reviews for publications including PC World , InfoWorld , and Windows . He also maintains the popular Spreadsheet Page at spreadsheetpage.com.

Acknowledgments. Introduction. Part I: Getting Started with Excel 1 Chapter 1: Introducing Excel. Chapter 2: Entering and Editing Worksheet Data. Chapter 3: Essential Worksheet Operations. Chapter 4: Working with Cells and Ranges. Chapter 5: Introducing Tables. Chapter 6: Worksheet Formatting. Chapter 7: Understanding Excel Files. Chapter 8: Using and Creating Templates. Chapter 9: Printing Your Work. Part II: Working with Formulas and Functions. Chapter 10: Introducing Formulas and Functions. Chapter 11: Creating Formulas That Manipulate Text. Chapter 12: Working with Dates and Times. Chapter 13: Creating Formulas That Count and Sum. Chapter 14: Creating Formulas That Look Up Values. Chapter 15: Creating Formulas for Financial Applications. Chapter 16: Introducing Array Formulas. Chapter 17: Performing Magic with Array Formulas. Part III: Creating Charts and Graphics. Chapter 18: Getting Started Making Charts. Chapter 19: Learning Advanced Charting. Chapter 20: Visualizing Data Using Conditional Formatting. Chapter 21: Creating Sparkline Graphics. Chapter 22: Enhancing Your Work with Pictures and Drawings. Part IV: Using Advanced Excel Features. Chapter 23: Customizing the Excel User Interface. 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 Office 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: Getting Data from 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 Seeking 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. Index. End-User License Agreement.