MS Excel Course Outline – Expert level

Topics Covered

Advanced Features

Creating a Dynamic Range Name
Assigning a Name to a Formula
Applying Custom Data Validation
Using Offset Functions

More on Pivot Tables

Creating Calculated Fields
Creating Calculated Items
Creating Filter Fields
Showing Filter Page Fields
Drilling Down into the Data
Creating a Table From Multiple Ranges
Grouping Fields
Using VLOOKUPs with Pivots

Working with Macros

Assign a Macro to a Worksheet Control
Exploring the Visual Basic Editor
Making Simple Changes to a Macro
Turn Off Screen Flashing
Create a Worksheet Function
Using a Worksheet Function
Distribute a Worksheet Function

Excel Integration

Create a Hyperlink in a Cell
Hyperlink to a Website or File
Hyperlink to a Location in a Workbook
Hyperlink to a Email Address
Add a Hyperlink to a Graphic
Using Excel Data in Word
Using Excel Charts in Word
Using Excel Data as a Mail Merge

Information Functions


Database Functions


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!