+252619884564  [email protected]

Excel Dashboard Mastery Course (Visualize Data Effectively)

By admin Categories: Microsoft Excel
Wishlist Share
Share Course
Page Link
Share On Social Media

About Course

In this advanced Excel Dashboards course, you will learn how to create interactive, eye-catching dashboards in Excel. This course will cover the fundamentals of data visualization before delving into the theory and concepts that drive data visualization. You will learn how to create compelling narratives through the optimal selection, design, and presentation of charts and graphs. You will finally learn how to construct the ideal chart and graph to effectively convey the story behind your data.

What Will You Learn?

  • Regarding Dashboard design and motivation
  • How to organize data for analysis (cleaning data)
  • Excel formulas for the creation of dashboards
  • Step-by-step lecture on creating and editing pivot tables.
  • How to generate pivot tables from pivot charts
  • Advanced chart techniques in Excel
  • How to add form controls (interactive elements) to your dashboards
  • How to build a Sales Dashboard from scratch
  • How to create a human resources dashboard from scratch

Course Content

Module I: Introduction

  • Brief Introduction to Dashboard, key steps and design
    13:00

Module II: Dashboard Overview

Module III: Understand Your Data

Module IV: Data Model with Power Pivot

Module V: Data Analysis

Module VI: Creating Dashboard

Student Ratings & Reviews

No Review Yet
No Review Yet