Create rich and interactive Dashboard using Microsoft Excel

Learn how to build a fully interactive and a self-service business intelligence dashboard using Microsoft Excel.
What you'll learn
Analyze data using PivotTables
Visualize insights using advanced charts in Excel
Customize report themes and backgrounds in Excel
Work with slicers and reports connection
Design interactive dashboards and reports
Protect workbooks and worksheets
Design custom visuals in Excel
Requirements
You need Microsoft Excel 2010 or later version for Windows or Mac. This course is filmed with Excel for windows, However, if you are Mac user, you can still follow the lessons.
You know how to work with basic formulas and functions in Excel.
Basic knowledge of PivotTables is required.
Description
Data visualization and Dashboard design skills have become a sought-after skill and valuable to businesses in almost all industries.A dashboard is a visual representation of key metrics that allow users to quickly view and analyze data in one place.Dashboards not only provide consolidated data views, but serves as a self-service business intelligence tool, where users are able to explore data and discover insights quickly.Using Data Analytics tools like Microsoft Excel, you can develop rich and interactive dashboards and reports. In this course, you will learn how to use Microsoft Excel to analyze and visualize data to design interactive and automate reports and dashboards.Your ability to design and develop a compelling and automated dashboards and reports will help you stand out at the workplace and help you accelerate your career.This course is designed for individuals and analysts who use data in the business setting. If you are responsible for presenting data in your day-to-day job, or a data analyst, then this course is for you. You will learn how to design interactive and visually striking dashboard using Microsoft Excel. We will adopt a guided learning approach to help you learn and master the concept and the process for designing rich and dynamic dashboards.
Who this course is for
Microsoft Excel users
Professionals who work with Excel to develop reports and dashboards
Data Analysts
Accounting and Finance professionals
Data Science professionals
Data analytics enthusiasts
Homepage

https://www.udemy.com/course/create-rich-and-interactive-dashboard-using-microsoft-excel/