In partnership with US-based & YC-backed Codingal, we now host excellent Online Coding Classes for Kids in Nigeria. Get a globally recognised certificate in Coding, Software Engineering, AI, Game Dev, etc, from the comfort of your home, for your kids or wards and prepare them for a lucrative future in Tech. → Learn More
[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)