Microsoft Excel 2010 Bible

Acknowledgments.

Introduction.

Part I: Getting Started with Excel 1

• Introducing Excel.

• Entering and Editing Worksheet Data.

• Essential Worksheet Operations.

• Working with Cells and Ranges.

• Introducing Tables.

• Worksheet Formatting.

• Understanding Excel Files.

• Using and Creating Templates.

• Printing Your Work.

Part II: Working with Formulas and Functions.

• Introducing Formulas and Functions.

• Creating Formulas That Manipulate Text.

• Working with Dates and Times.

• Creating Formulas That Count and Sum.

• Creating Formulas That Look Up Values.

• Creating Formulas for Financial Applications.

• Introducing Array Formulas.

• Performing Magic with Array Formulas.

Part III: Creating Charts and Graphics.

• Getting Started Making Charts.

• Learning Advanced Charting.

• Visualizing Data Using Conditional Formatting.

• Creating Sparkline Graphics.

• Enhancing Your Work with Pictures and Drawings.

Part IV: Using Advanced Excel Features.

• Customizing the Excel User Interface.

• Using Custom Number Formats.

• Using Data Validation.

• Creating and Using Worksheet Outlines.

• Linking and Consolidating Worksheets.

• Excel and the Internet.

• Sharing Data with Other Office Applications.

• Using Excel in a Workgroup.

• Protecting Your Work.

• Making Your Worksheets Error-Free.

Part V: Analyzing Data with Excel.

• Getting Data from External Database Files.

• Introducing Pivot Tables.

• Analyzing Data with Pivot Tables.

• Performing Spreadsheet What-If Analysis.

• Analyzing Data Using Goal Seeking and Solver.

• Analyzing Data with the Analysis ToolPak.

Part VI: Programming Excel with VBA.

• Introducing Visual Basic for Applications.

• Creating Custom Worksheet Functions.

• Creating UserForms.

• Using UserForm Controls in a Worksheet.

• Working with Excel Events.

• VBA Examples

• 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.