Course Outline

MS Excel 2016 - Expert

This Expert level course is aimed at learners who want to get the most out of MS Excel and who have a very good practical knowledge of using MS Excel.

By the end of this course you will be to create dynamic ranges, use ISERR, ISBLANK and ISNA functions and DSUM and DCOUNT.  You will also take macros to another level by exploring the Visual Basic Editor and turning off screen flashing. Lastly you will explore further features with pivot tables such as filtering fields and calculated items

Estimated Course duration is 3 - 4 hours.  Each lesson take on average 3-5 minutes to complete.

Go to the Learning Tips to view the learning objectives for this course.

Course Details

Advanced Features

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

More on Pivot Tables

Grouping Fields
Creating Calculated Fields
Creating Calculated Items
Creating Filter Fields
Showing Filter Page Fields
Drilling Down into the Data
Creating a Table from Multiple Ranges
Using VLookup In 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
Creating a Worksheet Function
Using a Worksheet Function
Distribute a Worksheet Function

Excel Integration

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

Information Functions

ISERR
ISERROR
ISBLANK
ISNUMBER
ISNA

Database Functions

DSUM and DCOUNT
DMIN and DMAX
DAVERAGE
Course Highlights
Expert 3-4hrs
For more than 50 licences enquire here.