Create rich and interactive Dashboard using Microsoft Excel.

Focused View

FestMan Learning Hub, Thomas Festus Cudjoe

2:36:48

122 View

1. Introduction

1. Introduction.mp4

01:26

2. Prerequisites.html

3.1 Datasets.xlsx

3. Datasets and walkthrough.mp4

03:38

4. Project Overview.mp4

02:19

5. Project Roadmap.mp4

01:52

6. Demo Explore Datasets.mp4

03:38

7. Demo Adding Calculated Columns.mp4

05:23

2. Data Analytics with PivotTables

1. Demo Key Performance Indicators.mp4

07:20

2. Demo Formatting KPIs.mp4

04:22

3. Demo Top 5 Destination Countries.mp4

04:28

4. Demo Top Origin Countries.mp4

02:40

5. Demo Customers by Gender.mp4

02:31

6. Demo Booking and Profit by Gender.mp4

02:20

7. Demo Customers by Gender and Age Groups.mp4

04:43

8. Demo Year on Year Profit Analysis.mp4

05:00

3. Data visualization and report development

1. Demo Customize report theme.mp4

06:27

2. Demo Customize report background.mp4

07:33

3. Demo Visualize KPIs.mp4

10:40

4. Demo Visualize Top 5 Destination countries.mp4

07:01

5. Demo Visualize Top 5 Origin Countries.mp4

05:22

6. Demo Visualize Customers by Gender.mp4

09:02

7. Demo Visualize YoY Profit Analysis.mp4

10:35

8. Demo Visualize Customers Booking and Profit.mp4

08:38

9. Demo Filter report with Slicers.mp4

06:29

10. Demo Connect slicers to multiple pivot reports.mp4

06:08

11. Demo Formatting slicers.mp4

07:21

12. Demo Workbook and worksheet protection.mp4

06:03

13. Demo Add emojis.mp4

04:30

14. Demo Design Dark version.mp4

09:19

Description

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

Who is this 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

More details

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

User Reviews

Rating

average 0

Total votes0

Focused display

Festus is a Microsoft Data Platform MVP and Microsoft Certified Power BI Data analyst, an Associate Member of the Institute of Chartered Accountants, Ghana(ICAG), and a Chartered Global Management Accountant with professional qualifications from Chartered Institute of Management Accountants, UK (CIMA).He is also a Microsoft Certified Trainer and a Microsoft Certified Excel 2016 Expert.As a Data analyst and Finance Professional, he is passionate about using emerging technologies and tools to generate forward-looking and actionable insights to support business decisions.Over the past 4 years, Festus has trained 1,000+ professionals in Data analytics. Power BI and Financial Modeling with Excel.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.