Excel for Data Analysis

If you already use Excel but feel slow or stuck, this course takes you to the level employers look for. You will clean messy data, combine tables with lookups, summarise thousands of rows with pivot tables and build a dashboard that updates itself. Every lesson uses realistic sales, inventory and staff data.

• Write IF, COUNTIFS, SUMIFS and XLOOKUP formulas with confidence
• Clean and prepare messy data quickly
• Summarise large tables with pivot tables
• Build charts that make trends obvious
• Create an interactive dashboard with slicers
• Protect and share workbooks safely

1. 01

   Formulas that do the work

   Relative and absolute references, IF, AND, OR, plus text and date functions.

2. 02

   Cleaning messy data

   Removing duplicates, splitting columns, fixing formats and using Flash Fill.

3. 03

   Lookups and joining tables

   VLOOKUP, XLOOKUP and INDEX MATCH to bring data together from different sheets.

4. 04

   Pivot tables

   Summarising, grouping and filtering thousands of rows in seconds.

5. 05

   Dashboards

   Charts, slicers and conditional formatting combined into a one page report.