Grow your YouTube channel like a PRO with a free tool
Get Free YouTube Subscribers, Views and Likes

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

Follow
Chandoo

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/excelpivotta...
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/wpcontent/upl...

~

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

~

#pivottables #excel

posted by ale1te2u