MS Excel - 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 
  • use DSUM, DMIN, DMAX and DCOUNT
  • take macros to another level by exploring the Visual Basic Editor and turning off screen flashing
  • 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.

You can also access our Quick Tip Videos, that only last a few minutes, under Tips and Tricks.



Course Content

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