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

Опубликовано: 05 Октябрь 2024
на канале: Chandoo

1,318,167

39k

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 -    • Learn Excel Pivot Tables in 10 Minute...
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