Empty space, drag to resize

Master PivotTables
with Confidence.
Without the Overwhelm

Master PivotTables
with Confidence.
Without the Overwhelm

Turn messy Excel spreadsheets into powerful insights with me, Deb Ashby.

Why PivotTables Set You Apart...

Here’s what learners say about mastering PivotTables with me:
Clarity from Chaos
"Excel used to feel overwhelming. Deb’s short, clear videos gave me the practical tips I needed to finally make sense of messy data - and my confidence soared."
 Brigid McCormack
Time Back in Your Week
"Deb’s course has saved me hours. She makes complex tools like VBA and macros simple and keeps things engaging. I’m levelling up fast."
Empty space, drag to resize
Monique Azcona
Become the Expert
"Deb’s course didn’t just teach me Excel, it gave me the confidence to present insights and be recognised as an expert. It’s been a real step up for my skills and career."
Empty space, drag to resize
Courtney Barnard

Is This Course Your Missing Piece?

Sound familiar...
Staring at messy spreadsheets, totally overwhelmed
Clicking around in PivotTables, not quite sure what you’re doing
Spending hours Googling how to do one tiny thing
Wanting to impress your team or clients with slick reports
Ready to level up your career with advanced Excel skills
Wishing someone would just show you step by step - without jargon
If this sounds like you, you’re in the right place - and I’m here to help.
Introducing

The Ultimate PivotTables Course

55+ Bite-Sized, Action-Packed Lessons

Master PivotTables with clear, practical videos you can follow step by step - no jargon, no fluff.

Hands-On Practice Files & Challenges

Work alongside me with real datasets, guided exercises and practical challenges that lock in your skills fast.

Taught by me, Microsoft MVP Deb Ashby

Learn from my years of experience helping millions master Excel - in a style that’s friendly, down-to-earth and gets results.

Lifetime Access & Future Updates

Revisit lessons anytime and stay updated with new tips and features as Excel evolves.

Perfect for Busy Professionals

Learn on your schedule with my on-demand course. Finally feel confident using PivotTables without hours of trial and error.

From Basics to Pro-Level Tricks

Go beyond the “how” and learn clever shortcuts and advanced techniques that help you shine - even under pressure.

Ready to finally get PivotTables?

Join my Ultimate PivotTables Course and turn messy spreadsheets into insights today.

Inside the Ultimate PivotTables Course

Deb’s Ultimate PivotTables course is perfect for anyone serious about growing their Excel skills. I finished feeling confident and ready to tackle complex data tasks at work. A must for professionals who want to stand out and make smarter decisions.”
Ben Perissinotto
Course Curriculum

What We'll Learn Together

Course Agenda:

Introduction

  1. Course Introduction - 05:08
  2. Get Comfy with the Dataset - 03:31
  3. What are Pivot Tables? - 04:41
  4. Preparation is KING - 06:14
  5. Exercise 01 - 02:29
  6. Test Your Knowledge - 3 questions

Pivot Table Basics

  1. Create a Basic Pivot Table - 09:20
  2. Pivot, Pivot, Pivot the Fields! - 05:05
  3. Select, Move and Copy Pivot Data - 04:58
  4. Subtotals and Grand Totals - 03:31
  5. Aggregation Options - Summarise By - 05:56
  6. Drill Down to Underlying Data - 02:33
  7. PRO-TIP: Defer Layout Updates - 02:22
  8. Exercise 02 - 01:42
  9. Test Your Knowledge - 3 questions

Organize Data - Sort, Filter and Group

  1. Basic Sort and Filter Options - 05:26
  2. Sort with a Custom List - 05:39
  3. Label and Value Filters - 06:17
  4. PRO-TIP: Apply Multiple Filters - 02:53
  5. Automatic Date Grouping - 05:31
  6. Organize Data by Financial Year - 04:29
  7. Create Custom Groups - 04:24
  8. Report Filter Pages - 03:29
  9. Filter with Slicers and Timelines - 08:40
  10. Exercise 03 - 01:59
  11. Test Your Knowledge - 3 questions

Format Pivot Tables and Slicers

  1. Apply Number Formats the Right Way - 05:13
  2. Format Empty Cells - 02:57
  3. Customize Headers - 05:56
  4. Report Layouts - 04:52
  5. Create a Custom Pivot Table Style - 07:53
  6. Set a Default Layout and Style - 04:49
  7. Import a PivotTable Style - 02:49
  8. PRO-TIP: Preserve Column Widths - 02:18
  9. Create a Custom Slicer Style - 08:08
  10. Apply Conditional Formatting - 07:49
  11. Custom Number Formatting - 08:34
  12. Exercise 04 - 02:23
  13. Test Your Knowledge - 3 questions

Pivot Table Calculations

  1. Show Values As - Value Calculations - 06:20
  2. Calculated Fields and Items - 09:05
  3. Solve Order and List Formula Tools - 06:16
  4. Exercise 05 - 01:43
  5. Test Your Knowledge - 3 questions

Pivot Tables + Power Query

  1. Import and Link Multiple Tables - 08:41
  2. Merge Multiple PivotTables - 06:55
  3. Append Tables with Power Query - 08:50
  4. Folders and Power Query - 09:04
  5. Exercise 06 - 02:15
  6. Test Your Knowledge - 3 questions

Visualize Data with Pivot Charts

  1. Data Visualization 101 - 05:22
  2. Create a Basic Pivot Chart - 12:24
  3. Format a Pivot Chart - Part 1 - 10:18
  4. Format a Pivot Chart - Part 2 - 10:16
  5. PRO-TIP: Pivot Chart Troubleshooting - 08:59
  6. Create a Map Chart from Pivot Data - 06:17
  7. Connect Slicers to Pivot Charts - 07:43
  8. Add a Dynamic Chart Title - 04:14
  9. Update Pivot Tables and Charts - 03:49
  10. Exercise 07 - 02:53
  11. Test Your Knowledge - 3 questions

Structured Reports

  1. Dynamic Reports with GETPIVOTDATA - 08:09
  2. PivotTable Style Reports - GROUPBY and PIVOTBY [M365 Only] - 11:52
  3. Highlight MIN and MAX values - GETPIVOTDATA and IF - 07:35
  4. Exercise 08 - 02:16
  5. Test Your Knowledge - 3 questions

AI For Analyzing Data

  1. AI - Analyze Data and Quick Analysis - 06:04
  2. Create Pivot Tables and Charts with Copilot [Optional] - 06:26
  3. Exercise 09 - 02:10
  4. Test Your Knowledge - 3 questions

Next Steps and Course Close

  1. Next Steps: Interactive Excel Dashboards - 02:44
  2. Time to Say Goodbye - 01:17
  3. Certificate of Completion
Write your awesome label here.
Course Details
Ready to finally master PivotTables? In my Ultimate PivotTables Course, you’ll learn how to:
  • Build PivotTables from scratch
  • Create slick reports and charts
  • Perform advanced calculations
  • Save time with pro tips and Copilot

No jargon. No overwhelm. Just real Excel skills to help you shine at work.

Time: 6 hours, 7 minutes
Format: On-demand - 55+ Lessons, 8 Exercises
Level: Beginner to Intermediate
Coach: Deb Ashby, Microsoft MVP and TAP Certified Instructor
I used to feel totally overwhelmed trying to figure out PivotTables on my own, but Deb’s Ultimate PivotTables course changed that completely. Her clear, bite-sized lessons made everything click, and the hands-on exercises gave me the confidence to actually use what I’d learnt at work.”
Cara Fudge
Content Project Manager
Amazing video for productivity. I always like your teaching style because of its simplicity.
Abraham Manyang
Thank you very much, you are really an expert in simplifying complex things.
Ezra
I hadn't worked on Excel in years and I'm amazed at what you just taught us all. Thank you.
Olga Palenzuela-King
FANTASTIC. This is by far the best video I have watched on the "FILTER" function, and I have watched a number of them.
Michael Brown

Earn Your Ultimate PivotTables Certificate

  • Complete hands-on exercises that mirror real-life data challenges.
  • Build a polished PivotTable report to showcase your skills.
  • Prove you’ve got what it takes to handle data like a pro. 
Meet Your Instructor

Deb Ashby

I make Microsoft skills easier to learn - and way more fun.
I'm a Microsoft MVP and LinkedIn Learning instructor with over 300,000 followers and millions of views. I break down the tricky stuff into simple, practical steps - so you can feel confident using the tools that matter and take your career further.

Brands I’ve worked with:

Try It, Love It, or Your Money Back!

30-Day Money-Back Guarantee
I’m confident you’ll get real value from my courses. But if it’s not right for you, just let me know within 30 days and I’ll give you a full refund. No stress. No awkward questions. Just simple, honest support.
Empty space, drag to resize

Frequently Asked Questions

What do I get when I buy a course?

You get instant, lifetime access to all lessons in the course - including step-by-step videos, downloadable resources, and hands-on challenges to help you apply what you’ve learnt.

How do I know if the courses are right for me?

Each course clearly outlines the skill level it’s aimed at - whether you're a total beginner or looking to go pro. You’ll see what’s covered before you buy, so you can choose the course that fits your needs.

How long will I have access?

Forever! Once you purchase a course, it’s yours for life - no expiry.

Do I need Microsoft 365?

Most lessons are taught using Microsoft 365, but you can still follow along if you’re using a slightly older version. Where features differ, I’ll always let you know.

Can I use Google Sheets to complete the Exercises if I don’t have Excel?

Unfortunately, no - PivotTables in Google Sheets are quite different to how they work in Excel.

Do I get a certificate?

Yes! Once you complete the course, you’ll receive a downloadable certificate of completion to celebrate your progress and showcase your skills.

Can I ask questions if I get stuck?

Absolutely. You can comment inside the course platform and I’ll be there to help you out.

How long is the Ultimate PivotTables course?

The Ultimate PivotTables course includes over 55 lessons and 8 practical exercises, with around 6 hours of on-demand content. But you can learn at your own pace and revisit topics anytime.

Can I preview any lessons before I buy?

While the full course is paid, I share plenty of free tips and short videos on my social media channels so you can get a feel for my teaching style before committing.

Come and find out more on social media:

Will I need to download any special software?

Nope! You just need Microsoft Excel installed on your computer. Everything else - videos, practice files, and exercises - is provided within the course.

How is this different from free tutorials on YouTube?

Great question! My course gives you a complete, comprehensive, structured learning path - not random videos. Plus, you’ll get downloadable resources, practical challenges, and personal support from me so you actually retain what you learn.

Can my company pay for this course?

Definitely. Many employers cover training costs. Feel free to reach out for any details you might need to get it approved internally.

Do you offer group discounts for teams?

Yes! If you’re interested in enrolling multiple people from your team, email me at support@assembleyou.com and we’ll sort out a group discount.

What’s your refund policy?

No worries. If you’ve completed less than 25% of the course, just email me at support@assembleyou.com within 30 days, and I’ll refund you - no fuss, no awkward questions.

I’m not great with tech. Will I be able to keep up?

Yes! My courses are designed to be clear, friendly, and easy to follow - no jargon, just real help. You can pause, rewind, or rewatch anytime.

Let’s Start Mastering
PivotTables Together

Simple, practical and designed with you in mind.
Copyright © 2025

Featured Links

Connect with Me