| Dates for this class: |
| No dates are available for this class. |
| Course Details [choose new course] [printable version] |
| Excel 2002: Advanced |
| Course Number: AP0055 |
| Category: Business & Office Applications |
| Duration: 1.00 day |
Description
This ILT Series course builds on the skills taught in Excel 2002: Intermediate. In this advanced course, students will learn how to create nested functions, export and import data, create PivotTables, record and run macros, and publish worksheets as Web pages. Course activities also cover using the Goal Seek and Solver utilities to perform what-if analyses. This course maps to Microsoft Office Specialist exam objectives. The manual is designed for quick scanning in the classroom and filled with interactive exercises that help ensure student success.
Outline
- Unit 1: Working with advanced formulas
- Topic A: Using names
- Topic B: Decision-making functions
- Topic C: Creating nested functions
- Topic D: Using financial functions
- Unit 2: Lookups and data tables
- Topic A: Working with lookup functions
- Topic B: Using MATCH and INDEX
- Topic C: Creating data tables
- Unit 3: Advanced list management
- Topic A: Creating subtotals
- Topic B: Validating cell entries
- Topic C: Exploring database functions
- Topic D: Working with data forms
- Unit 4: Working with PivotTables
- Topic A: PivotTables
- Topic B: Rearranging PivotTables
- Topic C: Formatting PivotTables
- Topic D: Working with PivotCharts
- Unit 5: Exporting and importing
- Topic A: Exporting and importing data
- Topic B: Querying external databases
- Unit 6: Unit analytical options
- Topic A: Working with Goal Seek and Solver
- Topic B: Working with scenarios
- Topic C: Working with views
- Unit 7: Working with macros
- Topic A: Running and recording a macro
- Topic B: Working with VBA code
- Topic C: Function procedures
- Unit 8: Interactive Web pages
- Topic A: Creating interactive Web spreadsheets
- Topic B: Publishing PivotTables on the Web
- Appendix A: MOUS exam objectives map
- Topic A: Core exam objectives
- Topic B: Expert exam objectives