+233 54 123 9290
support@festman.io
English flag
English
Select a Language
English flag
English
GH₵
GHS
Select a Currency
Ghanaian cedi
GH₵
Euro Member Countries
€
Nigeria Naira
₦
United States Dollar
$
0
Design Impactful Dashboard with Excel

Design Impactful Dashboard with Excel

(2)
169 Students
25 Lectures

What Will You 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

Check the frequently asked questions about this course.

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
Thomas Festus Cudjoe
Thomas Festus Cudjoe
(21)
35 Courses
2247 Students
Festus is a Senior Data Analyst, Finance Professional, and Chartered Accountant (CIMA & ICAG) with 7+ years of experience in analytics and business intelligence. He specializes in Power BI, SQL, Python, financial modeling, and AI-driven analytics. At FestMan, he delivers practical, project-based training in Excel, Power BI, Python, SQL, and Applied AI for work. Festus is a Microsoft Certified Trainer, Power BI Certified Analyst, Microsoft Excel Expert, and a 4x Microsoft Data Platform MVP.

Recent Reviews

See what students are saying about the course.

More Reviews
Abdul- Rahman Amadu
Abdul- Rahman Amadu 11 Jan 2024
Andrew  kodwo Fynn
Andrew kodwo Fynn 19 Jul 2023
Fantastic videos. worth every cedi.
Curriculum Overview

This course includes 4 modules, 25 lessons, and 0:06 hours of materials.

Course Overview
2 Parts | 0:04 Hours
Course Overview

Course Overview

Study Duration 2 Minutes
Attachments 0
Learning Objectives

Learning Objectives

Study Duration 2 Minutes
Attachments 0
🎯DATA EXPLORATION AND BUSINESS QUESTIONS
5 Parts | 0:01 Hours
Getting started

Getting started with the course

Study Duration 1 Minutes
Attachments 0
Dashboard Preview
Volume 11.63 MB
Download exercise file
Volume 10.30 MB
Explore Dataset
Volume 18.40 MB
Business Questions
Volume 66.13 MB
🧑‍💻 DATA ANALYSIS WITH PIVOTTABLES
6 Parts
Working on Key Performance Indicators
Volume 31.28 MB
Breakdown of Total Revenue
Volume 32.59 MB
Month Over Month Revenue Analysis
Volume 14.68 MB
Customer and Revenue Analysis by Gender
Volume 29.48 MB
Products and Delivery Analysis
Volume 40.66 MB
Top 5 Products by Revenue
Volume 19.23 MB
📈DASHBOARD DESIGN
12 Parts | 0:01 Hours
Working on the Dashboard Page
Volume 22.41 MB
Visualizing the Key Performance Indicators
Volume 44.17 MB
Finalizing the KPIs visuals
Volume 29.36 MB
Visualizing Total Revenue Analysis
Volume 68.42 MB
Visualizing Product Subcategory Analysis
Volume 69.06 MB
Visualizing Month Over Month analysis
Volume 40.02 MB
Visualizing top 5 products by revenue
Volume 42.01 MB
Adding images to spice up the dashboard
Volume 41.17 MB
Download images

How to download the images for the dashboard

Study Duration 1 Minutes
Attachments 0
Adding slicers to provide interactivity
Volume 34.26 MB
Customizing the slicers to support theme
Volume 57.84 MB
Creating different Dashboard Theme
Volume 33.80 MB
Certificates
1 Parts
Course Certificate
Course Certificate
If you pass all the lessons in this course, you will receive this certificate.
Type Course Certificate
Reply to Comment
Comments Approval

Your comment will be visible after admin approval.

5.00
2 Reviews
Content Quality (5)
Instructor Skills (5)
Value for Money (5)
Support Quality (5)
Abdul- Rahman Amadu
Abdul- Rahman Amadu
11 Jan 2024 08:48 am
Andrew  kodwo Fynn
Andrew kodwo Fynn
19 Jul 2023 05:23 pm
Fantastic videos. worth every cedi.
Reply to Review
Submit Reply

Your reply to this review will be visible to all users.

Design Impactful Dashboard with Excel
GH₵199
Enroll with Pro Account

This Course Includes

Downloadable Content
Official Certificate
Instructor Support
Course Forum

Course Specifications

Sections
4
Lessons
25
Capacity
Unlimited
Duration
3:00 Hours
Students
169
Created Date
6 Apr 2023
Updated Date
17 Jul 2025
Thomas Festus Cudjoe
Thomas Festus Cudjoe

Founder & Lead Instructor

(21)
Microsoft Certified Trainer
Microsoft Certified Excel Expert
Microsoft Certified Power BI Analyst
Google Certified Data Analyst
Microsoft Office Specialist: Excel 2013
Microsoft MVP
10 courses launched
Microsoft Certified Excel Expert

Send Course as Gift

Send as a gift to friends
Design Impactful Dashboard with Excel
You are viewing
Design Impactful Dashboard with Excel