Excel Pivot Tables EXPLAINED in 10 Minutes (Productivity tips included!)
18 June 2020 Excel Pivot Tables
Join 400,000+ professionals in our courses: https://www.xelplus.com/courses/
Discover hidden productivity tips when working with Excel Pivot Tables. At first Pivot Tables might seem like a complex tool but they are one of Excel's EASIEST features to work with. They help you summarize data really FAST.
★ My Online Excel Courses ► https://www.xelplus.com/courses/
In this video I'll show you in about 10 minutes, how simple it is to create a pivot table and get quick insights into your data. I'll also throw in some Excel Pivot Table tips and tricks not everyone is aware of. To top it off we'll also add Pivot Slicers to get a professional visual to apply filters to our Pivot Table.
★ Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/
⯆ DOWNLOAD the workbook so you can practice with this Pivot Table example data (scroll down to the bottom of the post): https://www.xelplus.com/pivot-tables-in-10-minutes/
✉ Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/
Timestamps
00:00 Why use Excel Pivot Tables?
01:35 Convert Data to Excel Tables
02:46 Create Pivot Table
04:08 Change aggregation in Pivot Table to average or count
04:40 Adjust number format in Pivot Table
05:10 Add filter to Pivot Table
05:28 Add column fields to Pivot Table
05:50 Removing Grand Totals and Sub Totals in Pivot Table
06:27 Update Pivot Table layout and design
07:14 How to bring back Pivot Table Fields dialog box
07:42 Update Pivot Table column header without errors (pivot table field name not valid)
08:33 Sort values in Pivot Table
08:41 Lock column width on Pivot Table refresh
09:00 Add Value as percentage of grand total in Pivot Table
10:22 Add Pivot Table Slicers to Filter Data
11:10 Connect Slicer to multiple Pivot Tables
11:50 Refresh Pivot Tables
12:40 Benefits of Pivot Tables
RESOURCES I Recommend: https://www.xelplus.com/resources/
More resources on my Amazon page: https://www.amazon.com/shop/leilagharani
Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
Twitter: https://twitter.com/leilagharani
LinkedIn: https://at.linkedin.com/in/leilagharani
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#MsExcel #Excel #LeilaGharani
-
3:32:48
Due Dissidence
9 hours agoMorning Joe and Hillary SMEAR Students, DNC Fears CONVENTION CHAOS, Carville MELTS DOWN Again
11.3K55 -
1:22:39
The Late Kick with Josh Pate
7 hours agoLate Kick Live Ep 512: Portal Winners & Losers | SEC Truths + Questions | Portal Winners & Losers
13.2K1 -
1:50:27
vivafrei
13 hours agoEp. 210: Stormy Gags on Lies! Hunter Not Immune! AstraZeneca Pulled & MORE! Viva & Barnes
97.7K158 -
1:50:54
Jewels Jones Live
2 days agoUNDERSTANDING NEXTGEN MARXISM | A Political Rendezvous - Ep. 76
40.6K38 -
8:22:56
Akademiks
1 day agoAll Will Be Revealed! Drake vs Kendrick vs The Riddler. Who Lied, Who Snaked, Mole Finally Revealed!
127K103 -
1:08:38
Russell Brand
2 days ago“You’re Going To Get KILLED!” Mike Benz EXPOSES CIA Secrets Like NEVER Before - Stay Free #363
365K775 -
1:35:13
Roseanne Barr
2 days ago $74.67 earnedKeep My Name Out Yo M*Therf*Cking Mouth! | The Roseanne Barr Podcast #47
176K410 -
1:19:00
Steven Crowder
3 days agoBradley Martyn and Vitaly's Hollywood Pedo Bust Goes Wrong! Guests: Alex Rosen | Vivek Ramaswamy
669K1.09K -
53:40
The Osbournes
5 days ago $1.07 earnedWould You Eat a Monkey? Osbourne's Wildest Meals
70.8K14 -
1:19:01
Steve-O's Wild Ride! Podcast
3 days agoMike The Situation Went To Prison & Owes Millions, But Remains Grateful - Wild Ride #213
86.2K12