At your Convenience
We come to you or
you come to us
Wherever you are!

Build your own tailored course
Lots of options available

Good Value
Your company saves money
and your staff save time

What's New?
Remote Classroom Training...
...coming shortly!

It's Your Training!
When and Where
You want it

Welcome to Insight

Delivering private IT training from businesses,
public sector and voluntary organisations

Microsoft Excel Advanced

< Back to Microsoft and Office Courses | Insight IT Training

Course Details


Course Duration - One Day

Benefits of Microsoft Excel Advanced Course

This course is suitable for experienced users who wish to learn how to use the advanced features of Microsoft Excel. The course is 100% hands-on with exercises to help the trainees practice the new skills they learn.

As a professional in your field, you will already know about the advantages of using Microsoft Excel. There is a way to make it an even more powerful tool in the running of your business by attending our Advanced course. Excel training has been known to contribute to the improvement of employee efficiency by allowing everyday tasks to be finished more proficiently.

You may already be familiar with many of Excel's abilities, however our Advanced training will make you more skilful when working with multiple worksheets and workbooks, templates, pivot tables and charts. We will also take you through the advanced functions, macros and customisation options.

For success on our one day Microsoft Excel Advanced course, you should have attended the Intermediate, or equivalent level Excel course or have an in-depth knowledge of Microsoft Excel.

Basic Microsoft Excel is also available.

Course Content

Working with Multiple Worksheets

  • Inserting, moving, renaming, copying & deleting worksheets
  • Making changes to multiple worksheets
  • Creating formulae linking data on multiple worksheets

Working with Multiple Workbooks

  • Copying and moving data between workbooks
  • Creating formulae linking data in separate workbooks
  • Working with workspace files

Excel Templates

  • Creating a new template
  • Changing the default template style
  • Creating a new workbook based on a template


  • Create a Scenario
  • Display a Scenario
  • Create a Scenario Summary Report

Advanced Excel Functions

  • Using the VLOOKUP, IF and IFERROR functions
  • Using the COUNTIF(S) and SUMIF(S) functions

Customising Excel

  • Creating and displaying Views
  • Creating and using a Custom AutoFill
  • Outlining a worksheet

PivotTables and PivotCharts

  • Creating PivotTables & PivotCharts
  • Changing the layout of a PivotTable or PivotChart


  • Record a simple Macro


Trainees should have attended the Intermediate, or equivalent level, Excel course or have an in-depth knowledge of Microsoft Excel.

Contact Us

Interested in our service? Then get in touch today with Insight IT to see how we can tailor your training to suit your needs.

Call us on: 07889 216849. Alternatively contact us online here.