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...
Смотрите видео Mastering Pivot Tables in Excel | Comprehensive Tutorial онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Professor Cubs 10 Август 2023, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 446 раз и оно понравилось 21 людям.