Course description
The Excel PivotTables Guide is an online course for users with basic Excel knowledge who want to become more confident in analyzing and summarizing data with PivotTables. The course is relevant for professionals who work with reporting, follow-up or data analysis and need an efficient way to explore larger datasets.
You will learn how to create PivotTables from structured data and work with rows, columns, values and fields. The course then takes you through grouping, sorting and filtering, as well as slicers, calculated fields and items, formatting and PivotCharts.
The practical examples show how PivotTables can be used to analyze different types of data, such as revenue over time, costs by department or survey responses. The aim is to help you answer questions quickly, identify patterns and create clear summaries without having to build complex formulas for every analysis.
Through short video lessons, quizzes and hands-on exercises, you build skills that can be applied directly in your daily work with Excel.
Information about the course
- Online course with access to the learning platform for 12 months
- Suitable for users with basic Excel knowledge
- Approximately 50 lessons divided into 10 chapters
- Approximately 2 hours of video content
- Estimated completion time: approximately 4 hours including quizzes
- Short lessons with practical examples and exercises
- Self-paced studies
- Personal and digitally shareable certificate upon completion
- 3 Continuing Professional Education hours
Expenditure of time
The online course consists of approximately 50 short lessons divided into 10 chapters, with around 2 hours of video content. The estimated time to complete the course, including quizzes and practical exercises, is approximately 4 hours.
You have access to the course for 12 months, allowing you to study at your own pace and revisit individual topics whenever you need to refresh your PivotTable skills.
After completing the course, you will be able to independently create, adapt and use PivotTables to summarize and analyze data, identify patterns and present results in a clear and structured way.
The online course is a collaboration between FAR and Learnesy.
Chapters
- Introduction to PivotTables
- Creating a PivotTable
- Grouping a PivotTable
- Sorting a PivotTable
- Filtering a PivotTable
- Slicers
- Calculated Fields and Items
- Formatting a PivotTable
- PivotCharts
- Tips and Tricks for PivotTables
Information
The course requires basic knowledge of Excel and an understanding of how regular Excel tables work. You do not need previous experience with PivotTables.
You will learn how to structure source data, create and update PivotTables, arrange fields, manage totals and subtotals, group dates and values, sort and filter information, and use slicers for interactive analysis.
The course also covers calculated fields and items, PivotTable formatting and PivotCharts. These tools help you move from raw data to clear summaries and visual analysis that can support reporting and decision-making.
The training is delivered fully online and can be completed at your own pace during the 12-month access period. The course is continuously maintained and updated by Learnesy's course developers
This course is also available in Swedish: Excelkurs fördjupning pivottabeller
Course scope
3 Continuing Professional Education hours