+233 54 123 9290

support@festman.io

Design Interactive Dashboard with Excel

(4)

176 Students

29 Lectures

Thomas Festus Cudjoe

Instructor

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

Thomas Festus Cudjoe

(21)

35 Courses

2238 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.

Book a Meeting

Recent Reviews

See what students are saying about the course.

More Reviews

John Amanor Nartey 3 Mar 2026

This course is exceptionally well-structured and stands out for its use of extensive real-world data, which makes the lessons feel highly relevant to ...

Hawa Muhammed-Awwal 6 Nov 2024

Samuel Amoako 12 Sep 2024

Abdul- Rahman Amadu 11 Jan 2024

Curriculum Overview

This course includes 2 modules, 29 lessons, and 0:06 hours of materials.

INTRODUCTION

14 Parts | 0:05 Hours

Training and Completed Workbook

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.

Volume 26.99 MB

Getting started

What you need to get started.

Study Duration 5 Minutes

Attachments 0

Project Overview

Volume 7.12 MB

Project Roadmap

Volume 6.19 MB

Demo: Explore Datasets

Volume 26.57 MB

Demo: Adding Calculated Columns

Volume 41.24 MB

Demo: Key Performance Indicators

Volume 74.78 MB

Demo: Formatting KPIs

Volume 16.16 MB

Demo: Top 5 Destination Countries

Volume 34.22 MB

Demo: Top Origin Countries

Volume 22.50 MB

Demo: Customers by Gender

Volume 22.84 MB

Demo: Booking and Profit by Gender

Volume 14.90 MB

Demo: Customers by Gender and Age Groups

Volume 33.03 MB

Demo: Year on Year Profit Analysis

Volume 32.25 MB

DATA VISUALIZATION AND REPORT DEVELOPMENT

15 Parts | 0:01 Hours

Demo: Customize report theme

Palette color scheme
#F4748D
#F88D74
#8183B9
#FD8D89
#6264A7
#F15171
#002C58

Volume 34.25 MB

Demo: Customize report background

Volume 31.23 MB

Demo: Visualize KPIs

Volume 41.49 MB

Demo: Visualize Top 5 Destination countries

Volume 37.02 MB

Demo: Visualize Top 5 Origin Countries

Volume 32.56 MB

Demo: Visualize Customers by Gender

Volume 44.87 MB

Demo: Visualize YoY Profit Analysis

Volume 39.59 MB

Demo: Visualize Customers Booking and Profit

Volume 44.74 MB

Demo: Filter report with Slicers

Volume 43.68 MB

Demo: Connect slicers to multiple pivot reports

Volume 36.89 MB

Demo: Formatting slicers

Volume 36.91 MB

Demo: Workbook and worksheet protection

Volume 32.07 MB

Demo: Add emojis

Volume 42.17 MB

Demo: Design Dark version

Volume 68.62 MB

Course review and certificate

Course review

Study Duration 1 Minutes

Attachments 0

Certificates

1 Parts

Course Certificate

If you pass all the lessons in this course, you will receive this certificate.

Type Course Certificate

Please log in to leave a comment.

5.00

4 Reviews

Content Quality (5)

Instructor Skills (5)

Value for Money (5)

Support Quality (5)

John Amanor Nartey

3 Mar 2026 08:58 am

This course is exceptionally well-structured and stands out for its use of extensive real-world data, which makes the lessons feel highly relevant to actual business scenarios. While the core content is solid, the addition of a Power Query module in future iterations would be a game-changer. I highly recommend this course for anyone looking to bridge the gap between theory and practice. The instructor does an excellent job organizing the material and providing practical datasets that mirror professional challenges.