Stop fighting spreadsheets. Learn to move around at speed, write formulas with confidence, look anything up with XLOOKUP, clean messy data in seconds, and summarise thousands of rows with PivotTables and charts — plus the keyboard shortcuts professionals use every day.
7
units
22
lessons
83
challenges
~70
minutes
Start learning today
Create a free account, then unlock this and every other Pro course with Learnix Pro for KES 1,200/month.
2 minutes · no sign-up needed
Outcomes
Navigate and select data with keyboard shortcuts instead of the mouse
Write formulas with SUM, AVERAGE, COUNT, IF and more — and fix their errors
Use absolute references ($A$1) and copy formulas correctly
Look up values with XLOOKUP and VLOOKUP
Summarise data with SUMIFS, COUNTIFS and PivotTables
Clean messy data with Flash Fill, TRIM, Remove Duplicates and Text to Columns
Build Tables, filters, dropdowns, conditional formatting and charts
Work faster with Paste Special, Go To Special and AI assistants
How it works
Every lesson mixes short explanations with hands-on challenges. Get instant feedback, fix mistakes on the spot, and build a daily habit that actually sticks.
Concept cards
Short, clear explanations with real examples
52 in this course
Multiple choice
Pick the right answer, get instant feedback
33 in this course
Fill the blank
Complete formulas, commands and shortcuts
19 in this course
Build it
Arrange tiles into the right sequence
8 in this course
Match pairs
Connect shortcuts, terms and meanings
23 in this course
Daily streaks
Keep the flame alive by learning every day
XP & daily goals
Pick a goal from 10 to 50 XP a day
Hearts
Five per lesson; missed questions come back
Leaderboard
Climb the weekly rankings
Syllabus
Workbooks, sheets & cells
The building blocks of every spreadsheet.
Move like a pro
Jump across thousands of rows in a keystroke.
Fast data entry tricks
Fill, repeat and auto-complete like an expert.
Your first formulas
Every formula starts with =.
Essential functions
SUM, AVERAGE, MIN, MAX, COUNT and COUNTA.
Absolute references & F4
Why copied formulas break — and the $ that fixes them.
Understanding errors
What #DIV/0!, #N/A, #NAME? and friends are telling you.
Decisions with IF
Let a formula choose between two answers.
SUMIFS & COUNTIFS
Totals and counts that only include what you ask for.
XLOOKUP & VLOOKUP
Find a value in one table and bring back matching data.
Flash Fill & text functions
Split, join and tidy text in seconds.
Number formats & Format Cells
Currency, percentages, dates — and Ctrl + 1.
Duplicates, splitting & highlighting
Remove Duplicates, Text to Columns and conditional formatting.
Excel Tables: Ctrl + T
Turn a range into a smart, self-expanding table.
Sort, filter & freeze panes
Find what matters in big lists.
FILTER, SORT & UNIQUE
Modern formulas that return whole lists.
PivotTables in 60 seconds
Drag, drop, done.
Slicers, grouping & percentages
Make PivotTables interactive and insightful.
Charts that tell the story
Pick the right chart and build it fast.
Paste Special & Go To Special
Hidden tools that save hours.
Protect, share & print
Stop accidental changes and print cleanly.
AI helpers & Power Query
Copilot, AI chat assistants and automated clean-up.
Complete every lesson to receive a Learnix certificate with a unique number anyone can verify online.
Helping with:
AI tutor