Excel Advanced
Excel Advanced 2010
Topics:
Lesson 1: Logical and Lookup Functions
- Topic A: Decision-making Functions
- Topic B: Lookup and Reference Functions
Lesson 2: Advanced Formulas
- Topic A: Auditing and Error-trapping
- Topic B: Formula Options
- Topics C: Arrays
Lesson 3: Special Functions
- Topic A: Date and Time Functions
- Topic B: Text Functions
- Topic C: Other Functions
Lesson 4: Importing and Exporting
- Topic A: External Data
- Topic B: Exporting Data
Lesson 5: Analysis
- Topic A: What-if Analysis
- Topic B: The Analysis Toolpak
Lesson 6: Macros and Forms
- Topic A: Recording Macros
- Topic B: Running Macros
- Topic C: Forms
Course Hours: 8 hours
Excel Advanced 2013
Topics:
Lesson 1: Logical and Lookup Functions
- Topic A: Decision-making Functions
- Topic B: Lookup and Reference Functions
Lesson 2: Advanced Formulas
- Topic A: Auditing and Error-trapping
- Topic B: Formula Options
- Topics C: Arrays
Lesson 3: Special Functions
- Topic A: Date and Time Functions
- Topic B: Text Functions
- Topic C: Other Functions
Lesson 4: Importing and Exporting
- Topic A: External Data
- Topic B: Exporting Data
Lesson 5: Analysis
- Topic A: What-if Analysis
- Topic B: The Analysis Toolpak
Lesson 6: Macros and Forms
- Topic A: Recording Macros
- Topic B: Running Macros
- Topic C: Forms
Course Hours: 8 hours
Excel Advanced 2016
Topics:
Lesson 1: Logical and Lookup Functions
- Topic A: Decision-making Functions
- Topic B: Lookup and Reference Functions
Lesson 2: Advanced Formulas
- Topic A: Auditing and Error-trapping
- Topic B: Formula Options
- Topics C: Arrays
Lesson 3: Special Functions
- Topic A: Date and Time Functions
- Topic B: Text Functions
- Topic C: Other Functions
Lesson 4: Importing and Exporting
- Topic A: The Power Pivot Data Model
- Topic B: Exporting Data
Lesson 5: Analysis
- Topic A: What-if Analysis
- Topic B: The Analysis Toolpak
Lesson 6: Macros and Forms
- Topic A: Recording Macros
- Topic B: Running Macros
- Topic C: Forms
Course Hours: 8 hours