Microsoft Excel PivotTables Course

About Course

Having worked with Excel for well over a decade in global companies, I’ve seen the rapid rise of data volumes over the last few years. Although many people only deal with ‘Small Data’ (Less than 5000 rows of 15-20 columns), larger data sets are on the rise, and you need to get comfortable dealing with them. Let’s get started with our in-depth excel pivot table course in which you will be able to know what is a pivot table in excel, how to use pivot tables, and what is the purpose of pivot tables. 

Here are five good reasons you want to consider learning Pivot Tables in a world of increasing data levels:

1. Speed of calculation

Once you are over 5000 rows X 15-20 columns, formulas can slow down; Excel Pivot Table training helps you run off the ‘Pivot Cache,’ a makeshift memory that will keep the calculations quick.

2. Get a perspective on existing data…really quickly

This is what I often refer to as quick and dirty analysis; we’ve just been landed with some data and want to understand it, so I’ll throw it into an excel Pivot Table tutorial and have a quick play around. Usually, I’ll uncover some headline number insights and also dodgy data that will go away and fix.

3. Summarise your information…really quickly

This is focused on summarizing, so you should have a grasp of your data; you create Pivot Table excel of what you expect, then you spend a few minutes playing around with slicing and dicing to see if you can get more insights. If not, time to move on.

4. Where Pivots shine more than formulas

Grouping data summaries, especially when reporting quarterly data, it’s a lot more work to do this with formulas; you can do it, I used to do it, but I would suggest letting excel Pivot Tables practice do the heavy lifting here.

5. Interface with PowerPivot

This is more advanced when your data set is very large (greater than >100,000 rows…occasionally 50,000 rows * 15-20 columns), then Pivot tables will slow down, so you need Power Pivot, which is like taking out the Pivot Tables ford engine and replacing it with a V8!

What Will I Learn?

  • Introduction & Data Preparation
  • Layout And Formats
  • Core Pivot Table Analysis
  • Filters And Slicers
  • Advanced Analysis
  • Visuals And Reports

Curriculum

41 Lessons2h

INTRODUCTION & DATA PREPARATION

Pivot Intro
Pivot Cache
Altering the Data Source
Unpivot data to a long boring list
Moving row and column
Expand and Collapse field

LAYOUT AND FORMATS

CORE PIVOT TABLE ANALYSIS

FILTERS AND SLICERS

ADVANCED ANALYSIS

VISUALS AND REPORTS

Student Success!

Some Of The Companies Our Students Work At

Frequently Asked Questions (FAQs)

Once you have signed up, then we will send you an email with a link to access our training dashboard; you can access all of our courses from this dashboard. All courses consist of video lessons that can be viewed on your device of choice, and also, to truly enhance your learning, you will access lots of exercise files relevant to the lessons.
It depends on your level of commitment. Our students have seen incredible results from as little as 30 minutes a day. But remember, the magic is in applying the skills as much as learning them. Our courses are designed with this in mind. On the very practical end, we have students who squeeze in a few minutes here and there on their commute, and some do dedicate 2-3 hour weekend sessions. One of our most successful students, Jayne managed to get up at 4 am to learn! This paid off massively as it landed her a six-figure analyst job in a bank.
Yes, this is quite common since we focus on helping actual corporate employees. Note that for teams, we offer bulk discounts. However, this needs to be done with a corporate credit/debit card. We don’t accept transfers/remittances. Get in touch if you have any specific questions.
Yes, we do; we will dust it off if you need it because it rarely happens! You have 30 days to let us know that the training isn’t right for you and we will happily refund you.
You can either purchase access to one course or all of our courses, which are listed above. We have done in a post-COVID-19 world to keep our prices low to accommodate as many ambitious people from all over the world who are looking to upskill through our high-level courses without the burden of high expense.
We recognize that people prefer to pay in their own currencies, and especially when our main product is a recurring membership to all our courses, you can rest assured knowing that fluctuations in currency won’t affect your financial commitment.
Great question, well frankly we make the best courses because all of our trainers have spent 10+ years using these skills in the real world! True knowledge is passed on from people who have been in the trenches, putting in long hours, solving real problems creatively. Our mission is to empower you with the very best of what works and, more importantly, leave out what is unnecessary and thus a waste of your precious time.
Level
Intermediate
Duration
2h
Subject

Pricing

Lifetime Online Access
$
99
Lifetime
  • Access this course online
  • Including exercise files & supporting material
  • Certificate of completion
  • Email Support for 12 months
  • Download the course