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

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

Create Pivot Tables to Categorize Data for creating Pivot Charts & Dashboards9:02
Create a dynamic excel dashboard using pivot tables to categorize revenue and customer satisfaction by month, product, country, gender, and payment method, then visualize insights with pivot charts and dashboards.
Create Pivot Charts to represent your data in a Dynamic Dashboard13:35
Add Design & Style , Slicers, Time Line, Gender Charts in Sales Dashboard15:57
Create an interactive sales dashboard in Excel by combining pivot charts and tables with design styles, slicers, and a timeline, including a gender chart and performance insights.

Create an Excel Dashboard that shows product Sales of two Brands over the years10:48
Learn to build a dynamic Excel dashboard analyzing two brands' sales over time using tables, pivot tables, slicers, sparklines, and charts.
Excel Charts for Interactive Excel Dashboard 110:14
Learn to build an interactive Excel dashboard using pivot tables and charts, including line and bar charts for sales by brand and product, with currency formatting and dashboard design.
Excel Charts for Interactive Excel Dashboards7:20
Excel Slicers for Interactive Excel Dashboard14:41

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
Create and format a pivot table and pivot chart to display employees by department, map values, and move the chart to the dashboard sheet, adding a shape for visual emphasis.
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
Create a pivot table and pivot chart to display employee expenses by department, including salary, bonus, and overtime, and visualize it with a bar chart on a dashboard sheet.
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 fifth Excel pivot table and pivot chart to build a dynamic dashboard that visualizes the monthly bonus rate percentage, using calculated fields and formatting for clarity.
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
Explore creating a pivot table and pivot chart in Excel to build a dynamic dashboard, including arranging fields, inserting charts, and assembling the dashboard sheet.
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 your Excel dashboards dynamic by adding shapes, icons, and text boxes, linking shapes to table filters with formulas, and styling fonts and colors for clear, interactive insights.
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
Learn to build your first pivot table and pivot chart for an interactive Excel dashboard, using dynamic labels, formulas, and visual elements like donor chart and icons.
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 seventh pivot table and pivot chart for an interactive dashboard by grouping salary by two years, showing US average, and placing a column chart on the dashboard sheet.
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
Create your ninth pivot table and pivot chart for an interactive dashboard, visualizing employee average ratings by efficiency, behavior, innovation, and colleagues feedback with a column chart.
Make Your Chart dynamic and interactive using Excel Slicers, Design & Style8:52
Conclusion0:25

Create a Product Metrics Dashboard in Excel - Part 15:19
Create a Product Metrics Dashboard in Excel - Part 221:20
Create a Product Metrics Dashboard in Excel - Part 321:33
Create a multi-visual excel dashboard by adding website, monthly and daily active users charts, using vlookup for data, pivot tables for trends, and grouped blue visuals with outlines.
Create a Product Metrics Dashboard in Excel - Part 426:28
Create a Product Metrics Dashboard in Excel - Part 511:59
Create a Product Metrics Dashboard in Excel - Part 627:17

Create a Personal Finance Dashboard in Excel - Part 13:40
Build an interactive, two-page Excel personal finance dashboard with income, expenses, investments, and cash in hand, using slicers to slice and dice data and analyze debits, categories, and monthly trends.
Create a Personal Finance Dashboard in Excel - Part 213:24
Create a Personal Finance Dashboard in Excel - Part 330:49
Create a Personal Finance Dashboard in Excel - Part 430:07
Create a Personal Finance Dashboard in Excel - Part 531:01
Enhance an Excel dashboard by adding visuals, slicers, and text boxes with icons for debits, then build pivot tables and charts to analyze subcategories and monthly debits with dynamic updates.

Create a Dynamic Sales Dashboard in Excel - Part 13:39
Create an interactive Excel sales dashboard with pivot tables, pivot charts, and formulas to visualize monthly revenue, profit, expenses, and revenue by products, countries, and gender.
Create a Dynamic Sales Dashboard in Excel - Part 223:47
Create a Dynamic Sales Dashboard in Excel - Part 312:37
Create pivot tables showing revenue by country and by products, add clustered bar charts, and format visuals to build a dynamic, polished Excel dashboard.
Create a Dynamic Sales Dashboard in Excel - Part 429:42
Create a Dynamic Sales Dashboard in Excel - Part 517:37
Create a Dynamic Sales Dashboard in Excel - Part 615:23

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: