30 Minute Pivot Table Expert - Advanced
This video explains Pivot Tables in detail and depth. I cover features that will help you, if possible, improve your Pivot skills and hopefully get your work done faster.
The practice files can be downloaded for free here: https://drive.google.com/file/d/1Uo6N...
EXCEL E-BOOK, PRICE IS ANYTHING
🎓 Learn Excel from Scratch E-book https://lynk.id/ignasiusryan/D8p04vG
📊 72 Excel Formulas E-book https://lynk.id/ignasiusryan/kKgPP4W
🏎️ 100 Important Shortcuts E-book https://lynk.id/ignasiusryan/DAabpz5
MY DESK SETUP
🖥️ Monitor screen https://invol.co/cl8a7cu
⌨️ Keyboard https://invol.co/cl8a6w8
📷 Webcam https://invol.co/cl8a6y8
🖱️ Mouse https://invol.co/cl8a788
🎙️ Microphone https://invol.co/cl8a76o
💡 Lighting https://invol.co/cl8a75k
💼 Desk https://invol.co/cl8a7sj
🥙 Others https://ignasiusryan.notion.site/Desk...
GET IN TOUCH
📷 Instagram / ignasiusryan
✈️ Telegram https://t.me/ignasiusryan
📧 Email [email protected]
📽️ TikTok / ignasiusryan
🌐 Website linktr.ee/ignasiusryan
I use Excel 365.
If you found this video helpful, please subscribe so you don't miss my other videos and help share it with others. Who knows, this might be the video they've been looking for.
Thanks,
Igna
That's awesome, you read the video description all the way to the end.
Timestamp:
0:00 Intro
0:30 Pivot Basics
4:38 Expand and Collapse Pivot
5:30 Processing data by adding formulas directly to the Pivot
9:25 Sorting data in the Pivot
10:55 Changing data values
12:35 Viewing details of a Pivot's data
14:02 Calculating the proportion of a data point to the total data point
14:59 Determining the ranking of Pivot data
15:45 Creating a Pivot chart (pivot table graph)
19:05 Changing the appearance of Pivot Table Fields
19:44 Sorting data in Pivot Table Fields (A-Z)
20:14 Adding a Slicer to the Pivot
23:48 Adding a Timeline to the Pivot
25:24 Creating groups/clusters from multiple Pivot data points
27:32 Removing Grand Totals and Subtotals from the Pivot
28:28 Changing the appearance of the Pivot Table
29:14 Tricks to prevent laptop lag when using Pivot
31:01 Closing