Excel

MS Excel Course Outline – Master level

Topics Covered

Financial Functions

Financial Functions PMT
Financial Functions FV
RATE

Lookup Functions

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

Logical functions

IFERROR

Conditional Formatting

Creating Rules
Creating Rules Using Formulas

PivotTables & Pivot Charts

Working with Pivot Tables
Rearranging Pivot Tables
Slicers
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
Protection
Workbook Collaboration

Custom Sorts

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

Macros

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

Analytical Options

Goal Seek
Solver
The Analysis Toolpak
Scenarios

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.

bitsy

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!