+44 (0)20 3283 8799 enquiries@bitesizeltd.com
Log in
+44 (0)20 3283 8799 enquiries@bitesizeltd.com
Excel

MS Excel Course Outline – Expert level

Course Description

This expert MS Excel 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 able 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 takes on average 3-5 minutes to complete.
Download PDF

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

ISERR
ISERROR
ISBLANK
ISNUMBER
ISNA

Database Functions

DSUM and DCOUNT
DMIN and DMAX
DAVERAGE

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.

GET IN TOUCH

On-line courses

Face to face Workshops

Virtual On-line Classes

On-line Shop for 1 to 50 licences

Personalise your own course

Create your own branded learning site
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!

Sign Up See our Tips