Microsoft Excel Online Class, Aa-understanding Pivottables, Charts & Graphs

[AA-Understanding PivotTables, Charts & Graphs]Pivot tables are one of Excel's most powerful features. A pivot table allows you to extract the significance from a large, detailed data set. With very little effort, you can use a pivot table to build good-looking reports for large data

PivotTables make report connections easy, make dashboards interactive and dynamic and they simplify data analysis.

Charts and graphs amplify the imports of data. They speak far louder than numbers.Understanding how to let your data speak on charts and graphs is a great way to captivate your audience.

Course Content (What you will learn):

Overview of PivotTable
Functionalities of PivotTable
Uses of PivotTable
PivotCharts
Slicers
Timeline
Working with PivotTables (scenarios)
Charts & Graphs
Guide to choosing the right charts & graphs
Creating charts & graphs
Creating special charts and uses (Thermometer gauge, speedometer gauge, progress charts etc)