Excel Dashboard Design | How To Build Excel Dashboard | Excel Tutorial For Beginners | Simplilearn

This video on Excel Dashboard Design will help you understand the basics of a dashboard. You will learn how to create pivot tables and pivot charts using sample sales data. Then, you will look at how to make your visualizations interactive. You will see the formatting techniques and how to make it more readable. Finally, you will create two dashboards on revenue and profit and apply slicers and timelines to them. Let's begin!

The topics covered in this video are:
Introduction 00:00:00
What Is a Dashboard in Excel? 00:00:31
Sample Sales Dataset 00:01:16
Excel Dashboard Demo - Total Revenue 00:03:53
Excel Dashboard Demo - Total Profit 00:43:02

#ExcelDashboardDesign #MicrosoftExcelDashboard #HowToBuildExcelDashboard #HowTobuildInteractiveDashboardsInExcel #ExcelForBeginners #ExcelBasicsForBeginners #ExcelTutorial #ExcelTutorialForBeginners #BusinessAnalystCourse #BusinessAnalyst #BusinessAnalytics #Simplilearn

What Is Microsoft Excel?
Excel is one of the best applications available on the market for creating spreadsheets to crunch numbers and dashboard reports as well as storing and administering data. This software first appeared on the scene back in 1987, and since then it has grown to become one of the most popular pieces of software for home or business.

What Is Excel Dashboard?
An excel dashboard is a visual interface that provides an overview of key measures relevant to a particular objective with the help of charts and graphs. Dashboard reports allow managers to gain a high-level overview of the business and help them make quick decisions. There are different types of dashboards such as strategic dashboards, analytical dashboards, and operational dashboards.

Post Graduate Program in Business Analysis:
Get your business analysis career started with our Post Graduate Program in Business Analysis, in partnership with Purdue University. This business analysis certification program helps you build extensive business expertise with real-world projects and prepares you for the business analyst role. This Post Graduate Program in Business Analysis will help you master business analysis techniques, Agile Scrum methodologies, SQL database, and visualization tools, including Excel, Power BI, and Tableau. You will learn about business analysis planning and monitoring, build interactive dashboards and understand the competencies of a Business Analyst.

Program Details:
Jumpstart your career as a Business Analysis Professional with this comprehensive curriculum covering the concepts of business analysis tools and techniques, statistics fundamentals, interaction with databases using SQL, and data visualization using excel, Power BI, and Tableau.

Key Features:
✅ Purdue Post Graduate Program Certification
✅ Purdue Alumni Association Membership
✅ Masterclasses from Purdue faculty
✅ Enrollment in Simplilearn’s JobAssist
✅ Get noticed by the top hiring companies
✅ Case Studies from Harvard Business Publishing Education
✅ Obtain 35 IIBA PDs/CDUs and 25 PMI PDUs
✅ 170+ hours of Applied Learning
✅ 11+ hands-on projects
✅ Capstone project in 3 domains

[divyakanchi]

You are the master..thank you.. Amazing work.. No words, such amount of patience is needed.. Your hard work will always makes you feel proud..

[anushkaringshia]

Absolutely loved this tutorial! You simplified this to such basic level, I think I can create my own dashboards now. Thanks!

[wondermunaki]

Thank you so much for the tutorial can I please get the data set used in this video

[amolpathak]

You made it so easy.! Thanks for this amazing tutorial.!

[himanshumalik]

it's a great tutorial for those who really want to learn the dashboard in a simple and easy way .thanks to Simplilearn for this video.

Can I please have the datasets for these wonderful excel Dashboard tutorials..!

[shreyasonkar]

This tutorial is the best for beginners to learn Excel, Thank you Simplilearn for this video .

Can you please provide the dataset file for this tutorial.

[ajay]

Sir you deserve deserve a dronacharay award

[knowtechwithaman]

Great tutorial Learnt a lot. I got a little trouble that when I am selecting country from as shown in 1:06:30, I am getting the whole world map, not the selected one *country*. Can you help me in finding its reason?

[renukadeshpande]

Great tutorial !! can I please have the datasets for these amazing excel Dashboard tutorials..

[FloraFlo-dj]

very well presented .can i please have the practice files

[statura]

Thanks for the material on the dashboard in Excel.

[pallabiduttabose]

Hi, Simplilearn, firstly thank you very much for sharing this video & also educating us. But I'm facing a problem regarding the timeline topic. I have used your data in Excel 2013. But what I face that is I have formatted the date row, which is the order date & Ship date. But when I select the charts, then it shows me the connecting issue. I have researched many times, but my issue still exists. I can't understand how to solve this. Can anyone help me to regard the timeline topic?

[saloriasaxon]

Can I please have the datasets to these wonderful excel Dashboard tutorials! Thanks a bunch! :D

[krishnajikulkarni]

It's nice one
Plz make video on making Dashboard using Reactjs

[sandeeps]

This vedio is more informative can u please send me data file

[SeaniBeauty]

Could you please share the sample Dataset Excel Sheet

[pijushdas]

Love this tutorial, can you please provide some more sample datasets in my mail

[uttampriyadarshi]

Nice tutorial can you pls provide me data sheet thanks..

[SOS_]

then map doesnt update on selecting a country why is that so can some one help?

[venkateswararao]

Hi Team, can you attach dataset also here please