This course is also available in: Norsk Norsk Svenska Svenska
The Excel PivotTables Guide

Become an expert in Excel's most fundamental data analysis tool

With this course, you’ll quickly and efficiently learn how to set up and analyse databases. Once you’re able to analyse data at a deeper level, you will then be able to produce sustainable decision-making data and relevant key figures from databases more quickly.

  • Complete the course at your own pace
  • Repeat as much as you want
  • Practical exercises and quizzes
  • Personal and digitally shareable diploma
  • Save lessons as favorites
  • The course takes about 4 hours to complete
  • Access to the course material for 12 months
  • Unlock the potential of your data by learning pivot tables
Buy this course 249 kr / month
Take parts of the course free of charge

Try some lessons in this course for free

Fill in your e-mail address and telephone and we will give you 7 days free access to some lessons in this course.

No card required!
Learnesy
4.9
Based on 143 reviews
powered by Google
js_loader

Some of the things you will learn in this course:

PivotTable basics

In this course, you’ll start by quickly and efficiently learning the basics of PivotTables, including how the database is structured, how it is updated, and why you should always create a table of the database before you make a PivotTable.

Analyse all types of data

This course helps you analyze all kinds of data, whether it’s revenue over time, costs broken down by department, analysing responses in a survey, etc.

Group data

Many databases contain a column made up of dates or times. This means that in your PivotTable you may need to analyse data and key figures by year, quarter, month, week, or day. PivotTables allow you to efficiently group based on dates, something you’ll learn in this course.

PivotCharts and slicers

It can sometimes be easier to analyse data by seeing it, for example, in the form of a bar or pie chart. It’s an effective way to visually present data after you’ve finished an analysis for a colleague or manager. The combination of charts and slicers can be magical and lifts your PivotTables to new heights.

A lesson from the course

In this lesson from The Excel PivotTables Guide, you will learn how pivot table slicers work. This is one of four lessons from the “Slicers” chapter. If you have previously come across report filters, a slicer can be compared to it, but slicers have the advantage of being easier to use. Slicers give us buttons that work just like filters, which makes them very smooth.

The Excel PivotTables Guide is one of Learnesy’s in-depth Excel courses. Pivot tables are used to summarize, analyze, explore and present data. What is the difference between pivot tables and regular tables in Excel? A normal table in Excel is a representation of the facts and figures you have entered. A pivot table, on the other hand, summarizes data that includes different types of aggregation such as mean and sum. Another advantage is the pivot table’s filters that help you easily analyze your data.

Course Content

Expand All
Chapter Content
0% Complete 0/5 Steps
What is a Pivot Table
How to Create a Pivot Table
Updating the Pivot Table
Viewing the Underlying Data
Important Terms
Chapter Content
0% Complete 0/12 Steps
Using a Table for the Pivot Table
Add Fields to the Pivot Table
Arranging the Pivot Table Fields
Access the Field Settings
Format Numbers in the Pivot Table
Change Calculations for Numeric Fields
Manage Totals
Manage Subtotals
Renaming Fields
Add a Field Multiple Times
Pivot Table Layouts
Create a Pivot Table with multiple sources
Chapter Content
0% Complete 0/4 Steps
Group Data Manually
Group by Value
Group by Date
Hide and Unhide Pivot Table Groups
Chapter Content
0% Complete 0/4 Steps
Sorting the Pivot Table Alphabetically
Sorting Manually
Sorting by Values
Sorting with a Customised List
Chapter Content
0% Complete 0/4 Steps
Using Slicers in the Pivot Table
Slicer Options
Slicer Format
One Slicer for Multiple Pivot Tables
Chapter Content
0% Complete 0/4 Steps
Adding a Calculated Field
Modifying the Calculated Field
Adding a Calculated Item
Modifying Calculated Items
Chapter Content
0% Complete 0/3 Steps
Apply a Pivot Table Format
Custom Pivot Table Formats
Copy the Format to Another Workbook
Chapter Content
0% Complete 0/5 Steps
Create a Pivot Chart
Change the Chart Type
Pivot Chart Options
Filter the Pivot Chart
Create Additional Pivot Charts
Chapter Content
0% Complete 0/4 Steps
Independent Pivot Tables
Group by Weekday
Copy a Pivot Table
Group by Age Range

More about the course

In this online course, you will learn how to create a pivot table, sort, group, manage sums, and perform calculations in a pivot table. With the help of pivot tables, you will learn to quickly summarize large amounts of data. Use pivot tables to analyze data in detail, and get answers to unexpected questions about your data. After completing the course, you will be able to analyze data at a deeper level. To benefit from the course, you need to have basic knowledge of Excel and an understanding of how tables work.

  • Approximately 50 lessons divided into 10 chapters.
  • Total video time: 2 hours.
  • Estimated time to take the course including quizzes: 4 hours.
  • Average duration per lesson: 2.5 minutes.
  • Personal shareable certificate after completing the course.
certificate of course completion The Excel PivotTables Guide Sarah Anderson It is hereby certified that Sarah Anderson has with diligence and commendable efforts completed Learnesy's online course The Excel PivotTables Guide

Course manager

Emil

Course creator, Learnesy

Hello!

My name is Emil and I work as an instructor at Learnesy, where I have been teaching Excel for many years. My goal with this pivot table course is to make you not only proficient in creating and analyzing pivot tables but also confident in your ability to use these skills effectively in your work. Therefore, I have focused on simplifying complex ideas into clear and understandable steps, making the course ideal even for those who are new to this area.

I have integrated feedback from previous participants in the design of the course to ensure it meets various needs and learning styles, which has enriched the course content and made it more accessible for everyone.

I am convinced that a deep understanding of pivot tables provides you with a powerful tool for managing and analyzing data. I look forward to sharing this knowledge with you!

If you have any questions, do not hesitate to reach out to me at:
emil@learnesy.com

Choose what suits you best:

The Excel PivotTables Guide

  • Choose the course that suits your needs
  • Access to all material 24/7 for 12 months
  • Complete the course at your convenience
  • Repeat freely throughout the access period
  • The course is maintained and updated
  • Personal and digitally shareable diploma
  • Save your favorite lessons
  • Contact us and we will help you choose the right one!
249 kr / month 2988 kr billed yearly. VAT will be applied.
Take this course

Pay with card/Klarna or invoice (pay within 30 days) for larger groups.

All courses

  • Access to the entire course catalog
  • Access 24/7 for 12 months
  • Complete the courses at your convenience
  • Repeat freely throughout the access period
  • Courses that are maintained and updated
  • Personal and digitally shareable diploma by course
  • Save your favorite lessons
  • Take full courses or see only the lessons you need
  • Contact us and we will help you get started today!
599 kr / month
7188 kr billed yearly. VAT will be applied.
Take all courses

Pay with card/Klarna or invoice (pay within 30 days) for larger groups.

For teams

  • Personal Account Manager
  • Personal account for all users
  • Choose the courses that suits your needs
  • Multi-user discounts
  • Optional Kickoff at startup
  • Statistics via Data Insight
  • Technical support
  • Unique login domain
Offer

Prices excluding VAT

FAQ

Who should enroll this course?

This course is for those who have previously taken the course Excel Essentials or who have basic Excel skills, as this is one of Learnesy’s intermediate courses in Excel.

Is there exercises in this course?

This course includes many and short exercises. If you want to follow along with the lessons, you can do so by downloading the files that are attached to each lesson.

All chapters end with a quiz. With some questions there’s a downloadable resource which is needed to solve said exercise. 

I HAVE PREVIOUSLY LEARNED Pivot tables IN the Excel Essentials COURSE – IS THIS COURSE FOR ME?

Yes, if you have previously taken the Excel Essentials course, this course will give you a much deeper understanding and practical knowledge of Excel PivotTables.

I HAVE USED EXCEL BEFORE. IS THIS COURSE FOR ME?

Yes. This comprehensive course contains lots of useful features and tips. However, this course requires some prior knowledge in Excel. If you feel that you need to repeat the Excel basics instead, you can take our course Excel Essentials.

HOW LONG DOES IT TAKE TO COMPLETE THE COURSE?

This course takes about 4 hours to complete. To pass the course and receive your diploma, you must complete all the lessons and quizzes that make up each chapter. If, on the other hand, you want to download the lesson materials and follow along practically in each lesson yourself, this course will take a little longer.

WHERE CAN I GO IF I NEED HELP WITH THE CONTENT OF THE COURSE?

If you need help, you can visit our forum or contact us at support@learnesy.com.

We are an enterprise, a team or a school needing a intermediate Excel course. How do we proceed?

Do you want to learn Excel PivotTables and are looking for a business solution for your group? Then get in touch at foretag@learnesy.com.

If you are an educational institution that wants to offer its students supplementary Excel training, you can contact sales@learnesy.com.

Deloitte Deloitte Deloitte