This is a practical, beginner‑friendly Excel training designed to help you:
✔ A complete structured curriculum from beginner to confident intermediate
✔ Step‑by‑step lessons on data entry, formatting, formulas, and analysis
✔ Real‑world projects like invoices, dashboards, score sheets, and reports
✔ Hands‑on practice activities and assignments in every module
✔ Training on charts, PivotTables, data cleaning, and lookup functions
✔ A full Excel shortcuts section for speed and productivity
✔ Practical scenarios used in business, finance, education, and admin
Most people learn Excel but still struggle to:
This course changes that.
You won’t just learn features — you’ll build practical Excel solutions step by step.
✔ Absolute beginners
✔ Students learning practical digital skills
✔ Professionals in business, finance, admin, or education
✔ Data analysts and aspiring AI professionals
✔ Freelancers and entrepreneurs
✔ Anyone who wants to work smarter with data
✔ Beginner‑friendly, practical learning
✔ Built around real workplace tasks
✔ Helps learners become job‑ready
✔ Project‑based learning that builds confidence
By the end of this course, you will:
✔ Use Excel confidently for real‑world tasks
✔ Analyse and visualise data professionally
✔ Build dashboards and reports
✔ Use formulas and functions with ease
✔ Clean and prepare datasets
✔ Create portfolio‑ready Excel projects
✔ Be prepared for admin, analyst, and business roles
✔ Lifetime access
✔ Downloadable practice files
✔ Real‑world datasets
✔ Continuous updates
✔ Guided projects and exercises
✔ Self‑paced learning
Access your training on your:
Anytime. Anywhere. At your own pace.
This course takes a complete beginner from typing their first cell entry to confidently building interactive dashboards with PivotTables, charts, and lookup functions. Each week builds directly on the last — skills compound, so no session is skippable. By the end of Week 4, learners will be able to clean, analyse, summarise, and visually present real-world data without help.
|
Course Detail |
Value |
Notes |
|
Duration |
4 Weeks |
1 session per week, about 2-3 hours each |
|
Format |
Lecture + Hands-on Practice |
Each session ends with a practice exercise |
|
Prerequisite |
None |
Designed for true beginners |
|
Tools Needed |
Microsoft Excel (365/2021 preferred) |
XLOOKUP requires 365 or 2021+ |
|
Outcome Level |
Proficient / Job-Ready |
Comfortable with formulas, PivotTables, dashboards |
Femi Ogunesan is a Data Analyst with expertise in Business Intelligence, Data Visualization, and Emerging AI-Driven Analytics. He is passionate about transforming complex datasets into actionable insights that support informed decision-making, operational efficiency, and business growth. Through hands-on experience across diverse sectors, he has developed strong analytical capabilities in Power BI, Excel, Python, and MySQL, enabling organizations to uncover trends, optimize performance, and solve real-world challenges.
Microsoft Excel is a spreadsheet software application developed by Microsoft. It allows you to enter, organise, calculate, analyse, and visually present data using a grid of rows and columns. Excel is part of the Microsoft Office (and Microsoft 365) family of productivity tools, alongside Word and PowerPoint.
|
💡 Beginner Explain. |
Think of Excel as a digital version of a ruled notebook, but one that can also do maths for you, sort your information automatically, and turn your numbers into colourful charts. A normal notebook just stores what you write. Excel stores it AND understands it — if you change one number, everything connected to it updates instantly. |
|
Use Case |
Example |
|
Record keeping |
A list of students, employees, customers, or inventory items |
|
Calculations |
Automatically adding up sales, calculating salaries, computing taxes |
|
Data analysis |
Finding the average score, the top-performing product, or monthly trends |
|
Reporting |
Turning raw numbers into a clear summary table or chart for a meeting |
|
Budgeting & Finance |
Tracking income and expenses, building a household or business budget |
|
Scheduling & Planning |
Timetables, project plans, attendance registers |
|
Dashboards |
An interactive, visual summary of business or school performance |
Before you can learn Excel, you need Excel installed on your computer. This lecture walks through the entire installation process from start to finish — from signing in to Microsoft's website, downloading the installer, running it, and opening Excel for the very first time.
|
💡 Beginner Explain. |
Installing Excel is like collecting a key for a new house. First you prove you're allowed to have the key (signing in with your Microsoft account), then you receive the key (downloading the installer file), then you use the key to open the door (running the installer), and finally you walk in and look around (opening Excel for the first time). Each step in this lecture is one of those stages. |
Microsoft Excel is a spreadsheet application used for organizing, analyzing, and storing data. Data entered into Excel generally falls into three main categories: Text, Numbers, and Dates. Understanding how to correctly enter and use these data types is essential for effective data management and analysis.
|
💡 What is Excel? |
Think of Excel like a giant table made up of rows and columns — similar to a ruled notebook, but on your computer. Each box in that table is called a CELL. You click on a cell and start typing to enter data. |
Before we dive in, here are three key terms you will see throughout this guide:
|
Term |
Meaning |
Example |
|
Cell |
A single box in Excel where you enter data |
Click on box A1 to select it |
|
Row |
A horizontal line of cells (going across) |
Row 1 contains headings like Name, Age, City |
|
Column |
A vertical line of cells (going down) |
Column A lists all student names |
This lecture explains essential Excel operations including editing cell content, using AutoFill and Flash Fill, and copying and moving data. These skills are fundamental for efficient spreadsheet management.
|
💡 Why This Matters |
Once you can enter data (from the previous lecture), the next step is knowing how to EDIT it, FILL it quickly, and MOVE it around. These four skills — editing, AutoFill, Flash Fill, and copy/move — will save you hours of work every week! |
What You Will Learn in This Lecture
|
# |
Topic |
What It Helps You Do |
|
1 |
Editing Cells |
Fix mistakes or update any data already entered |
|
2 |
AutoFill |
Fill a series (1,2,3 or Mon,Tue,Wed) in seconds |
|
3 |
Flash Fill |
Split or combine text automatically using pattern detection |
|
4 |
Copying Data |
Duplicate data to another cell or sheet without retyping |
|
5 |
Moving Data |
Relocate data to a different position on your spreadsheet |
Topics Covered in This Lecture
|
# |
Topic |
What You Will Learn |
|
1 |
Working with Rows, Columns & Cells |
Understand the building blocks of Excel |
|
2 |
Inserting & Deleting Rows/Columns |
Add or remove structure from your sheet |
|
3 |
Adjusting Row Height & Column Width |
Make data visible and well-spaced |
|
4 |
Hiding & Unhiding Rows/Columns |
Temporarily remove rows/columns from view |
|
5 |
Merging & Wrapping Cells |
Combine cells and display long text neatly |
|
6 |
Navigating Large Worksheets |
Move around big spreadsheets efficiently |
|
7 |
Selecting Cell Ranges |
Select groups of cells for bulk actions |
|
8 |
Freezing Panes |
Keep headers visible while scrolling |
