+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
Login Create Account
Categories
Home Courses Career Tracks Live Bootcamps Pricing
Start Learning
Advanced Excel for Data Analytics
Courses Excel

Advanced Excel for Data Analytics

Advanced Excel Skills for Data Analytics
469 Students
48 Lectures
Thomas Festus Cudjoe
Thomas Festus Cudjoe

Instructor

About the Course
Content
Comments 0
Reviews 0

About This Course


Thomas Festus Cudjoe
Thomas Festus Cudjoe
(20)
35 Courses
2158 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.
Thomas Festus Cudjoe Book a Meeting
Curriculum Overview

This course includes 5 modules, 48 lessons, and 5:16 hours of materials.

Cell referencing
5 Parts | 0:41 Hours
📥 Download the sample workbook

Download the exercise files

Study Duration 1 Minutes
Attachments 0
1 Cell referencing - Relative cell reference

Cell referencing - Relative reference

Study Duration 10 Minutes
Attachments 0
2 Cell referencing - Absolute cell reference

Cell referencing - Absolute cell reference

Study Duration 9 Minutes
Attachments 0
3 Cell referencing - Mixed cell reference

Mixed cell reference

Study Duration 13 Minutes
Attachments 0
4 Using defined names in formulas

Using defined names in formulas

Study Duration 8 Minutes
Attachments 0
Advanced Functions
14 Parts | 2:21 Hours
📥 Download the sample workbook

📥 Download the sample workbook and follow along.

Study Duration 1 Minutes
Attachments 0
1 Introduction to VLOOKUP and XLOOKUP

Working with VLOOKUP and XLOOKUP

Study Duration 14 Minutes
Attachments 0
2 VLOOKUP Demo

VLOOKUP practice example

Study Duration 8 Minutes
Attachments 0
3 Using COUNTIFS function

Using COUNTIFS function

Study Duration 16 Minutes
Attachments 0
4 Using SUMIFS function

Using SUMIFS function

Study Duration 16 Minutes
Attachments 0
5 Using AVERAGEIFS function

Using AVERAGEIFS function

Study Duration 11 Minutes
Attachments 0
6 Using MINIFS and MAXIFS

Using MINIFS and MAXIFS

Study Duration 10 Minutes
Attachments 0
7 VLOOKUP vs XLOOKUP - EXACT MATCH

XLOOKUP AND VLOOKUP - EXACT MATCH

Study Duration 9 Minutes
Attachments 0
8 VLOOKUP vs XLOOKUP - APPROXIMATE MATCH

VLOOKUP vs XLOOKUP - APPROXIMATE MATCH

Study Duration 19 Minutes
Attachments 0
9 Using the UNIQUE function

Using the UNIQUE functions

Study Duration 4 Minutes
Attachments 0
10 The SORT AND SORTBY Functions

The SORT AND SORTBY Functions

Study Duration 11 Minutes
Attachments 0
11 The FILTER Function

The FILTER Function

Study Duration 20 Minutes
Attachments 0
Project 1

Project 1

Study Duration 1 Minutes
Attachments 0
Project 2

Project 2

Study Duration 1 Minutes
Attachments 0
Working with arrays
3 Parts | 0:22 Hours
📥 Download the sample workbook

📥 Download the sample workbook

Study Duration 1 Minutes
Attachments 0
1 Combining data with VSTACK and HSTACK

Working with VSTACK and HSTACK

Study Duration 8 Minutes
Attachments 0
2 Transpose arrays with TOCOL and TOROW Functions

TOCOL and TOROW Functions

Study Duration 13 Minutes
Attachments 0
Working with Excel Tables
19 Parts | 1:14 Hours
📥 Download the sample workbook

📥 Download the sample workbook

Study Duration 1 Minutes
Attachments 0
Why Excel Tables

Benefits of working with Excel Tables

Study Duration 3 Minutes
Attachments 0
How to create excel table

How to create excel table

Study Duration 3 Minutes
Attachments 0
Changing table name

Changing table name

Study Duration 2 Minutes
Attachments 0
Table Styles

Table Styles

Study Duration 4 Minutes
Attachments 0
Sorting Table

Sorting Table

Study Duration 5 Minutes
Attachments 0
Filtering Table

Filtering Table

Study Duration 7 Minutes
Attachments 0
Filter Table with Slicers

Filter Table with Slicers

Study Duration 7 Minutes
Attachments 0
Calculated Columns

Calculated Columns

Study Duration 5 Minutes
Attachments 0
Adding Total Row

Adding Total Row

Study Duration 2 Minutes
Attachments 0
Structured Reference 1

Structured Reference 1

Study Duration 6 Minutes
Attachments 0
Structured Reference 2

Structured Reference 2

Study Duration 8 Minutes
Attachments 0
Structured Reference 3

Structured Reference 3

Study Duration 4 Minutes
Attachments 0
Using PivotTables with Tables

Using PivotTables with Tables

Study Duration 7 Minutes
Attachments 0
Using Chart with Tables

Using Chart with Tables

Study Duration 2 Minutes
Attachments 0
Resizing table

Resizing table

Study Duration 4 Minutes
Attachments 0
Convert table to range

Convert table to range

Study Duration 2 Minutes
Attachments 0
Module Conclusion

Module Conclusion

Study Duration 1 Minutes
Attachments 0
Project 3

Project 3

Study Duration 1 Minutes
Attachments 0
Introduction to PivotTables
7 Parts | 0:38 Hours
Download dataset

Dataset

Study Duration 1 Minutes
Attachments 0
Datasets walkthrough

Datasets walkthrough

Study Duration 4 Minutes
Attachments 0
Introduction to PivotTables

Introduction to PivotTables

Study Duration 7 Minutes
Attachments 0
Navigating the areas of a PivotTables

Navigating the areas of a PivotTables

Study Duration 8 Minutes
Attachments 0
Analyze Data with multiple fields

Analyze Data with multiple fields

Study Duration 8 Minutes
Attachments 0
Demo: Working with multiple fields

Demo: Working with multiple fields

Study Duration 9 Minutes
Attachments 0
Project 4

Project 4

Study Duration 1 Minutes
Attachments 0
Certificates
1 Parts
Course Certificate
Course Certificate
If you pass all the lessons in this course, you will receive this certificate.
Type Course Certificate
Leave a Comment
Please log in to leave a comment.
Reply to Comment
Comments Approval

Your comment will be visible after admin approval.

0
0 Reviews
Content Quality (0)
Instructor Skills (0)
Value for Money (0)
Support Quality (0)
Reply to Review
Submit Reply

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

Advanced Excel for Data Analytics
GH₵200
Enroll with Pro Account

This Course Includes

Official Certificate
Instructor Support
Favorite
Share
Report Content

Course Specifications

Sections
5
Lessons
48
Capacity
Unlimited
Duration
1:30 Hours
Students
469
Created Date
7 Mar 2024
Updated Date
6 Jan 2026
Thomas Festus Cudjoe
Thomas Festus Cudjoe

Founder & Lead Instructor

(20)
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
Profile

Send Course as Gift

Send as a gift to friends
Advanced Excel for Data Analytics
You are viewing
Advanced Excel for Data Analytics
footer cta btn icon
Let’s get started now!

Take the First Step in Tech!

Explore courses

Learn

Self paced courses Career tracks Bootcamps Certificate Validation Pricing

Explore

Microsoft Excel Power BI SQL Generative AI Python

Contact Us

1st Floor, World Trade Centre, Accra
+233 54 123 9290
+233 54 123 9290
support@festman.io
© 2025 FestMan Learning. All Rights Reserved. Empowering digital pioneers.
LinkedIn Facebook Instagram Whatsapp
Cart
Subtotal
View Cart