Microsoft Office & 365 Apps
Excel - Get your Data to Pivot
A one-hour live class on creating PivotTables from scratch, analysing and restructuring data with them.
1 hourIntermediate1 modules
About this course
A one-hour live class on creating PivotTables from scratch, analysing and restructuring data with them.
Curriculum
1 modules
- Learn what PivotTables are, how to create them from scratch, or use premade formats
- Create a pivot table, analyze, restructure, organize and filter data in a pivot table
- Learn to format values, refresh your data, and use table tools on the ribbon
- Summarize data, learn how to redesign and make your pivotable look presentable
- Filter data quickly with slicers and timelines.
- Visualize PivotTable data with PivotCharts, watch how quickly data will automate
Who it's for
Excel users new to PivotTables.
Before you start
No formal prerequisites. Bring curiosity and a willingness to practise.
Related courses
More in Microsoft Office & 365 Apps →Advanced
55205 Mastering Microsoft Project 2016
Microsoft Office & 365 Apps
View course →Intermediate
55234 SharePoint 2016 Site Collections and Site Owner Administration
Microsoft Office & 365 Apps
View course →Intermediate
55238 SharePoint Online for Administrators
Microsoft Office & 365 Apps
View course →Advanced
55301 Mastering Microsoft Project 2019
Microsoft Office & 365 Apps
View course →Intermediate
55342 Supporting and Troubleshooting Windows 11
Microsoft Office & 365 Apps
View course →Intermediate
Access - Customize Tables
Microsoft Office & 365 Apps
View course →Let's plan your next step together.
Tell us the course or certification you have in mind and we'll send the outline, upcoming dates, fees and private-team options.