Course Overview


This course focuses on using Microsoft Excel for analyzing and visualizing Data. This course will expose you to the advanced analytical capabilities of Excel for modeling, analyzing and visualizing big data that will enable you to generate forward-looking insights from raw data.

You’ll learn how to import data from multiple sources and prepare data for analysis using Power Query. After connecting and preparing the data, you will also learn the techniques for modeling the data to optimize performance and perform advanced business calculations using DAX.

You’ll also gain hands-on experience on Dashboard design and principles.

By the end of this course, you'll be able to:

  • Gather and transform data from multiple sources
  • Perform advanced business calculations using DAX
  • Create and model relationship among multiple tables
  • Perform ETL (Extract, Transform and Load) operation in Excel
  • Design Dashboards and reports using Pivot charts and slicers


Get Data

You'll learn how to connect, transform and load data from multiple sources include databases, pdf, csv and data from the web.

Data analysis

You'll learn how to analyze large datasets using Microsoft Excel formulas and PivotTables

Data Modeling

You'll acquire hands-on skills on how to connect, model and perform advanced calculations using PowerPivot and DAX

Data visualization


You'll learn how to visualize data using the advanced visualization capabilities of Microsoft Excel including Pivot charts, sparklines, conditional formatting. You will also learn how to build interactive dashboard using PivotTables, charts and slicers.

Course Content


  Module 1 Excel Essentials
Available in days
days after you enroll
  Module 2 Excel Tables
Available in days
days after you enroll
  Module 3 Excel Charts and visual analytics
Available in days
days after you enroll
  Module 4 Conditional Formatting
Available in days
days after you enroll
  Module 5 Pivot Tables and Charts
Available in days
days after you enroll
  Module 6 Excel Business Intelligence: Power Query
Available in days
days after you enroll
  Module 7 Data Modeling with PowerPivot
Available in days
days after you enroll
  Guided Project
Available in days
days after you enroll
  Final Project and Capstone
Available in days
days after you enroll

Access your course here after Payment


$59.99

Lifetime Access