10 Advanced Pivot Table Tricks to Make you an Excel PRO

10 Advanced Pivot Table Tricks to make you a PRO Excel user.
🚀 Take our courses here: https://www.careerprinciples.com/all-courses

🆓 DOWNLOAD Free Excel file for this video: https://careerprinciples.myflodesk.com/xz4qbeyt9s

In this video we go over 10 of the best advanced pivot table tricks. These took me years to discover, but you're about the learn them all in just a few minutes! Some of the tricks are creating custom sorting lists for pivot tables, adding percentages of grand totals, pivot table data bars, using the pivot table drill down feature, custom grouping, creating custom categories in pivot table row values, using the report filter pages tricks, and much more!

LEARN:
👉 Excel for Business & Finance Course: https://www.careerprinciples.com/courses/excel-for-business-finance
📈 The Complete Finance & Valuation Course: https://www.careerprinciples.com/courses/finance-valuation-course
🔥 Power BI for Business Analytics: https://www.careerprinciples.com/courses/power-bi-for-business-analytics

▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

Chapters:
0:00​ -​ Custom Sorting
2:15​ - Total Percentage
3:07​ - Pivot Table Data Bars
4:04​ - Drill Down
4:47​ - Advanced Filtering
6:45​ - Slicer Filter Tool
7:51​ - Timeline Filter Tool
8:25​ - Custom Grouping
9:39​ - Categories
10:40​ - Report Filter
11:34​ - Bonus

Видео 10 Advanced Pivot Table Tricks to Make you an Excel PRO канала Kenji Explains