The Fastest, Easiest Way to Learn Excel 2003 Advanced!
Professor Teaches courses use real-world settings and accurate simulations to help you apply your new knowledge directly to daily tasks and the knowledge you gain becomes an asset for life.

Chapter #1. Using Formatting and Functions
• Applying Formatting to Numbers
• Creating Custom Number Formats
• Applying Conditional Formats
• Using Formulas in Conditional Formats
• Naming a Range
• Using a Named Range in a Formula
• Using Lookup Functions

Chapter #2. Using Templates and Workbooks
• Applying a Template
• Using a Template
• Creating a New Template
• Editing a Template
• Using a Workspace
• Linking between Workbooks
• Importing Data from Text Files
• Importing Data from Other Applications
• Importing an HTML Table
• Publishing Data to the Web

Chapter #3. Working with Data
• What is a List?
• Validating Data Entries
• Sorting Data
• Subtotaling and Outlining Data
• Extracting Data with Filters
• Using Advanced Filters
• Using Query
• Querying the Web
• Using XML to Share Data

Chapter #4. Analyzing Data
• Using PivotTables
• Managing PivotTable Reports
• Creating PivotChart Reports
• Using Charts and Trendlines
• Working with Scenarios

Chapter #5. Using Macros and Auditing Tools
• What is a Macro?
• Recording a Macro
• Running a Macro
• Editing a Macro
• Customizing a Toolbar
• Creating a Custom Menu
• Auditing Workbooks
• Tracing Errors

Chapter #6. Sharing Workbooks
• Creating a Shared Workbook
• Merging Workbooks
• Consolidating Data
• Protecting Columns
• Protecting Worksheets
• Protecting Worksheet Contents
• Protecting Cells
• Assigning a Password
• Tracking Changes
• Adding Comments