Dashboard in Excel – Upgrade Skill

Current Status

Not Enrolled

Price

Closed

Get Started

This course is currently closed

Learn how to build Interactive and Dynamic Dashboards with data visualization techniques.

Download Practice Files

Course Content

Expand All

Excel Dashboard Course Introduction 2 Topics

Expand

Lesson Content

0% Complete 0/2 Steps

Introduction to Excel Dashboard ?

Download Practice Files

Module 1 Cleaning Messy Data before Creating Dashboard 1 Topic

Expand

Lesson Content

0% Complete 0/1 Steps

Cleaning Messy Data

Module 2 Converting Data to Table Mode 1 Topic

Expand

Lesson Content

0% Complete 0/1 Steps

Converting Data to Table Mode

Module 3 Creating Reports using Pivot Table 6 Topics

Expand

Lesson Content

0% Complete 0/6 Steps

Creating your 1st Report with Pivot Table

Creating other Important Reports

Formatting Your Reports

Inserting Slicer for Interactivity

Changing Name of Pivot Table and Report Connection

Column Autofit Setting and Refresh Pivot

Module 4 Creating Dashboard Layout 2 Topics

Expand

Lesson Content

0% Complete 0/2 Steps

Designing Dashboard Layout Part 1

Designing Dashboard Layout Part 2

Module 5 Creating Charts and Adding Slicers for Interactivity 4 Topics

Expand

Lesson Content

0% Complete 0/4 Steps

Creating Charts for Dashboard Part 1

Creating Charts for Dashboard Part 2

Using Formulas in Dashboard

Adding Slicers to Dashboard

Module 6 Publishing Dashboard 1 Topic

Expand

Lesson Content

0% Complete 0/1 Steps

Publishing Your Dashboard

Follow Us

© 2022 Upgrade Skill. All Rights Reserved by Upgrade Skill