Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Microsoft Excel Data Analysis - Build Excel Dashboards

Name: Microsoft Excel Data Analysis - Build Excel Dashboards
Rating: 4.3 (247 reviews)

Learn Excel dashboards and data analysis using Pivot Tables and visuals to reveal insights and accelerate career growth

Created bySkills On Demand

Last updated 12/2025

English

What you'll learn

You will learn to create 6 Dynamic Excel Dashboard
You will learn about Pivot Tables and Pivot Chart
You will learn how to Design, Format and Style Data Elements
Learn the Concepts of How to Create and Design an Interactive Excel Dashboard for your department.
Learn Data Analysis using Excel Advanced Formulas
Microsoft Excel Data Analysis with Excel Pivot Tables
Microsoft Excel Data Visualization, Excel Charts & Graphs
Microsoft Excel Data Analysis and Dashboard Reporting

Course content

11 sections • 66 lectures • 10h 45m total length

Promotional Video2:45
Introduction - Learn Excel Data Analysis create Dynamic Excel Dashboards course3:49
Quickly Dowload Course Files and Let's get Started.0:03
Learn to create dynamic and impressive dashboards using the excel templates attached

Excel Pivot Table and Excel Pivot Chart that display Employees by Gender details14:31
Excel Pivot Table & Excel Pivot Chart to display Employees by Department details5:05
Excel Pivot Table & Excel Pivot Chart to display Employee Hire types details5:08
Excel Pivot Table & Pivot Chart to display Employee Status (Active/Inactive)4:05
Excel Pivot Table & Excel Pivot Chart to display Employee Designation Types4:11
Excel Pivot Table & Pivot Chart to display Employee Expense by all departments5:20
Excel Pivot Table & Pivot Chart to display Employee Expense by all departments5:26
Pivot Table & Pivot Chart to display Average Sick Leaves (Various Departments)15:08
Pivot Table & Pivot Chart to display Average Employee Rating -Various Department9:06
Make Your Chart dynamic and interactive using Excel Slicers, Design & Style6:46

Introduction to Excel Dashboard tutorial2:13
Data used in this Dashboard2:04
Create your first Excel Pivot Table and Pivot Chart for Dynamic Dashboard4:33
Create your second Excel Pivot Table and Pivot Chart for Dynamic Dashboard4:27
Create your third Excel Pivot Table and Pivot Chart for Dynamic Dashboard3:26
Create your fourth Excel Pivot Table and Pivot Chart for Dynamic Dashboard2:47
Create your fifth Excel Pivot Table and Pivot Chart for Dynamic Dashboard4:16
Create your sixth Excel Pivot Table and Pivot Chart for Dynamic Dashboard4:48
Create your seventh Excel Pivot Table and Pivot Chart for Dynamic Dashboard2:13
Create your eighth Excel Pivot Table and Pivot Chart for Dynamic Dashboard2:20
Create your ninth Excel Pivot Table and Pivot Chart for Dynamic Dashboard2:28
Create your tenth Excel Pivot Table and Pivot Chart for Dynamic Dashboard2:24
Make Excel Dashboards, dynamic using dynamic excel dynamic shapes9:25
Make Excel Dashboards, dynamic using dynamic excel slicers4:55

Let's Learn how to create an interactive and dynamic Excel HR Dashboard4:17
Create your first Pivot Table and Pivot Chart for your Interactive Dashboard8:52
Create your second Pivot Table and Pivot Chart for your Interactive Dashboard6:09
Create your third Pivot Table and Pivot Chart for your Interactive Dashboard3:57
Create your fourth Pivot Table and Pivot Chart for your Interactive Dashboard6:28
Create your fifth Pivot Table and Pivot Chart for your Interactive Dashboard8:28
Create your sixth Pivot Table and Pivot Chart for your Interactive Dashboard4:54
Create your seventh Pivot Table and Pivot Chart for your Interactive Dashboard7:29
Create your Eighth Pivot Table and Pivot Chart for your Interactive Dashboard6:16
Create your ninth Pivot Table and Pivot Chart for your Interactive Dashboard6:14
Make Your Chart dynamic and interactive using Excel Slicers, Design & Style8:52
Conclusion0:25

Requirements

Basic Excel Knowledge
This Course is created on Excel 2021, You can also use Excel 2016 and above
Interest to Learn and Upgrade Your Skillset
A Windows PC where Microsoft Excel is Installed

Description

Master Excel Data Analysis and Dashboard Design — the exact skills employers expect today.

This Excel Data Analysis Masterclass teaches you how to analyze data, visualize insights, and build professional Excel dashboards using Pivot Tables, Pivot Charts, advanced Excel charts, and interactive dashboard techniques.

In this course, you will move beyond basic spreadsheets and learn how to transform raw data into powerful visual stories that help management make faster, smarter decisions.

What This Excel Dashboard Course Covers

This course provides end-to-end Excel data analysis training, covering:

Excel data analysis fundamentals for real-world business use
Data visualization using Excel Pivot Tables and Pivot Charts
Designing interactive Excel dashboards with slicers and dynamic charts
Creating 6 fully dynamic Excel dashboards and report templates
Using Excel charts and graphs to present complex numerical data clearly
Applying professional design, styling, and formatting best practices in Excel 2016, 2019, and 2021

Excel charts and graphs are among the most powerful features of Microsoft Excel. You’ll learn how to use them to convert numbers into clear, visual insights that stakeholders can understand instantly.

Skills You Will Master

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

Build dynamic Excel Pivot Tables and Pivot Charts from scratch
Create responsive, interactive Excel dashboards for analysis and reporting
Design eye-catching Excel charts using smart, non-standard techniques
Apply Excel core functionality to build scalable and reusable dashboards
Use dynamic visualizations to highlight trends, patterns, and performance
Impress management with dashboards that speed up decision-making

You’ll also gain actionable Excel tips and best practices that you can apply immediately to create professional-quality dashboards.

Why Learn Excel Data Analysis & Dashboards?

Excel dashboards are a career-critical skill for analysts, managers, finance professionals, and anyone working with data. Instead of sharing static spreadsheets, you’ll learn how to deliver interactive dashboards that communicate insights clearly and confidently.

These skills help you:

Save time by reducing manual reporting
Improve accuracy and consistency
Increase visibility at work
Stand out in meetings, interviews, and performance reviews

Course Structure & Requirements

30+ structured chapters, covering Excel dashboards in depth
Step-by-step guidance to build 6 dynamic Excel dashboards
Compatible with Microsoft Excel 2016, Excel 2019, and Excel 2021
Suitable for beginners, intermediate users, and professionals

Invest in Yourself. Start Learning Data Analysis Today.

If you want to master Excel data analysis, build dashboards that get noticed, and unlock better career opportunities, this course is the perfect place to start.

Let the show begin.

Who this course is for:

If you are looking to improve your Microsoft Excel Skills
If you want to learn how to create Excel Charts, Formulas and Functions and Excel Shortcuts
If you want to learn foundation of how to create Excel Dynamic Dashboards
If you create Management Reports or MIS
Excel users who have basic skills but would like to become more proficient in data exploration and analysis
Anyone who works with Excel on a regular basis
If you want to learn data analysis

Microsoft Excel Data Analysis - Build Excel Dashboards

What you'll learn

Explore related topics

Course content

We Welcome You - A Fast Paced Course to Learn and Apply New Skills in Less Time3 lectures • 7min

Excel Data Analysis - Create a Dynamic Microsoft Excel Sales Dashboard - 1 of 63 lectures • 39min

Excel Data Analysis - Create a Dynamic Microsoft Excel Sales Dashboard - 2 of 62 lectures • 31min

Excel Data Analysis - Create a Dynamic Microsoft Excel Sales Dashboard - 3 of 64 lectures • 43min

Excel Data Analysis - Create a Dynamic HR Dashboard - 4 of 610 lectures • 1hr 15min

Excel Data Analysis - Create a Dynamic Web Analytics Dashboard - 5 of 614 lectures • 52min

Excel Data Analysis - Create a Dynamic HR Dashboard - 6 of 612 lectures • 1hr 12min

Create a Product Metrics Dashboard in Excel6 lectures • 1hr 54min

Create a Personal Finance Dashboard in Excel5 lectures • 1hr 49min

Create a Dynamic Sales Dashboard in Excel6 lectures • 1hr 43min

Requirements

Description

Who this course is for: