Course 2 – Introduction to data analysis using excel
- In this course you will go beyond the basics and learn to develop your skills with Excel, a favourite tool that data scientists depend on to gather, transform, analyze, and visualize data.
What You Will Learn
In this course you learn how to:
- Create flexible data aggregations using pivot tables
- Represent data visually using pivot charts
- Calculate margins and other common ratios using calculation on pivot table
- Filter data using slicers in multiple pivot tables
- Create aggregate reports using formula-based techniques