Excel 2007 - Level 3
Location: Latham
Use advanced formulas, create lookups and data tables, use advanced
list management techniques, analyze data with PivotTables and PivotCharts,
export and import data, automate tasks with macros and custom functions.
Recommended Preparation: Excel
2007- Level 2 or equivalent knowledge.
Lesson 1: Advanced formulas
- Using decision-making functions
- Creating nested functions
- Using financial functions
Lesson 2: Lookups and data tables
- Using lookup functions
- Using MATCH and INDEX
- Creating data tables
Lesson 3: Advanced list management
- Validating cell entries
- Exploring database functions
Lesson 4: PivotTables and PivotCharts
- Working with PivotTables
- Rearranging PivotTables
- Formatting PivotTables
- PivotCharts
|
|
Lesson 5: Exporting and importing
- Exporting and importing text files
- Exporting and importing XML data
- Querying external databases
Lesson 6: Analytical options
- Goal Seek and Solver
- The Analysis ToolPak
- Scenarios
- Views
Lesson 7: Macros and custom functions
- Running and recording a macro
- Working with VBA code
- Function procedures
|
| Course Fee: $169 |
Members: $159 |
|
|
|
|
|
Upcoming Class Schedules |
|
# 3012 |
Mon Sept 13 |
8:30am-4:30pm |
|
