Part of the highly successful Shelly Cashman series, this comprehensive text provides a clear step-by-step, screen-by-screen approach to learning basic and advanced Microsoft Excel 2000 skills.
Table of Contents
1. Creating a Worksheet and 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 Worksheet Database 6. Creating Templates and Working with Multiple Worksheets and Workbooks Integration Feature: Linking an Excel Worksheet to a Word Document 7. Using Visual Basic for Applications (VBA) with Excel 8. Auditing, Data Validation, and Solving Complex Problems 9. Importing External Data, Tracking and Routing Changes, and Creating Data Maps, PivotCharts and PivotTables Web Feature: Creating a PivotTable List Web Page Using Excel Appendices A: Microsoft Excel 2000 Help System B: Publishing Office Web Pages to a Web Server C: Resetting the Excel Menus and Toolbars D: Microsoft Office User Specialist Certification Program.