Excel Dashboard

——   Created by Simon Sez IT

Share this course:

NEW
Course
77
Lessons
9h 40m
Lesson time
intermediate
Skill level

More about this course

In this advanced Excel course, we look at how to create stunning, interactive dashboards in Excel.

 

A dashboard is a great way to visualize your data. An interactive dashboard allows you to change what results you see at the click of a button. In this in-depth course, we look at how to prepare your data for analysis, some essential formulas you’ll need to help you create dashboards in Excel, Pivot Tables, Pivot Charts, Form Controls and so much more.

 

Finally, we take you through how to combine all those skills to create a Sales Dashboard and an HR Dashboard in two, end of course projects.

 

If you need to analyze and present data in Excel, then this course will show you step-by-step how to create jaw-dropping Excel dashboards that leave people wondering how you became that good in Excel! 

 

In this course you will learn:

 

●     About Dashboard architecture and inspiration

●     How to prepare data for analysis (cleaning data)

●     Useful formulas for creating dashboards in Excel

●     How to create and edit Pivot Tables in Excel

●     How to create Pivot Charts from Pivot Tables

●     Advanced chart techniques in Excel

●     How to add interactive elements (form controls) into your dashboards

●     How to create a Sales Dashboard from scratch

●     How to create an HR Dashboard from scratch

77 Lessons

Section 1: Course Introduction
0:02:22
Introduction to Excel Dashboards
free preview
0:01:29
Course Exercise Files
free preview
0:03:28
Spreadsheet Architecture
free preview
Section 2: Dashboard Setup
0:05:34
Dashboard Design Inspiration and Resources
Section 3: Design Inspiration
0:05:42
Why Clean Data?
Section 4: Preparing Data for Analysis
0:05:51
Remove Blanks and Duplicates
0:07:50
Use Text Functions to Clean Data
0:05:06
Find and Replace
0:04:55
Convert Numbers Stored as Text to Numbers
0:04:42
Spell Check
0:09:58
Format Data
View more lessons +
This course is included in Arbington Premium
$15/month gets you access to every course. Start your 14 day trial today. ☝️

Class benefits

  • Certificate of Completion
  • 30 day satisfaction guarantee
  • 24/7 streaming access
  • Direct teacher access
  • 9h 40m of on-demand video
  • 3 downloadable files
  • Have a coupon?

About the instructor

Since 2008, individuals, small businesses, and Fortune 500 companies with thousands of employees have benefited from the easy and hands-on software training offered by Simon Sez IT. With over 5,000 video tutorials on a range of software programs, Simon Sez IT ensures stress-free eLearning and enhanced employee productivity - no …

View full profile

For super learners, get unlimited access for $15 per month

Start your 14 day free trial. Cancel at any time.