I don't use PIVOT tables anymore... I use this other thing instead!

That is right! I no longer use Pivot Tables in Excel. I am now using Power Pivot. In this video, let me show you what Power Pivot is and how to use it with Excel. Plus, you get to meet Chan2 again 😂


⏱ VIDEO TOPICS:
===============

0:00 - What is Power Pivot and how to create one in Excel?
1:12 - Why use Power Pivot instead of regular Pivot Tables?
3:25 - Practical example of Power Pivot & DAX


📺 LEARN MORE ABOUT POWER PIVOT & DAX:
=======================================

Beginner to PRO DAX Lesson with 20+ examples -    • Learn Power Pivot & DAX for Power BI with ...  
How to write measures in Excel (another example) -    • Advanced Pivot Tables #8 - Measures & DAX ...  
My Power Pivot playlist -    • DAX & Power Pivot Tips & Tricks  
Advanced Pivot Table tips & tricks playlist -    • Analyze data quickly with Pivot Tables  


👩‍💻 LEARN MORE ABOUT REGULAR PIVOT TABLES:
==========================================

Introduction to Pivot Tables - Complete Tutorial - chandoo.org/wp/excel-pivot-tables-tutorial/
Introduction to Pivot Tables with 8 examples -    • Learn Excel Pivot Tables in 10 Minutes - A...  
Pivot Table mistakes you shouldn't make -    • DON'T Make These 5 Pivot Table Mistakes  
6 Pivot Table Tricks to Impress Everyone -    • 6 Massively time saving Pivot Table tricks...  
Creating Pivot Tables when you have lots of data -    • How to make pivot tables from large datase...  
How to use Slicers in Excel -    • How to use Excel Slicers like a PRO: Basic...  


📁 SAMPLE FILE:
===============

Here is an Excel workbook with data for you to practice Power Pivot concepts - chandoo.org/wp/wp-content/uploads/2023/06/power-pi…

~

I made a pivot with average sales per day.
It was a mean report 😂

~

#pivottables #excel