Excel 2003 - Level 3
Location: Latham
Use advanced formulas, data lookups, and advanced list management
techniques. Create PivotTables, use analysis tools. Export and import
data. Automate tasks with macros and VBA.
Recommended Preparation:
Excel 2003 - Level 2, or equivalent knowledge.
Lesson 1: Working with advanced formulas
- Using names
- Using decision-making functions
- Creating nested functions
- Using financial functions
Lesson 2: Lookups and data tables
- Working with lookup functions
- Using MATCH and INDEX
- Creating data tables
Lesson 3: Advanced list management
- Creating subtotals
- Validating cell entries
- Exploring database functions
- Working with data forms
Lesson 4: Working with PivotTables and PivotCharts
- Working with PivotTables
Rearranging PivotTables
- Formatting PivotTables
- Working with PivotCharts
|
|
Lesson 5: Exporting and importing
- Exporting and importing text files
- Exporting and importing XML data
- Querying external databases
Lesson 6: Using analytical options
- Working with Goal Seek and Solver
- Working with the Analysis ToolPak
- Working with scenarios
- Working with views
Lesson 7: Working with macros
- Running and recording a macro
- Working with VBA code
- Function procedures
Optional Topic: Interactive Web pages
- Creating interactive Web spreadsheets
- Publishing PivotTables on the Web
|
| Course Fee: $169 |
Members: $159 |
|
|
|
|
|
Upcoming Class Schedules |
|
# 3217 |
Fri Oct 15 |
8:30am-4:30pm |
|
