How To Do Everything With Excel 2003

Description

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

Author description

Kate J. Chase (Marshfield, VT) is an author, journalist, and online technical support consultant who has written, contributed to, or edited more than a dozen PC reference books, including PC Disaster and Recovery (Sybex, Christmas 2002) and Instant E-Commerce! (Sybex, 2001), as well as Windows XP Power Tools (Sybex, 2002), Office XP Complete (Sybex, 2002), Microsoft Office 2000 Troubleshooting and Problem Solving (Course Technology, 2000), and The IRQ Book (McGraw-Hill, 1999). Kate has been an active participant in Microsoft's Office beta program and has been using the Office 11 beta since November. Her work has appeared on Microsoft.com's Office Web site as well on the Microsoft Network, America Online and ZDnet in addition to her books in print.

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