Duration
1 Day
Description
A practical intermediate Excel course focused on analysing and organising data more efficiently. Learn to use lookups, pivot tables, data validation, and intermediate formulas to produce clearer reports and make better decisions.
Who should attend:
People who already use Excel for everyday tasks and want stronger data analysis and reporting skills.
What you'll learn
-
Build reliable lookup formulas
-
Summarise data with PivotTables
-
Create charts from PivotTables
-
Control data entry with data validation
-
Use intermediate formulas to analyse data
-
Organise data for clearer reporting
Course topics
-
Lookup functions
-
PivotTables and PivotCharts
-
Data validation
-
Intermediate formulas
-
Data organisation
-
Reporting best practices
