Home Specialist skills Technology and Software Excel Intermediate

Excel Intermediate

Learn how to use more advanced formulas and work with various tools to analyse data in spreadsheets, such as sorting, filtering, conditional formatting and auditing
Organise table data and present data as charts

Overview

Off the shelf (OTS)

The goal of this course is to provide you with the knowledge required to use more advanced formulas and work with various tools to analyse data in spreadsheets, such as sorting, filtering, conditional formatting and auditing. You will also organise table data and present data as charts.

This course is aimed at existing Excel users who need to further their knowledge. Learners are assumed to have experience of entering data and writing basic formulas, including common functions such as SUM and AVERAGE. The course emphasises hands-on experience, with a series of self-guided exercises integrated into the training.