So I’ve given you five good reasons to learn Pivot Tables and improve the way you deal with summarising your data. Now, I won’t leave you hanging, I’ve spent a few months developing this course on Pivot Tables with top-level financial analysts. The course is both quick to complete (two hours) and not very expensive. Here's what is in the course
Module 1: Introduction & Data Preparation
We will have a no-nonsense start and immediately build a Pivot Table, no theory or overly long explanations, straight into it! Then you go into the key topic of getting your data correct, I’ll briefly dive into Power Query to show how you can fix messy data and create what I call a ‘long boring list’
Module 2: Layout And Formats
Now that you have a basic Pivot, you are going to start to refine it into something increasingly useful and understanding Layouts is the first step to getting different perspectives on your data.
Module 3: Core Pivot Table Analysis
This is the meat of the course, this is where you really turn a Pivot Table in to an analysis engine by digging in to running totals, grouping data, sorting, filtering, multiple subtotals, insights with percentages of column and the perspectives with show value as.
Module 4: Filters And Slicers
Here’s where you will learn best practice on slicing and dicing your data with multiple filter techniques. Including more visual and specific filters like ‘Slicer’ and ‘Timeline’.
Module 5: Advanced Analysis
At this point in the course you will have a great understanding of Pivot Tables, it’s time to step up even more by implementing some of the more advanced Pivot Table analysis techniques such as Calculated fields, where you incorporate your own formulas in to your outputs. You will also learn about the power of connecting multiple data tables to one Pivot Table.
Module 6: Visuals And Reports
Here, you are going to be working conditional formatting in to your Pivot Table, you will look at PivotCharts which turn your data source directly in to a chart and finally you will take everything you have learned and build a Sales dashboard using key components such as Map charts.