Advanced Excel Pivot Tables (Masterclass)

I guarantee there are some tips in this Excel Pivot Table Masterclass that will make you look like a showoff to your colleagues! Over the course of 30 minutes I step through 4 pivot table examples to teach you the best productivity tips that will make you maximize your experience with pivot tables. ★☆★ FOLLOW ME BELOW: ★☆★ https://bit.ly/m/anthonysmoak Instagram: @anthonysmoakdata Linkedin: Anthony B. Smoak ☕☕ If my channel has helped you, consider buying me a coffee! Thanks & Cheers! ☕☕ https://www.buymeacoffee.com/anthonys... ★☆★ Support this Channel: ★☆★ Merch ► shop.spreadshirt.com/AnthonySmoak TIMESTAMPS 2:15 - PIVOT BUILD #1 - OPTIMIZE FIELD SECTION SETTINGS 4:00 - GENIUS LEVEL HACK - MAGIC CELL FILTER 6:27 - PIVOT BUILD #2 7:53 - PERCENT OF COLUMN TOTAL 8:00 - CALIFORNIA LOVE 9:23 - APPLY A TOP 10 FILTER 9:48 - APPLY ICON SETS 10:09 - GRATUITOUS USE OF THE WORD VEXILLOPHILE 11:05 - PIVOT BUILD #3: GENIUS LEVEL HACK (ADVANCED DATA BARS) 13:34 - CREATE CUSTOM GROUPS 15:03 - REORDER PIVOT VALUES 16:03 - SHOW UNDERLYING PIVOT TABLE DETAIL 16:19 - PLAYERS BALL 17:13 - CHANGE PIVOT REPORT LAYOUT 18:12 - REFERENCE PIVOT TABLE VALUES EASIER 20:11 - SHOW REPORT FILTER PAGES 21:22 - PIVOT BUILD #4: WORKING WITH DATES 23:27 - CREATE CALCULATED FIELDS DIRECTLY IN A PIVOT TABLE 25:40 - ISSUES WITH FILTERING DATES 26:30 - FILTERING DATES WITH A SLICER 27:11 - FILTERING DATES WITH A TIMELINE 29:08 - OUTRO - DID YOU GRADUATE? #Excel #analytics #data #dataanalyst #businessintelligence #datascience #dataanalytics #dataanalysis #microsoft #microsoftexcel