Excel 2010 Bible

Book Description

A comprehensive reference to the newest version of the world’s most popular spreadsheet application: Excel 2010John Walkenbach's name is synonymous with excellence in computer books that decipher complex technical topics. Known as "Mr. Spreadsheet," Walkenbach shows you how to maximize the power of all the new features of Excel 2010.

An authoritative reference, this perennial bestseller proves itself indispensable no matter your level of skill, from Excel beginners and intermediate users to power users and potential 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 you won’t find anywhere else.

• Excel guru and bestselling author John Walkenbach ("Mr. Spreadsheet") guides you through every aspect of Excel
• Delivers essential coverage of all the newest features of Excel 2010
• Presents material in a clear, concise, logical format that is ideal for all levels of Excel experience
• Includes a CD that contains all the templates and worksheets used in the book plus John Walkenbach's award-winning Power Utility Pak

Excel 2010 Bible serves as an excellent resource on all things Excel!

Table of contents

Part I: Getting Started with Excel
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

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.