I don't use PIVOT tables anymore... I use this other thing instead!
YouTube Viewers YouTube Viewers
599K subscribers
1,194,383 views
0

 Published On Jun 27, 2023

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 ...  
How to write measures in Excel (another example) -    • Advanced Pivot Tables #8 - Measures &...  
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 - https://chandoo.org/wp/excel-pivot-ta...
Introduction to Pivot Tables with 8 examples -    • How to use Pivot Tables in Excel - 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 t...  
Creating Pivot Tables when you have lots of data -    • How to make pivot tables from large d...  
How to use Slicers in Excel -    • How to use Excel Slicers like a PRO: ...  


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

Here is an Excel workbook with data for you to practice Power Pivot concepts - https://chandoo.org/wp/wp-content/upl...

~

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

~

#pivottables #excel

show more

Share/Embed