The Excel PivotTables Guide – online

This online course in Excel PivotTables will take you step by step through the powerful tool which is the PivotTable. The course will teach you how to arrange, group, filter and sort your PivotTables in new, more effective ways.

Auktoriserad lönekonsult Auktoriserad redovisningskonsult Auktoriserad/godkänd revisor Controller Ekonomiassistent Ekonomichef/CFO Företagsekonom Lönekonsult Redovisningsansvarig/chef Redovisningskonsult Revisorsassistent Skatterådgivare/konsult

Course description

Pivot tables are perhaps the most powerful analysis tool in Excel, but many people do not use PivotTables because it appears more complex than it actually is.
If you spend a lot of time in Excel without using PivotTables, chances are that you spend a lot of time calculating, summarizing and analysing things that Excel can do for you.
By creating a PivotTable it is easier to see comparison, patterns and trend in your data. 

The aim of the course is that you will be able to efficiently navigate in Excel in order to analyse and visualize data with a Pivot table.

Information about the course

  • Full access for 12 months
  • 20 lessons divided into 10 chapters
  • Total video time: 2 hours
  • Average length per lesson: 2 min 30 sec

Expenditure of time

The online course consists of 50 short lessons which in total will be about 2 hours in video time. You have access to the course for 12 months so you can go back and repeat.

The purpose of the online course is for you to quickly become a convenient and more efficient user of Excel and make Excel an important tool in your work. You will learn how to master PivotTables and functionalities that help you save time and increase the quality in

After the course, Excel will be a more natural tool in your work. Among other things, you will have learned how to manage a database and analyse data using PivotTables. See the course chapters for further information.

The online course is a collaboration between FAR and Learnesy.

Chapters

  1. Introduction to PivotTables
  2. Creating a PivotTable
  3. Grouping a PivotTable
  4. Sorting a PivotTable
  5. Filtering a PivotTable
  6. Slicers
  7. Calculated Fields and Items
  8. Formatting a PivotTable
  9. PivotCharts
  10. Tips and Tricks for PivotTables

Information

Basic skills in Excel is required.

The lessons are based on Excel 2019 and will work well for all users with Office 2007/2010/2013/2016/365.

This course is also available in Swedish:
Excelkurs fördjupning pivottabeller

Lärare

Video example