Analysing Data in Excel

Who is the course for?

The primary audience for this course are the vast majority of knowledge workers who use Excel every week but could easily do so more effectively, faster and with more confidence.

This includes professional knowledge workers, university students and recent graduates, in-career professionals who want to upskill, and those returning to work.

What topics will you cover?

The course covers the fundamental skills, tools and functions to be competent at analysing data in Excel. Including:

Excel functions

Excel formulae

PivotTables, conditional formatting, timelines, and slicers

PivotCharts

Spreadsheet management/efficiency

Excel shortcuts/commands

Thinking like a data analyst

What will you achieve?

By the end of the course, you‘ll be able to…

Produce a range of spreadsheets, including a cleaned data set, PivotTables, PivotCharts

Apply Excel formulae – such as concatenate, trim, and proper – to data sets to clean and analyse data

Calculate mathematical functions including averages, counts and sums

Identify which Excel functions and formulae are appropriate to perform mathematical functions, clean and interpret data, and answer business questions

Improve decision making, thinking efficiency and problem solving in Excel

Apply numerical and visual formatting, including conditional formatting, slicers and timelines, to spreadsheets to produce clean and comprehensible workbooks