This video is going to show you three big differences between an Excel-based Pivot Table and a Power Pivot-based Pivot table. The three differences we will emphasize are different calculations on Totals, Pivot Table Sets, and inserting a formula column into the Pivot Table. I find these the most influential differences between the two pivot tables but will discuss others along the way. You can also find resources to many more differences if you click the links below.
This tutorial was made using Excel 365, but all methods work with Excel 2010 and above.
Files if you want to follow along (large as it includes the Excel Table version):bit.ly/339kCAm
Link to a blog post that are relevant:
Pivot Table vs Power Pivot or what is Power Pivot (Excel Unplugged) - bit.ly/3tacHxu
Does a PowerPivot Pivot Table beat a regular Pivot Table (Excel Unplugged) - bit.ly/3q9JuAT
PowerPivot Inside Out (Part 1/3) (Excel Unplugged) - bit.ly/3Gfzv2n
PowerPivot Inside Out (Part 2/3) (Excel Unplugged) - bit.ly/3raZVMK
Chapters:
0:00 Excel Olympics Animation
0:08 Introduction
1:03 some info about Power Pivot
2:08 Introduction to the Data
2:36 How much space does it Use
3:51 Three differences emphasized in an Excel Pivot Table
7:17 Creating a Power Pivot Based Pivot Table
9:02 Connecting two tables in Power Pivot
9:36 Creating a Measure
10:46 Measure that calculates differently on Totals
13:09 Pivot Table Set based on Column Items
14:59 Inserting a Column with custom formulas in a Pivot Table
15:42 Convert to Formulas command in Pivot Tables
16:32 Using the Add this Data to the Data Model command
17:32 More sources on differences between the two Pivot Tables
18:14 A final comparison of file sizes
19:25 Conclusion
19:51 Outro
Gear Used:
US Links
Camera: Canon EOS R6 - amzn.to/3e9zxML
Microphone: AKG C3000 (Analog Mic) - amzn.to/3tYd37w
Audio converter: Zoom UAC-2 - amzn.to/3dgM8wS
Laptop: Dell XPS 15 - amzn.to/3w8CyoK
Lights: Elgato Key Light - amzn.to/3rurte7
EU Links
Camera: Canon EOS R6 - amzn.to/3tubwGy
Microphone: AKG C3000 (Analog Mic) - amzn.to/32pi2m0
Audio converter: Zoom UAC-2 - amzn.to/3amDRXP
Laptop: Dell XPS 15 - amzn.to/3effMmT
Lights: Elgato Key Light - amzn.to/3vcs6v9
Green Screen (visible in bloopers): amzn.to/3ajUm6Y
Recorded With: Camtasia - www.techsmith....
Subscribe for more Excel tutorials on the Excel Olympics RU-vid Channel: bit.ly/EOYTsub
Subscribe for the Excel Olympics Newsletter: bit.ly/3w3rkjK
Disclaimer: Some links included in this description might be affiliate links. If you purchase a product or service with the links that I provide, I may receive a small commission with NO additional charge to you! I appreciate your support!
#Excel #ExcelOlympics #gasperkamensek
17 авг 2024