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