What you'll learn:
- Structure your data so pivot tables work first time - the step most people skip
- Build pivot tables in Google Sheets that summarize thousands of rows in seconds
- Aggregate with Sum, Count, Unique Count, Average, Median, Max and Min, and combine them in one table
- Write custom calculated fields that answer questions the standard aggregations cannot
- Create comparison, stacked, line and area charts straight from your pivot table data
- Analyze trends over time using custom date fields, then chart them
- Filter and slice your data with text, number and date filters, and with interactive slicers
- Run contribution analysis to show what each product, region or customer is worth as a percentage of the whole
- Group and analyze HR data by age and salary band, and highlight what matters with conditional formatting
This course contains the use of artificial intelligence.
Every lesson in this course is written, created and recorded by me. AI is used only to help produce supporting images and written materials around the lessons.
Every month you rebuild the same report by hand. Sales by region. Headcount by department. Spend by category. You copy, you sort, you total, and next month you do it all again.
Pivot tables are how you stop. In Google Sheets you can summarize thousands of rows into an answer in about four clicks, chart it, filter it, and rebuild it next month without writing a single formula.
This course teaches that from start to finish in under three hours. It is for people who want Google Sheets to do the work for them.
WHAT YOU WILL BE ABLE TO DO
Structure your data so pivot tables work first time
Build pivot tables that summarize thousands of rows in seconds
Aggregate with Sum, Count, Unique Count, Average, Median, Max and Min
Write your own custom calculated fields
Create comparison, stacked, line and area charts from pivot table data
Analyze trends over time with custom date fields
Filter and slice your data with text, number and date filters, and with slicers
Run contribution analysis - what each product or region is worth as a percentage
Group and analyze HR data by age and salary band
Apply conditional formatting with rules and colour scales
HOW THE COURSE WORKS
Nine short sections, each opening with a one-minute overview. Teaching videos run four to seven minutes. Every section ends with a practical activity - a written brief you work through on the training data, followed by a walkthrough video showing you how I would do it. Download the training data in section one and build along with me.
You work on real sales and transaction data for most of the course, and a separate human resources data set for the frequency, age and salary grouping section. Both are provided.
ABOUT THE TRAINER
I have been training business people to work with data since 2008 and publishing on Udemy since 2013. I now have 16 courses on Udemy, more than 460,000 enrolments and more than 139,000 reviews, at an average rating of 4.6. This course is rated 4.7 from more than 3,500 ratings.
I specialise in teaching business users the analysis rather than just the tool - the methods that turn data into information you can act on - using Microsoft Excel, Google Sheets, Microsoft Power BI, Google Data Studio, Amazon QuickSight and Copilot in Excel.
WHAT STUDENTS ARE SAYING
"This course is really amazing i would say it's easy to understand and to follow"
"The size of the lessons are perfect, the instructor moves very clearly throughout each topic"
"Ian is a phenomenal trainer. The course is easy to follow, digest, and provides practical hands on experience"
Ready to stop rebuilding that report by hand? Start with section one and let's build your first pivot table.
