Excel: Data Analysis and Dashboard

Excel: Data Analysis and Dashboad

Learn to use advance features of Excel for data analysis and developing Dashboard.


  • Knowledge of writing basic formulas and fucntion in Excel or completed Excel Intermediate course.

Learning Objectives

By the end of the course, you should be able to:

  • Access the Power Pivot add-in
  • Load data from various source
  • create a dashboard
  • Develop data model
  • Use Relationships tool to build relationship between tables
  • Use Power Query
  • Grouping data


  • Working with Data Analysis Tools
  • Creating Scenarios
  • Using What If analysis
  • Using Goal Seek
  • Using Solver
  • Generating report with alternate solutions
  • Introduction to Pivot Table
  • Formatting Pivot Table
  • Calculating PivotTable Values
  • Updating PivotTable Data
  • Introduction to PowerPivot
  • Using Data Model Tool
  • Using Power Query to acess data from various sources
  • Getting data from Web page, Excel, XML and Access Database
  • Building data model
  • Managing Relationships
  • Writing Formula for Calculation
  • Grouping Data
  • Creating Hierarchy
  • Adding column to Hierarchy
  • Using Slicer
  • Creating Dashboard
  • Visualize data using Power Map and Power View
  • Use Power View to create interactive charts
  • Using cloud-based PowerBI Tool