COURSE
OUTLINE
Lesson
1: Customizing the Work Area
Topic 1A: Working with Built-in Toolbars
Topic 1B: Using Custom Toolbars
Topic 1C: Creating and Using Styles
Topic 1D: Using Templates
Lesson
2: Advanced Formula Construction
Topic 2A: Using Names
Topic 2B: Using the IF Function
Topic 2C: Using the VLOOKUP Function
Topic 2D: Using IS Functions and the Auditing Features
Lesson
3: Using Pivot Tables
Topic 3A: Creating Pivot Tables
Topic 3B: Modifying Pivot Tables
Topic 3C: Grouping and Summarizing Data in a Pivot Table
Topic 3D: Creating Interactive PivotTables for the Web
Lesson
4: Working with Multiple Worksheets
Topic 4A: Working with Workbooks
Topic 4B: Linking Cells in Different Workbooks
Topic 4C: Workbook versus Links and Workspaces
Topic 4D: Sharing and Merging Workbooks
Lesson
5: Consolidating and Analyzing Data
Topic 5A: Consolidating Data from More than One Worksheet
Topic 5B: Using the Goal Seek and Solver Utilities
Topic 5C: Using Scenario Manager to View a Worksheet with Different
Input Values
Lesson
6: Using Protection and Display Options
Topic 6A: Using Comments
Topic 6B: Protecting Workbooks
Topic 6C: Using Custom Views
Lesson
7: Introduction to Macros
Topic 7A: Running Macros
Topic 7B: Recording a Macro
Topic 7C: Viewing and Editing VBA Code
Lesson
8: Working with Interactive Excel Web Documents
Topic 8A: Saving Excel Worksheets as Web Documents
Topic 8B: Spreadsheet Web Components
|
