Office and productivity
Microsoft Office: Beginner to Advanced
Word, Excel and PowerPoint, taught the way offices actually use them.
Online from₦65,000$48
OnlineOn-site
Microsoft Excel Training: Beginner to Advanced
Stop copying numbers by hand. Let the spreadsheet do the arithmetic.
- 6 weeks
- Beginner to advanced
- Online and on-site
Animated preview
Excel is one of the quietly valuable skills in modern work. Accountants, storekeepers, analysts and founders all live in it, and the gap between a casual user and a confident one is enormous.
This course builds from tidy data entry to lookups, pivot tables and one-page dashboards. Every week ends with a real scenario: a shop's stock, a payroll sheet, a monthly sales report.
What you will build
- A stock and sales tracker for a small shop
- A payroll calculator using logic formulas
- A monthly sales dashboard with slicers
The journey
01
Excel foundations
Cells, formatting, tables and clean data entry.
02
Formulas and functions
SUM, AVERAGE, IF, COUNTIF, SUMIF and cell references.
03
Lookups and text tools
VLOOKUP, XLOOKUP, text and date functions.
04
Pivot tables and charts
Summarise thousands of rows in seconds; slicers and chart types.
05
Dashboards
Data validation, conditional formatting and one-page reports.
Tools you will use
- Excel
- Pivot tables
- Charts
- Data validation
Who it is for
Accounts and admin staff, shop owners, students and anyone who suspects a spreadsheet could save them hours.
Before you enrol
Can I use Google Sheets?
Most ideas carry over, but we teach in Excel because that is what employers ask for.
Is this a step towards data analysis?
Yes. It is the natural first step before the Data Analysis course.
Keep building
Digital foundations
Computer Basics for Absolute Beginners
Switch on, find your way around, and stop being afraid of the keyboard.
Online from₦40,000$30
OnlineOn-site
Digital foundations
Typing, Internet and Email Skills
Type faster, search smarter and run your inbox like a pro.
Online from₦20,000$15
OnlineOn-site