+233 54 123 9290
support@festman.io
Select a Language
.png)
Excel fundamentals for Data Analytics
This hands-on and beginner-friendly course is designed to help learners master the most essential Excel skills for real-world data tasks.
(4)
758
Students
66
Lectures
Thomas Festus Cudjoe
Instructor
What Will You Learn?
About This Course
Requirements
FAQ
Check the frequently asked questions about this course.
Is this course suitable for beginners?
Yes. This course is designed for absolute beginners with no prior Excel experience or data analytics skills.
Are there hands-on projects in the course?
Yes. The course includes multiple practice exercises and projects to help you apply what you learn to real-world scenarios.
Will I get a certificate after completing this course?
Yes. Once you complete all lessons and reach 100% course completion, you will receive a certificate of completion.
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
Blessed Aseda
18 Nov 2025
Kimathi Amenyo
17 Nov 2025
Abdul Rahman Mohammed Hardi
15 Nov 2025
Daniel Akisanya
31 May 2025
Related Courses
Explore newly published courses and stay updated.
Curriculum Overview
This course includes 9 modules, 66 lessons, and 7:01 hours of materials.
Course introduction
3 Parts | 0:05 Hours
Introduction to the course
Introduction to the course
Study Duration
3 Minutes
Attachments
0
What you need for this course
What you will need to get started
Study Duration
1 Minutes
Attachments
0
Download sample practice workbooks
Download sample practice workbooks
Study Duration
1 Minutes
Attachments
0
Introduction to Microsoft Excel
2 Parts | 0:15 Hours
1.1 Exploring excel interface
Free
Explore Microsoft excel interface
1.2 Excel backstage view
Excel backstage view
Study Duration
7 Minutes
Attachments
0
Working with Excel Workbooks
5 Parts | 0:55 Hours
2.1 Manage workbooks
Manage workbooks
Study Duration
6 Minutes
Attachments
0
2.2 Manage worksheets
Manage worksheets
Study Duration
15 Minutes
Attachments
0
2.3 Working rows and columns
Working rows and columns
Study Duration
16 Minutes
Attachments
0
2.4 working with cells
working with cells
Study Duration
13 Minutes
Attachments
0
Project 1
Apply your skills to a project
Study Duration
5 Minutes
Attachments
0
Entering and formatting data
8 Parts | 0:52 Hours
3.1 Entering data into cell
Entering data into cell
Study Duration
7 Minutes
Attachments
0
3.2 Entering time and multiple values
Entering time and multiple values
Study Duration
7 Minutes
Attachments
0
3.3 Formatting values
Formatting values
Study Duration
7 Minutes
Attachments
0
3.4 Applying custom formatting
Applying custom formatting
Study Duration
10 Minutes
Attachments
0
3.5 Auto Fill
Auto Fill
Study Duration
9 Minutes
Attachments
0
3.6 Creating custom list
Custom List
Study Duration
5 Minutes
Attachments
0
3.6 Undo and redo
Undo and redo operations
Study Duration
2 Minutes
Attachments
0
Project 2
Test your skills
Study Duration
5 Minutes
Attachments
0
Data validation
11 Parts | 0:44 Hours
Download exercise file
Download exercise file and follow along with the video.
Study Duration
1 Minutes
Attachments
0
Introduction to Data validation
Introduction to Data validation
Study Duration
2 Minutes
Attachments
0
Creating a drop down list
Creating a drop down list
Study Duration
5 Minutes
Attachments
0
Creating expandable drop down list
Creating expandable drop down list
Study Duration
6 Minutes
Attachments
0
Whole numbers restriction
Whole numbers restriction
Study Duration
5 Minutes
Attachments
0
Decimals
Decimals
Study Duration
3 Minutes
Attachments
0
Text validation
Text validation
Study Duration
5 Minutes
Attachments
0
Date validation
Date validation
Study Duration
6 Minutes
Attachments
0
Custom option
Custom option
Study Duration
5 Minutes
Attachments
0
Error Alert and input message
Error Alert and input message
Study Duration
5 Minutes
Attachments
0
Module conclusion
Module conclusion
Study Duration
1 Minutes
Attachments
0
Managing data
12 Parts | 1:20 Hours
6.1 Sort data chronologically
Sorting Data
Study Duration
4 Minutes
Attachments
0
6.2 Sort data alphabetically
Sorting Text Data
Study Duration
3 Minutes
Attachments
0
6.3 Sort data numerically
Sort data numerically
Study Duration
3 Minutes
Attachments
0
6.4 Sort data by color
Sort data by color
Study Duration
3 Minutes
Attachments
0
6.5 Multi-level sorting
Multi-level sort
Study Duration
5 Minutes
Attachments
0
6.6 Filter data by date
Date filters
Study Duration
8 Minutes
Attachments
0
6.7 Filter numeric data
Filter numeric data
Study Duration
7 Minutes
Attachments
0
6.8 Filter data by text pattern
Filter data by text
Study Duration
5 Minutes
Attachments
0
6.9 Advanced Filter
Advanced filter
Study Duration
21 Minutes
Attachments
0
6.10 Freeze panes
Freeze panes
Study Duration
7 Minutes
Attachments
0
6.11 Split window
Split windows
Study Duration
4 Minutes
Attachments
0
6.12 Remove duplicates from datasets
Remove duplicates from datasets
Study Duration
10 Minutes
Attachments
0
Introduction to Basic Excel functions
11 Parts | 1:49 Hours
Download the exercise files
Download the exercise files
Study Duration
1 Minutes
Attachments
0
Introduction to Basic Excel formulas
Introduction to Basic Excel formulas
Study Duration
15 Minutes
Attachments
0
Introduction to basic functions
Introduction to basic functions
Study Duration
14 Minutes
Attachments
0
The IF Function
The IF Function
Study Duration
28 Minutes
Attachments
0
Introduction to Date functions
Introduction to Date functions
Study Duration
8 Minutes
Attachments
0
Using case functions
UPPER, LOWER and PROPER Functions
Study Duration
7 Minutes
Attachments
0
Extracting Text
LEFT, RIGHT and MID Functions + FLASHFILL
Study Duration
11 Minutes
Attachments
0
Extract Text with TEXTBEFORE, TEXTAFTER
Extract Text with TEXTBEFORE, TEXTAFTER
Study Duration
6 Minutes
Attachments
0
Combining Text
Joining Text with CONCAT and TEXTJOIN Functions
Study Duration
8 Minutes
Attachments
0
6 Using the TRIM and REPT Functions
6 Using the TRIM and REPT Functions
Study Duration
6 Minutes
Attachments
0
Project 3
Apply your skills to real project
Study Duration
5 Minutes
Attachments
0
Excel charts
13 Parts | 1:01 Hours
5.1 Introduction to Excel charts
Introduction to Excel charts
Study Duration
5 Minutes
Attachments
0
5.2 Working with column charts
Working with column charts
Study Duration
10 Minutes
Attachments
0
5.3 Clustered column chart
Column chart 2
Study Duration
4 Minutes
Attachments
0
5.4 Stack column chart
Stack column chart
Study Duration
4 Minutes
Attachments
0
5.5 Bar chart
Working with bar chart.
Study Duration
7 Minutes
Attachments
0
Bar Chart Guide
Download Bar chart guide
Volume
0.84 MB
5.6 Line chart
Working with line chart
Study Duration
7 Minutes
Attachments
0
Line chart guide
Download line chart guide
Volume
0.97 MB
5.7 Working with Pie chart
Pie chart
Study Duration
9 Minutes
Attachments
0
5.8 Protips for working with pie charts
Best practices for working with pie charts
Study Duration
5 Minutes
Attachments
0
Pie Chart Guide
Download Pie chart guide
Volume
1.07 MB
5.9 Working with recommended charts
Exploring recommended charts
Study Duration
5 Minutes
Attachments
0
Final capstone
Final project
Study Duration
5 Minutes
Attachments
0
Course Conclusion
1 Parts
Conclusion
Course conclusion
Study Duration
0 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
5.00
4 Reviews
Content Quality (5)
Instructor Skills (5)
Value for Money (5)
Support Quality (5)
Blessed Aseda
18 Nov 2025 01:31 pm
Kimathi Amenyo
17 Nov 2025 08:20 pm
Abdul Rahman Mohammed Hardi
15 Nov 2025 12:57 am
Daniel Akisanya
31 May 2025 10:18 pm
This Course Includes
Downloadable Content
Official Certificate
Instructor Support
Course Forum
Course Specifications
Sections
9
Lessons
66
Capacity
Unlimited
Duration
7:00 Hours
Students
758
Created Date
9 Feb 2024
Updated Date
18 Dec 2025
.png)
.png)
Send Course as Gift
Send as a gift to friends
You are viewing
Excel fundamentals for Data Analytics
Subscribe to Our Newsletter
Receive expert insights, course updates, and learning resources directly in your inbox and get notified
Contact Us
© 2025 FestMan Learning. All Rights Reserved. Empowering digital pioneers.
.png)
.png)
Reply to Comment