Design Impactful Dashboard with Excel

What you will learn?

Analyze Data using PivotTables and charts

How to develop and improve user experience using Slicers and timelines

Perform time intelligence calculations using PivotTables

Apply conditional formatting to your PivotTables to highlight values

Visualize Data Using PivotCharts

Develop interactive Dashboards by applying your knowledge in PivotTables, Slicers, and Conditional formatting.

About this course

In today's data-driven world, creating a visually appealing
and easy-to-use dashboard is essential for effective data analysis and decision
making. This course will teach you the fundamentals of designing and building
effective dashboards using Excel.

Throughout the course, you will learn how to use Excel to
create dynamic and interactive dashboards that allow you to explore your data
quickly and easily. You will learn how to organize your data, create charts and
graphs, and use advanced Excel features such as pivot tables and slicers to
build powerful dashboards.

FAQ

What are the requirements to take the course?

The course is designed for anyone who want to master the art of dashboard designing with Microsoft Excel. To get the most out of the course, you need to know the basics of Excel Pivot Tables.

Can I download the Excel files and the completed dashboard for the course?

Yes! All the exercise files in this course are downloadable. We have also provided the completed dashboard file to be used a reference. These files are fully downloadable but they are not shareable. Sharing the files with 3rd parties is against our policy.

How long do I have to complete the course?

This course is self-paced so you can complete it at your own pace. You can access the course on your PC or mobile device. You have lifetime access to the course. Though the course can be completed at your own pace, we encourage our students to access the course and learn as soon as possible. You never know when opportunity will knock so make hay while the sun shines.

How do I earn my certificate?

To receive a verifiable certificate for this course, you must complete all the video lessons, quizzes, and final assessments if any. Make sure to make all the lessons as passed in the course learning page.

Is the certificate verifiable?

Absolutely! Your certificate can be verified by anyone on our certificate validation page using your unique certificate ID. Certificates can be verified via https://festman.io/certificate_validation.

Do I pay any additional fee for the certificate?

Certificates are free as far as you have met the requirements to earn that certificate.

Can I get in touch with the instructor if I have questions or need support?

Sure! Even though the course is self paced, our instructors are closer to you than you think. Our Instructors are always available to support you on every step of the way. You can book a meeting with the instructor or send an email on the instructors page. We also have a course forum where you can connect with other students and ask questions or get help. In summary, these are the options available for support: 👨‍👩‍👧‍👦 Course forum 📧 Email Support 📽️ Live meeting with instructor

Comments (0)

Course Overview

2 Parts - 0:04 Hr

Course Overview

2 Min

Attachments:

Learning Objectives

2 Min

Attachments:

🎯DATA EXPLORATION AND BUSINESS QUESTIONS

5 Parts - 0:01 Hr

Getting started

Getting started with the course

1 Min

Attachments:

Dashboard Preview

11.63 MB MB

Download exercise file

10.30 MB MB

Explore Dataset

18.40 MB MB

Business Questions

66.13 MB MB

🧑‍💻 DATA ANALYSIS WITH PIVOTTABLES

6 Parts

Working on Key Performance Indicators

31.28 MB MB

Breakdown of Total Revenue

32.59 MB MB

Month Over Month Revenue Analysis

14.68 MB MB

Customer and Revenue Analysis by Gender

29.48 MB MB

Products and Delivery Analysis

40.66 MB MB

Top 5 Products by Revenue

19.23 MB MB

📈DASHBOARD DESIGN

12 Parts - 0:01 Hr

Working on the Dashboard Page

22.41 MB MB

Visualizing the Key Performance Indicators

44.17 MB MB

Finalizing the KPIs visuals

29.36 MB MB

Visualizing Total Revenue Analysis

68.42 MB MB

Visualizing Product Subcategory Analysis

69.06 MB MB

Visualizing Month Over Month analysis

40.02 MB MB

Visualizing top 5 products by revenue

42.01 MB MB

Adding images to spice up the dashboard

41.17 MB MB

Download images

How to download the images for the dashboard

1 Min

Attachments:

Adding slicers to provide interactivity

34.26 MB MB

Customizing the slicers to support theme

57.84 MB MB

Creating different Dashboard Theme

33.80 MB MB

5.00

3 Reviews

Content quality (5)

Instructor skills (5)

Purchase worth (5)

Support quality (5)

Reviews (3)

Content quality

Instructor skills

Purchase worth

Support quality

Zion Bonzo

11 Jul 2023 | 20:06

I recently completed the "Design Impactful Dashboard with Excel" course on Festman Learning Hub, and I must say it was an exceptional learning experience. This course provided comprehensive guidance on utilizing pivot tables to create visually stunning and effective dashboards within Excel. I am thrilled to share my review of this remarkable course. From the very beginning, the course captivated my attention with its clear and concise explanations. The instructor's expertise and teaching style made complex concepts easily understandable. The step-by-step approach enabled me to follow along effortlessly, even as a beginner in Excel dashboard design. The course content was well-structured and covered a wide range of topics essential for dashboard creation. Starting with the basics of pivot tables, the course gradually progressed to advanced techniques for data analysis and visualization. I particularly appreciated the practical examples and real-world scenarios that were provided, as they allowed me to apply the concepts learned and gain hands-on experience. One aspect that truly stood out was the emphasis on designing impactful dashboards. The instructor stressed the importance of creating visually appealing and user-friendly interfaces, while also focusing on delivering key insights effectively. I learned how to choose appropriate chart types, use conditional formatting to highlight critical information, and incorporate interactivity to enhance user experience. Overall, I wholeheartedly recommend the "Design Impactful Dashboard with Excel" course on Festman Learning Hub to anyone looking to enhance their Excel skills and create visually compelling dashboards. This course provides a solid foundation in pivot table usage, along with advanced techniques for designing impactful and informative dashboards. Whether you are a beginner or have some experience with Excel, this course will undoubtedly take your skills to the next level.