Data Analysis with Microsoft Excel.
What you'll learn
Excel Fundamentals: Master the basic to advanced Excel concepts needed for data work. Move away from the usual and old "VLOOKUP" into new and classy "XLOOKUP". Get used to other advanced Excel functions like FILTER, TEXTJOIN and so on.
Data Wrangling (Power Query): Clean, filter, and transform messy, real-world datasets with ease. Get wowed by the Power Query's fantastic data transformative capabilities.
Data Visualization (Pivot Charts): Build stunning charts and graphs that tell a compelling story from pivot tables. Get to know the stunning attributes of pivot table that makes it a must-have knowledge for useful data analysis.
End-to-End Projects: Build a portfolio of data analysis projects from scratch using Excel concepts.
About this course
Course Details
Live Sessions: Classes commence 10th of July, 2026.
Duration: 4 weeks (24 hours)
Platform: Zoom (Joining details sent upon enrollment)
Certificate of Completion included
Course Description
Ready to transform raw data into actionable insights—live? Data Analysis with Advanced Microsoft Excel for Beginners is an intensive, fully live online program designed to take you from creating simple tables and applying formatting to confidently manipulating, analyzing, and visualizing data using Microsoft Excel. No prior experience required as we'll guide you from Excel basics to advanced Excel concepts.
Because this is a 100% live, interactive Zoom class, you won't just watch recorded videos. You will work under the tutelage of an expert instructor, get real-time feedback, and troubleshoot errors on the spot in an active, supportive environment.
The Live Class Advantage:
Interactive Live Work: Watch the logic unfold and replicate it instantly.
Instant Q&A: Get your questions answered the moment you have them.
Peer Accountability: Learn alongside a dedicated cohort of future data professionals.
By the end of this course, you won't just understand Excel—you will possess the practical, problem-solving mindset of a data analyst or an Advanced Excel user.
What You Will Learn & Master:
Excel Fundamentals: Master the basic to advanced Excel concepts needed for data work.
Data Wrangling (Power Query): Clean, filter, and transform messy, real-world datasets with ease.
Data Visualization (Pivot Charts): Build stunning charts and graphs that tell a compelling story.
End-to-End Projects: Build a portfolio of data analysis projects from scratch
Who this course is for
- You want to learn Excel skills to meet up with the everyday office demands.
- You're a student/professional with no prior experience but want to learn Excel either for skills purposes or to become an Excel data analyst.
- You have Excel skills but curious about what comes next.
- You've been hearing about tech skills but don't know how to proceed, this course is for you.
This course includes
- 24h of lessons
- 11 lessons across 8 sections
- Downloadable course materials
- Yours for life once bought
- Certificate on completion, verifiable by anyone
Course content
8 sections · 11 lessons
Material includes
- A detailed and concise lesson materials for all the topics.
- An entire Excel worksheet consisting of the practical works
- A complete project designed in Excel at the end of the course. It'll serve as a portfolio project you can show to potential employers.
Requirements
- A windows 10 or 11 OS
- Microsoft Excel version 2021 or Excel 365.
- A sound internet connection.
- A Zoom meeting app
Every enrolment includes
- Verified certificate on completion
- Progress tracking & resume
- Community access
₦42,500
₦73,000