← Back to courses
Data Science and AI
Excel PivotTables in a Week
Summarise thousands of rows without a single formula
A one-week classroom course on the PivotTable and import-and-analyse areas of Microsoft's own Excel training. You import a dataset, prepare it, summarise it with PivotTables and present the result. This course prepares for no exam.
5Modules
BeginnerLevel
1 weekDuration
COURSE THUMBNAIL
What you will be able to do
Turn raw rows into a PivotTable summary
Group and filter to answer a specific question
Present the result as a chart and a one-page report
Course outline
01
Importing data and shaping it as a table
02
Creating a first PivotTable
03
Grouping, filtering and sorting
04
Calculations inside a PivotTable
05
PivotCharts and a one-page report
Tools you will use
Microsoft ExcelPivotTables
What you need
Basic use of Excel
