S 1 – Dynamic & Pivot Tables

Lessons Content

1. Understanding Excel MindSet.
2. Using Dynamic Table
3. Using Dynamic Option 
   1. Table Styles
   2. Total Row
   3. Slicer
4. Using Pivot table
5. Using Pivot table option
   1. Pivot fields
   2. Changing Pivot Opration (Sum – Count – Max – Min – Average )
   3. Using Filter 
   4. Using Sorting