Analysing Data in Excel
Discover all the fundamental data skills, tools and functions in order to make you a pro at using Microsoft 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:
PivotTables, conditional formatting, timelines, and slicers
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