Mastering Pivot Tables in Excel | Comprehensive Tutorial
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.
⌚ *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...
Watch video Mastering Pivot Tables in Excel | Comprehensive Tutorial online without registration, duration hours minute second in high quality. This video was added by user Professor Cubs 10 August 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 446 once and liked it 21 people.