MS Excel Course Outline – Master level

Topics Covered

Financial Functions

Financial Functions PMT
Financial Functions FV

Lookup Functions

Combining MATCH with INDEX
Combining LOOKUP with MATCH
Lookup Functions with Named Ranges

Logical functions


Conditional Formatting

Creating Rules
Creating Rules Using Formulas

PivotTables & Pivot Charts

Working with Pivot Tables
Rearranging Pivot Tables
Formatting Pivot Tables
Pivot Charts
Using GETPIVOTDATA with Pivot Tables

Documenting and Auditing

Auditing Features Formula Errors
Auditing Features Evaluate Formulas
Using the Watch Window
Comments in Cells and Workbooks
Validating Cell Entries
Workbook Collaboration

Custom Sorts

Sort a List by Value
Sort a List by Colour
Advanced Features
Converting Text to Columns


Explaining Macros
Macros Security Levels
Recording a Macro
Running a Macro
Assigning Macros to the QAT

Analytical Options

Goal Seek
The Analysis Toolpak

Data Tables

One Input Variable
Two Input Variable

Can't see what you need?

All Microsoft Office Online Courses are based on a typical one day training course at a specific skill level and are included in our full online library. If you require a more tailored course to meet a particular learning need, get in touch.

All Personal Development Online Courses are 15 minute modules that complement our Bite Size methodology and work well together to create a great training plan.

Great deals for Corporate licences – give us a call.


Sign up for our free weekly tip

Receive a free nugget of IT Learning every week! It will give you a good feel for how we write and design our lessons and you could learn something new every week too!