Excel 3

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

Contact