How to Do Everything with Microsoft Office Excel 2003 (Paperback)

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