Summary
Keywords
Full Transcript
"️🔥IBM - Data Analyst - https://www.simplilearn.com/data-analyst-certification-course?utm_campaign=OiMMxHpR_WY&utm_medium=DescriptionFFF&utm_source=Youtube ️🔥IITG - Professional Certificate Program in Data Analytics & Generative AI - https://www.simplilearn.com/iitk-professional-certificate-course-data-analytics?utm_campaign=OiMMxHpR_WY&utm_medium=DescriptionFFF&utm_source=Youtube ️️🔥 IIT Delhi - Data Analytics, Generative AI And Adaptive System - https://www.simplilearn.com/ihfc-iitd-data-analytics-genai-course?utm_campaign=OiMMxHpR_WY&utm_medium=DescriptionFFF&utm_source=Youtube ️🔥PL-300 Microsoft Power BI Certification Training with Exam - https://www.simplilearn.com/power-bi-certification-training-course?utm_campaign=OiMMxHpR_WY&utm_medium=DescriptionFFF&utm_source=Youtube ️🔥Tableau Desktop Specialist Certification Training - https://www.simplilearn.com/tableau-training-and-data-visualization-course?utm_campaign=OiMMxHpR_WY&utm_medium=DescriptionFFF&utm_source=Youtube" 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 Dataset Link - https://drive.google.com/drive/folders/1Kt8BIkAzPLROd4XaIK2NRqPVUlAjmLTq ✅Subscribe to our Channel to learn more about the top Technologies: https://bit.ly/2VT4WtH ⏩ Check out the Business Analytics tutorial videos: https://bit.ly/3hQFfDP #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. Executive Certificate Program in General Management: Get your business analysis career started with our Executive Certificate Program in General Management. This business analysis certification program helps you build extensive business expertise with real-world projects and prepares you for the business analyst role. This Executive Certificate Program in General Management 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: ✅ Masterclasses from Industry Expert ✅ 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 Learn more at: https://www.simplilearn.com/general-management-certification-training-course?utm_campaign=BusinessAnalytics&utm_medium=Description&utm_source=youtube
Continue this lesson in the app
Install CourseHive on Android or iOS to keep learning while you move.
