Teach on Udemy

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

Learn More

Your cart is empty.

Keep shopping

Excel Data Analysis and Dashboard Skills for Professionals

Name: Excel Data Analysis and Dashboard Skills for Professionals
Rating: 4.0 (255 reviews)

Master data analysis and build 6 interactive dashboards to uncover trends, automate reports, and drive decisions now

Created bySkills On Demand

Last updated 2/2026

English

What you'll learn

You will learn about Pivot Tables and Pivot Charts
You will learn to create 2 interactive Excel Dashboards
You will learn how to use 20 Plus different Excel Charts and Graphs used in Dynamic Excel Dashboards.
You will learn how to Design, Format and Style Data Elements
You will learn 30 Plus top Microsoft Excel Formulas and Functions

Course content

14 sections • 81 lectures • 12h 52m total length

Introduction to Excel Data Analysis and Data Visualization Course.3:41
Know Everything about what you will learn from this course. Simple as that!
Download Example Files here0:03
Download all Example Files from below for this tutorial.

What are the types of Data supported in Excel and What are their Sources ?3:47
In this Section we will do an overview of what are the data types supported by Microsoft Excel 2016 and above, What are the sources of getting a data in Excel and we will do an example of getting data from a website and format the data.
Create Excel Tables and Excel Pivot Tables and learn the difference between both4:12
From this tutorial you will learn how to Create a Table, Format and Structure the Data, use the Pivot Function and different fields in Pivot Function and how to Customize the Pivot Fields to get meaningful results for your Excel Data.
Learn the Format and Styles used in Pivot Tables for data customization.4:09
From this tutorial you will learn more about the Format and Style elements used in Excel Pivot Function. You will learn about Functions like Summarize Values By and how the Pivot Table Structure changes by placing values in different pivot Table fields. You will also learn about features Excel has to customize and Design your Pivot Table.

Topics You will Learn0:48
Welcome Back from this tutorial you will learn the top functions used Excel 2016 Dashboard reporting like , Excel Summarize Values by Sum, Average and Count, Excel Show Values as Year to Date, Difference of , Variance and MAX and MIN, Excel Group Your Data, Excel function Insert Slicers for your structured data, Excel function Sum, True or False and If, Excel function And, Or, and Rank, Excel Function Round, If-Error and Average, Excel Function Left, Hyperlink, Max and Min.

So Lets Continue Learning!
Microsoft Excel Functions - Summarize Values by Sum, Average and Count5:19
From this tutorial you will learn one of the most powerful functions of Excel 2016, Summarize Values by Sum, Average, Count, Product, Max and Min. This function will help you in creating and summarizing large amount of data in your reports.
Show Values as Year to Date, Difference of , Variance and MAX and MIN8:34
From this tutorial you will learn one of the most powerful function in Excel 2016 called Show Value As. You will Learn how to use function as Running Total In, % of Running Total In, Difference Of , % of Difference of , % OF Grand Total and Rank Large to Small and Rank Small to Large.
Microsoft Excel Functions - Group Your Data11:42
From this tutorial you will learn , one of the most important function in Excel 2016 called Group Your Data.

You will learn how to Group Your Data based on Date, Number and Text.
Microsoft Excel Functions - Insert Slicers for your structured data4:32
From this tutorial you will learn how to filter your data using Slicers in Excel 2016. Slicers in Excel 2016 help to sort and filter data effectively and efficiently in click of a button.
Microsoft Excel Functions - SUM, TRUE or FALSE and IF6:40
In this tutorial you will learn about 3 powerful functions used in Excel 2016 called, SUM, TRUE or FALSE and IF.

Sum function in Excel 2016 helps you calculate sum of a series of data. True or False and IF are Logical Functions which helps the user understand if a particular data series meet the criteria set or not.
Microsoft Excel Functions - AND, OR, and RANK6:46
In this tutorial you will learn about 3 powerful functions used in Excel 2016 called, AND, OR and RANK. All these 3 functions are Logical in nature with returns the result based on criteria set.
Microsoft Excel Functions - ROUND, IF ERROR and AVERAGE5:09
In this tutorial you will learn about 3 powerful functions used in Excel 2016 called, ROUND, IF-ERROR and AVERAGE.
Microsoft Excel Functions - LEFT, HYPERLINK and MAX or MIN9:02
In this tutorial you will learn about 3 powerful functions used in Excel 2016 called, LEFT, HYPERLINK, MAX and MIN.
Excel 2016 Left function returns the result of value from the Left of the data series.
Excel 2016 Hyperlink function helps you link your data to external sources like a website, SQL database, other excel sheet or data in a same worksheet.
Excel 2016 MAX and MIN function helps you find the Maximum and Minimum value in a data series.

Topics You will Learn0:41
Welcome Back from this tutorial you will learn the top formulas used Excel 2016 Dashboard reporting like , Excel Vlookup, Excel Hlookup, Excel Image Lookup using Match and Index Function, Excel Count-IF, Excel Concatenat, Excel Match, Excel Is-Logical, Excel Offset and Transpose, Excel Columns, Excel Rows and Excel Date and Time Formulas.
So Lets Continue Learning!
Top Formulas Used in Microsoft Excel : VLOOKUP and HLOOKUP6:40
In this tutorial you will learn 2 most commonly used Lookup functions in Excel 2016 called Vlookup or Vertical Lookup and HLookUp which is Horizontal Lookup, which helps your lookup values in a data series based on set criteria.
Top Formulas Used in Microsoft Excel : IMAGE LOOKUP4:40
In this tutorial you will learn how to lookup images in Excel 2016 using two other function called INDEX and MATCH. When a data is selected you will get a corresponding image representing the data.
Top Formulas Used in Microsoft Excel : COUNT IF, CONCATENATE and MATCH8:40
Microsoft Excel Countif function counts the number of cells in a range, that meets a given criteria.
The Concatenate function allows you to combine text from different cells into one cell.

The Match function searches for a specified item in a range of cells, and then returns the relative position of that item in the range.
Top Formulas Used in Microsoft Excel : SUM IF, FIND and SEARCH7:00
Excel SUMIF function is a worksheet function that adds all numbers in a range of cells based on one criteria
The Excel FIND function returns the position (as a number) of one text string inside another. When the text is not found, FIND returns a VALUE error.
The search is NOT case-sensitive. The SEARCH function is a built-in function in Excel that is categorized as a String/Text Function.

Get the location of text in a string. To check if a cell contains specific text, you can use the SEARCH function
Top Formulas Used in Microsoft Excel : IS LOGICAL3:44
The Microsoft Excel ISLOGICAL function can be used to check for a logical value (ie: TRUE or FALSE). The ISLOGICAL function is a built-in function in Excel that is categorized as an Information Function. It can be used as a worksheet function (WS) in Excel.
Top Formulas Used in Microsoft Excel: OFFSET AND TRANSPOSE10:30
The OFFSET function in Excel returns a cell or range of cells that HAS a specified number of rows and columns from a cell or range of cells.

Sometimes you need to switch or rotate cells. You can do this by copying, pasting, and using the Transpose option. But doing that creates duplicated data. If you don't want that, you can type a formula instead using the TRANSPOSE function.
Top Formulas Used in Microsoft Excel : COLUMNS, ROWS and DATE AND TIME5:27
The Excel COLUMN function returns the column number for a reference.Excel ROW function returns the row number for a reference. Date and Time formula provides the current date and current time of the day.

Learn 20 different charts used in Microsoft Excel data analysis and dashboard2:35
Welcome back, in this tutorial you will learn about 20 plus Excel Charts and Excel Graphs used in Dynamic Excel Dashboards.
Topics Covered include.
Excel 2016 Column Chart,Excel 2016 Bar Chart, Excel 2016 Histogram Chart,Excel 2016 Pareto Chart,Excel 2016 Area Chart,Excel 2016 Line Chart, Excel 2016 Pie, Doghnut & Race Tracks, Scatter Chart, Bubble Chart, Tree Maps Chart, Excel 2016 Box and Whisker Chart, Excel 2016 Sunburst Chart, Excel 2016 Water Fall Chart, Excel 2016 Funnel Chart, Excel 2016 Radar Chart, Excel 2016 Stock Chart, Excel 2016 3D Maps, Excel 2016 Combo Chart, Excel 2016 Dynamic Map Charts and Excel 2016 Dynamic Info chart with Drop down.
All the above charts are used in creating Excel 2016 Dynamic Dashboards.
Create a column chart in Microsoft Excel4:32
In this tutorial you will learn about how to create Excel 2016 Column Chart.
Create a bar chart in Microsoft Excel4:44
In this tutorial you will learn about how to create Excel 2016 Bar Chart.
Create a histogram chart in Microsoft Excel7:05
In this tutorial you will learn about how to create Excel 2016 Histogram Chart.
Create a pareto chart in Microsoft Excel5:37
In this tutorial you will learn about how to create Excel 2016 Pareto Chart.
Create an area chart in Microsoft Excel3:40
In this tutorial you will learn about how to create Excel 2016 Area Chart.
Create a line chart in Microsoft Excel5:58
In this tutorial you will learn about how to create Excel 2016 Line Chart.
Create a pie chart, doughnut chart & race track chart in Microsoft Excel10:03
In this tutorial you will learn about how to create Excel 2016 Pie, Doughnut and Race Track Chart.
Create a scatter chart in Microsoft Excel3:42
In this tutorial you will learn about how to create Excel 2016 Scatter Chart.
Create a bubble chart in Microsoft Excel4:49
In this tutorial you will learn about how to create Excel 2016 Bubble Chart.
Create a tree map chart in Microsoft Excel2:48
In this tutorial you will learn about how to create Excel 2016 Tree Map Chart.
Create a box & whisker chart in Microsoft Excel4:52
In this tutorial you will learn about how to create Excel 2016 Box & Whisker Chart.
Create a sunburst chart in Microsoft Excel2:27
In this tutorial you will learn about how to create Excel 2016 Sunburst Chart.
Create a waterfall chart in Microsoft Excel2:40
In this tutorial you will learn about how to create Excel 2016 Waterfall Chart.
Create a funnel chart in Microsoft Excel4:30
In this tutorial you will learn about how to create Excel 2016 Funnel Chart.
Create a radar chart in Microsoft Excel3:35
In this tutorial you will learn about how to create Excel 2016 Radar Chart.
Create a stock chart in Microsoft Excel3:51
In this tutorial you will learn about how to create Excel 2016 Stock Chart.
Create a 3D map in Microsoft Excel6:34
In this tutorial you will learn about how to create Excel 2016 3D Maps.
Create a combo chart in Microsoft Excel6:10
In this tutorial you will learn about how to create Excel 2016 Column Chart.
Create a Info Chart in Microsoft Excel in Microsoft Excel14:48
In this tutorial you will learn about how to create Excel 2016 Info Chart.
Create a dynamic map chart in Microsoft Excel11:52
In this tutorial you will learn about how to create Excel 2016 Dynamic Map Chart.
Create a dynamic chart with drop down in Microsoft Excel6:14
In this tutorial you will learn about how to create Excel 2016 Dynamic Chart with Drop Down.

Create Six pivot tables and use them to create six pivot charts3:52
In this tutorial we will learn how to compare trends in Revenue, Sales, Commission, Regions, Showrooms etc., using Pivot Tables and Pivot Charts.
Learn to create a pivot chart using your Pivot Table.6:09
In this tutorial we will create 6 Excel Pivot Tables which we will use to create 6 Excel Pivot Charts. We will learn how to compare trends in Revenue, Sales, Commission, Regions, Showrooms etc., using Pivot Tables.
Create six pivot charts using the six pivot tables6:32
In this tutorial we will create 6 Pivot Charts using the 6 Pivot tables we had created in the last tutorial. We will learn how to compare trends in Revenue, Sales, Commission, Regions, Showrooms etc., using Pivot Charts.

Requirements

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

Description

Master Microsoft Excel for Data Analysis and Data Visualization using Pivot Tables, Pivot Charts, and Interactive Excel Dashboards.

This course is designed to help you turn raw data into clear, visual insights using Excel’s most powerful analysis and visualization tools.

Excel charts and graphs are among the most valuable features of Microsoft Excel. They allow you to transform numerical data into easy-to-understand visual formats, helping stakeholders quickly grasp trends, patterns, and performance.

What You’ll Learn in This Excel Dashboard Course

In this course, you will learn how to:

Analyze data efficiently using Excel Pivot Tables and Pivot Charts
Create dynamic Excel charts and graphs for real-world business scenarios
Present data visually using charts, graphs, and 3D maps to simplify complex information
Use the top Excel functions and formulas required for pivoting and analysis
Build 2 fully dynamic Excel Sales Dashboards from scratch
Apply professional design, styling, and formatting techniques in Excel 2021
Customize chart elements including layout, axes, gridlines, sparklines, trendlines, and error bars
Use dynamic visualizations to present complex datasets in a clear, impressive, and decision-ready format

Why Excel Data Visualization Skills Matter

Learning Excel data visualization helps you:

Communicate insights faster and more clearly
Improve decision-making with visual analytics
Replace static spreadsheets with interactive dashboards
Stand out in meetings, reports, and presentations

Instead of sharing rows of numbers, you’ll learn how to tell a story with data using Excel dashboards that management understands instantly.

Course Structure & Coverage

8+ structured chapters, focused on Excel Pivot functionality
Hands-on coverage of 20+ different Excel chart types
Deep dive into top formulas, pivot techniques, and visualization best practices
Step-by-step creation of 2 dynamic Excel Sales Dashboards
Learn design, layout, and styling elements used in professional dashboards

This course is suitable for beginners, intermediate users, and professionals who want practical Excel data analysis and dashboard skills.

Start Building Excel Dashboards That Get Noticed

If you want to analyze data faster, visualize insights clearly, and build interactive Excel dashboards, this course gives you a focused, results-driven learning path.

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

Excel Data Analysis and Dashboard Skills for Professionals

What you'll learn

Explore related topics

Course content

Excel Data Analysis using Pivot Tables, Pivot Charts & Dynamic Excel Dashboards2 lectures • 4min

Excel Basics3 lectures • 12min

15 Pivot Table Functions used in Microsoft Excel9 lectures • 59min

15 Top Formulas Used in Microsoft Excel8 lectures • 47min

Learn 20 Plus Charts used in Excel Dashboards - Detailed Overview with Examples22 lectures • 2hr 3min

Design and Style Elements used in Excel Dashboards1 lecture • 5min

Create a Pivot Chart to Pivot your Data graphically3 lectures • 17min

Create your first Dynamic and Interactive Excel Dashboard2 lectures • 30min

Create an Interactive Sales Dashboard in Microsoft Excel3 lectures • 37min

Create a Store Sales Analysis Dashboard in Excel6 lectures • 1hr 37min

Requirements

Description

Who this course is for: