Pivot Tables Cheatsheet

Martin Večeřa

We are very proud to present you a Pivot Tables Cheatsheet that will help you with your pivot tables setup.

In the infographics, you’ll find:

  1. How a Pivot Table works
  2. How to create a basic Pivot Table
  3. Basic terms used in Pivot Tables
  4. Settings of Pivot Tables in Microsoft Excel and Google Sheets

This cheatsheet can be instantly used in your daily work.

Pivot Tables Cheatsheet
Pivot Tables Cheatsheet

Sign-up to our newsletter for free Pivot Table Examples e-book and Pivot Tables Cheatsheet download

By signing up, you agree to our newsletter terms and conditions.

If you want to refresh your Pivot Table knowledge, have a look at the complete beginners guide we have published recently.

source table for pivot table examples

Pivot Table Examples

It is recommended that you also check on the comprehensive Ultimate collection of 62 real world Pivot Table use cases.

Every single Pivot Table use case describes the purpose (usage), the individual settings (Row Label, Column Label, Summation Value), possible alternatives and references to other examples that are based on them.

Why do you need Pivot Tables?

Pivot Tables can quickly reveal many useful information in our records/data that were originally unknown to us or not obvious at first sight.

For example we can quickly spot any invoice after a due date. Or we can see how many tasks are planned for our team.

Pivot Tables are one of the basic business analytical tools. Their usage is essential to anyone who wants to base their decisions on hard facts. So that your decisions are the best you can make.

Already leaving? Save 1 day every week guaranteed!

We have analysed the time saved by teams that already joined Lumeer. Get 52 days back every year!

By pressing the Subscribe button, you agree to our newsletter terms and conditions.

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.