Table of Contents

Part I: Get Started with Excel and Create Worksheets 1: Get Started with Excel 2: Configure Excel to Suit Your Working Needs 3: Create Spreadsheets and Enter Data 4: Format Worksheets for Best Effect 5: Add Graphics and Drawings to Worksheets 6: Check, Lay Out, and Print Worksheets Part II: Calculate, Manipulate, and Analyze Data 7: Perform Calculations with Functions 8: Create Formulas to Perform Custom Calculations 9: Organize Data with Excel Databases 10: Outline and Consolidate Worksheets 11: Analyze Data Using PivotTables and PivotCharts 12: Solve Problems by Performing What-If Analysis Part III: Share, Publish, and Present Data 13: Create Effective Charts to Present Data Visually 14: Share Workbooks and Collaborate with Colleagues 15: Using Excel’s Web Capabilities 16: Use Excel with the Other Office Applications Part IV: Customize and Automate Excel 17: Customize Excel’s Interface 18: Use Macros to Automate Tasks Appendix: Keyboard Shortcuts

About the Author

Guy Hart-Davis (Barnard Castle, UK) is the author of more than 60 computer books, including all editions of How to Do Everything: iPod, iPhone, & iTunes, iPad and iPhone Administrators Guide, Integrating Macs in Windows Networks, and Mac OS X System Administration.