Hidden Secrets of Data Analysis in Excel

Current Status
Not Enrolled
Get Started

Everyone knows how to use simple Excel but not a lot of people know how to use Excel for Data Analytics. In this course, I am going to show you how to get started with Data Analytics and learn Excel at the same time.

What can you do after taking the course?

  • Analyze your data in a systematic way.
  • Make use of worksheet functions to group and organize your data
  • Give your descriptions a consistent look and feel
  • Master the use of Pivot Table, the basic analytical tool in Excel
  • Create professional looking charts to impress your boss

Master the 4 key activities of Data Analytics using Excel

  1. Convert your data into useful information
  2. Combine your data sources
  3. Analyze your data using Excel Pivot Table
  4. Present your findings using Excel Pivot Table and Charts

Differentiate the 4 Different Types of Data Analytics

  1. Descriptive Analytics
  2. Diagnostic Analytics
  3. Predictive Analytics
  4. Prescriptive Analytics