Basic Excel – Module 8

Module 8 – 3 hours
More on Charts Gauge chart

1. Thermometer chart
2. Trendline
3. Gantt chart
4. Pareto Chart
5. Pivot chart
6. Filter pivot chart
7. Change pivot chart type
8. Frequency Distribution

Pivot Charts

1. Slicers
2. Update pivot table
3. Change data source
4. Calculated field/item
5. Get pivot data
6. Pivot tables
7. Drag Fields
8. Sort
9. Filter
10. Change summary calculation
11. Two dimensional pivot table
12. Group pivot table items
13. Group products
14. Group dates
15. Multi level pivot table
16. Multiple row fields
17. Multiple value fields
18. Multiple report filter fields