Learn with KabodAnalytics

A path to a true Analysis Digital data transformation!

INTRODUCTION TO DATA ANALYSIS USING EXCEL

Introduction to data analysis using excel

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