Title: Intermediate Excel

Venue: Online

Description: The purpose of the course:

The Intermediate Excel course focuses on more in depth formulas and data handling.

Benefits for your organisation:

This course builds on the knowledge of the introduction to Excel course by showing the user how to get more out of the programme. Delegates will learn to work with Dynamic Ranges meaning spreadsheets will remain up to date even when new data is added.

Who is this course for?

Anyone who is familiar with the basic features of Excel together with basic formulas will benefit from attending this course. This course places great emphasis upon the importance of understanding how to build the spreadsheet correctly with Dynamic Ranges. It is therefore important that participants are at the appropriate level to ensure a good learning experience.

What will the course cover?

An in-depth look into:

IF’s and VLOOKUP functions
Worksheet/workbook linking
Calculating with dates
Subtotals

Controlling data using:

Dynamic Ranges
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

Advanced Chartering – Building on basic chartering using:

Combining multi-chart types
Custom chart formats
Creating secondary axis

By the end of this course you will be able to:

Combine Dynamic Ranges with formulas
Use the ‘IF function’ to set answers based on criteria
Use VLOOKUP tables to find the answers to complex queries
Design and manage long lists of data
Sort, filter and subtotal lists
Group columns to collapse or expand a list of data
Link worksheets and workbooks creating summary pages

Total Places: 8

Places Available: 3

NonMember Cost: £319.00 + VAT

Member Cost: £259.00 + VAT

Date: 03/06/2025

Start Time: 09:30

End Time: 15:30