Course description
The Excel PivotTables Guide is an online course that provides a practical and structured introduction to working with PivotTables in Excel. The course is aimed at accountants, controllers and other finance professionals who need to analyse, summarise and present large volumes of data in a clear and efficient way. You will learn how to create PivotTables from raw data, structure information using rows, columns and values, and apply filters to gain relevant insights. The course also covers grouping, calculated fields and basic formatting to support professional reporting. Through concise video lessons and applied examples, the course focuses on practical use cases commonly encountered in financial analysis and follow up. After completing the course, you will be able to work more independently with PivotTables and produce reliable summaries that support data driven decision making.
Information about the course
- Online course with access to the learning platform for 12 months
- Advanced Excel course focusing on PivotTables
- Video based learning combined with practical exercises
- Self-paced studies
- Certificate upon completion
- 3 Continuing professional education hours
Expenditure of time
The online course consists of 50 short lessons, totaling approximately two hours of video content. You will have access to the course for 12 months, allowing you to revisit and repeat the material at your own pace.
The purpose of the course is to give you a clear understanding of how PivotTables work and how they can be used to analyse and summarise data efficiently in Excel. The focus is on practical application in financial work.
After completing the course, you will be able to independently create and use PivotTables to analyse large data sets, identify patterns and present results in a structured and professional manner. This enables more efficient analysis and reporting.
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 is suitable for professionals who work with data and want to improve their analytical efficiency. The training is delivered fully online and can be completed at your own pace during the access period. The course content is recorded in modern versions of Excel and is applicable in current Excel environments. The course is continuously maintained and updated by Learnesy’s own course developers.
This course is also available in Swedish: Excelkurs fördjupning pivottabeller