12 Pro PivotTable Formatting Tricks = No more UGLY PivotTables!
One of the downsides of PivotTables is they have a very distinctive look. Some might even say they’re ugly. In this video I cover 12 PivotTable formatting tricks that will transform their look and feel.
🔖RELATED TUTORIALS: Conditional Formatting: • Conditional Formatting Formulas - Mys...
Original PivotTable Profit & Loss Report tutorial and file: https://www.myonlinetraininghub.com/e...
🎓 LEARN MORE in my Excel courses: https://www.myonlinetraininghub.com/
🔔 SUBSCRIBE if you’d like more tips and tutorials like this.
📢 Please leave me a COMMENT. I read them all!
🎯 CONNECT with me on LinkedIn: / myndatreacy
🎁 SHARE this video and spread the Excel love.
Or if you’re short of time, please click the 👍
💬 EXCEL QUESTIONS: Get help on our Excel Forum: https://www.myonlinetraininghub.com/e...
⏲ TIMESTAMPS
0:00 How to Format PivotTables
0:23 Custom Sort Order
1:24 Column Labels
2:19 Inserting Blank Rows
2:42 Subtotal Position
3:14 Custom Styles
5:08 Expand/Collapse Buttons
5:30 Conditional Formatting
7:58 Repeating Item Labels
8:48 Report Layouts
9:20 Hiding (blank)s
10:08 Preserving Formatting
10:37 Default PivotTable Layout
Watch video 12 Pro PivotTable Formatting Tricks = No more UGLY PivotTables! online without registration, duration hours minute second in high quality. This video was added by user MyOnlineTrainingHub 06 July 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 346,794 once and liked it 11 thousand people.