Pivot Tables Demystified: Simplifying Your Data Analysis
In this video you'll learn how to create pivot tables in excel, step by step. Sure, pivot tables may seem intimidating, yet after watching this video we'll demystify pivot tables for you, and you'll learn that they're really just fancy arrangements of data.
🏸 So if you're searching for how to master excel pivot tables, this comprehensive tutorial is for you!
⌚ *TIMESTAMPS*
0:00 Intro
0:19 Why use a pivot table?
0:58 What is a pivot table?
1:52 Walk thru of our data
2:50 Creating a pivot table
3:32 The Quadrants
4:38 Building a super simple pivot table
6:09 Ok, let's build another pivot table
6:54 Why is it even called a pivot table?
7:44 Multiple fields in multiple quadrants
8:55 Sorting and filtering within a pivot table
10:31 The filters quadrant
11:35 Using a slicer
12:46 Insert a timeline
13:47 Changing calculations
14:49 Show percent of grand total
15:42 Creating calculated fields
16:53 Creating simple charts
17:30 Making a super simple (and kinda ugly) dashboard
18:17 Miscellaneous topics (Refreshing data, Reports, Viewing data source, Drilling down)
19:23 Alternate way to create pivot table and wrap up
💾 *DOWNLOAD CLASS FILE*
https://1drv.ms/x/s!AgnhzVKiTqWmgQ3-t...
📄 *RESOURCES*
Mega Excel Keyboard Shortcut List
https://view.flodesk.com/pages/63bf31...
Quick Reference Guide
https://view.flodesk.com/pages/63bf2f...
☕ * BUY ME A COFFEE?*
https://www.buymeacoffee.com/professo...