Online Excel Course: Pivot Tables

Get instant access

Get access to Pivot Tables now

Pivot Tables: Excel course for intermediates

‘Pivot Tables’ is the perfect Excel course if you’re an intermediate Excel-user.

In just 59 minutes, you’ll learn how to use pivot tables.

This is the quickest way to understand how pivot tables works and how to apply them in your current work.

  • 34 action-packed lessons
  • Project files to make your new knowledge stick
  • Free cheat sheet for easy repetition
  • (Re)view each lesson as many times as you’d like
  • Perfect if you’re intermediate
Get instant access

Course Curriculum

Here’s the complete list of modules and lessons ‘Pivot Tables’ goes through.

  • Introduction to the course
  • What is this course all about?
  • What is a Pivot Table and when should I use it?
  • Making your data ready for a Pivot Table
  • Building up the Pivot Table
  • Rearranging the Pivot Table in seconds
  • Change the data source/Refresh
  • Selecting, moving, and deleting your Pivot Table
  • Hide/Show elements
  • Change the name and the column headers of your Pivot Table
  • Pivot Table layouts
  • Grand Totals and Subtotals
  • Value Field Settings
  • Summarizing more than one column
  • Calculated Fields
  • See underlying data with Pivot Table Drilldown
  • Use data from a Pivot Table in a formula
  • Sorting and filtering
  • Using rules for filtering
  • Filtering with a Slicer
  • Filter multiple Pivot Tables with the same Slicer
  • Report filters
  • Grouping
  • Pivot Table Styles
  • General formatting
  • Conditional Formatting
  • What is a Pivot Chart?
  • Create a Pivot Chart
  • Using a Pivot Chart
  • Sorting and filtering
  • Certificate
  • What’s next?

Who created this course?

Kasper Langmann (co-founder) created ‘Pivot Tables’.

Kasper is also a certified Microsoft Office Specialist.

What’s unique about Spreadsheeto is, that the course creator is also the co-founder.

Kasper will not only be him you’ll listen to throughout the lessons – you’ll also be in direct contact with Kasper all throughout your Excel-journey.

“Hi, there! My name is Kasper and I’m the creator of ‘Pivot Tables’. I’ve worked professionally with Microsoft Excel for the past 6 years. I’ve helped thousands of people just like you unleash the power of pivot tables. I’m also a certified Microsoft Office Specialist. I’m so ready to help you get awesome in Excel in no time!”
Kasper Langmann, Co-founder and course creator

Frequently asked questions

Got a question we don’t answer below? Then feel free to contact us.

Can I get a certificate of completion?

Absolutely! Once you’ve completed the course, you’ll get a certificate of completion. This applies not only to this course, ‘Pivot Tables’, but all our courses.

What version of Excel do I need?

This course is filmed in Microsoft Excel 2016 for Windows. If you have Excel 2010 (or later) for Windows, you’re perfectly capable of following along.

Do I need any experience to take this course?

You need to have a basic understanding of what Excel is. This course, ‘Pivot Tables’, is designed for people who want to take their current Excel skills to a new level. Pivot tables makes it easy for you to handle and create dynamic reports.

How long does it take to complete the course?

You can watch all the lessons in less than 1 hour. We’ve removed all the unnecessary and distilled pivot tables down to its most important elements. We highly suggest you also do the included exercises. We’ve included a cheat sheet that makes revising the course content smooth and easy. How quick you pick up the material is very different from person to person. We recommend you set aside 2-3 hours.

Get access to Pivot Tables

Create a membership and get instant access to this course (and many others)

Pivot Tables: Excel course for intermediates
Get instant access