Table of Contents

1. Creating a Worksheet and an Embedded Chart 2. Formulas, Functions, Formatting, and Web Queries 3. What-If Analysis, Charting, and Working with Large Worksheets Web Feature: Creating Static and Dynamic Web Pages Using Excel 4. Financial Functions, Data Tables, Amortization Schedules, and Hyperlinks 5. Creating, Sorting, and Querying a List 6. Creating Templates and Working with Multiple Worksheets and Workbooks Integration Feature: Object Linking and Embedding (OLE) and Web Discussions 7. Using Macros and Visual Basic for Applications (VBA) with Excel 8. Formula Auditing, Data Validation, and Complex Problem Solving 9. Importing Data, Working with XML, PivotCharts, PivotTables, and Trendlines PivotTable List Feature: Creating a PivotTable List Web Page Using Excel Appendices A: Microsoft Excel Help System B: Speech and Handwriting Recognition and Speech Playback C: Publishing Office Web Pages to a Web Server D: Changing Screen Resolution and Resetting the Excel Toolbars and Menus E: Microsoft Office Specialist Certification