Skip to main content


Excel Intermediate:

This course is quite heavy formula based introducing Ifs, vlookups and linking data between sheets, also you will look at working with large amounts of data helping to sort, filer and hide data.

Course Outline
Excel Intermediate 1 Day

Who is it for?

The course is suitable for existing users of Microsoft Excel and focuses on working with large spreadsheets, manipulating data, using more advanced formulae and functions and advanced charting techniques.


Delegates should have a basic knowledge of the Introduction outline.

An in-depth look into:
  • IF’s and Lookup Functions
  • Worksheet/Workbook Linking
  • Calculating with Dates
  • Subtotals
Data Manipulation
Controlling data using:
  • Dynamic Ranges
  • Auto Filtering
  • Grouping and Outlining
  • Freeze Panes Sorting Data
  • Working with Comments
Manipulating Worksheets using:
  • Named Ranges
  • Conditional Formatting
  • Hiding/Un-hiding Data
  • Password Protecting Worksheets
  • Protecting Specific Cells
  • Changing Default Options
Advanced Charting
Building on basic Charting using:
  • Combining Multi-Chart Types
  • Custom Chart Formats
  • Creating Secondary Axis

Microsoft Excel, Software