002. Save Time on Pivot Table: 10 Advanced tips and tricks that PROs use! | EXCEL
The topic of this video is make you a pro in using pivot tables! Let's learn 10 advanced tricks that pros know to save time on Pivot Tables:
1) Same slicer for 2 pivot tables
2) Double click your data
3) Multiple detailed reports in 1 click
4) Colorful data bars
5) Calculated Fields
6) Difference between Columns
7) Icons as Format
8) Group Data
9) Group Dates
10) Timeline Slicer
Channel content: Excel, excel tutorial, Microsoft excel, learn excel, how to use excel, excel basics, basic excel, ms excel, office 365, excel for dummies, excel functions, learn excel basics, microsoft excel for beginners, excel course, Mr Excel, excel help, microsoft excel tutorial, excel tricks, excel tips, excel guide, how to in excel, tricks in excel, tips and tricks, pivots tables, excel formulas, advanced techniques for excel, cell, range, formatting, chart, formulas. how to make a pivot table , all about pivot tables , pivot table interview questions and answers , how to make a pivot table on excel , advanced trick for pivot table , pivot table advanced tips in excel , pro trick pivot table , improve pivot table , tips tricks pivot table excel, advanced tips pivot table , advanced pivot table tips and tricks , advanced pivot table features , learn pivot table tricks in 10 min , become a pro in pivot table , save time on pivot table
#MSExcel #Excel #PivotTable
0:00 Same Slicer for 2 pivots tables
1:43 Double Click your Data
2:18 Multiple detailed reports in 1 click
3:06 Colorful Data bars
4:24 Calculated field
5:17 Difference between columns
7:11 Use Icons as Format
8:51 How to group data
9:58 Group Dates
10:57 Introduce Timeline Slicer