.png)
Design Interactive Dashboard with Excel
in Data Analytics with Microsoft ExcelWhat you will learn?
Report design in Microsoft Excel
Data analysis using PivotTables
Using charts and graphs in Excel
Pivot charts and graphs
Dashboard Design
Workbook and worksheet protection.
About this course
This course is a hands-on course designed to help you master the art of designing rich and interactive dashboards and report using Microsoft Excel.
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 a Business Intelligence tool 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.
Who should enroll in this course?
This course is designed for individuals who use data in the business
setting. If you are responsible for presenting data in your day-to-day job, or
a data analyst and you want to improve your reporting skills, then this course is for you.
Benefit of this course
👉 A guided learning approach.
👉Hands-on and highly practical.
👉Dataset and the Completed Dashboard.
👉quality videos.
👉Access to support from instructor.
👉Certificate of completion.
👉Lifetime access to videos
Prerequisites:
👉 To get most of the course, 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 need to know how to work with basic formulas and functions in Excel.
👉 Basic knowledge of PivotTables is required. If you are new to PivotTables, you can check our free Excel fundamentals course.
Note: This course is not for complete beginners. If you are a complete beginner or new to Excel, we encourage you to check our free Excel fundamentals course before signing up for this course.
Requirements
To get the most of the course, 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. If you are new to PivotTables, you can check our free Excel fundamentals course.
Comments (0)
Download the practice files and the completed Dashboard. The completed file should only be used as guide. Learn from the video and produce your own version of the dashboard.
What you need to get started.
Palette color scheme
#F4748D
#F88D74
#8183B9
#FD8D89
#6264A7
#F15171
#002C58
Course review
You are required to complete your version of the dashboard and submit to our team for review.
Upload your Excel file on Google drive and share the link in the description below. Please make link public when sharing.
.png){kind=small}
.png){kind=small}
 (1920 × 900 px) (3).png)