SkillPath Africa
Beginner → Professional

Excel & Spreadsheets for Work

Build real, job-ready spreadsheet skills in Excel and Google Sheets, from the basics through formulas, functions, and pivot tables. By the end you'll be able to organize, calculate, and summarize data confidently for everyday office and remote-work tasks.

17 lessons · 4 levelsKSh 500

Every lesson comes with written notes, a practice task and a knowledge check.

Watch the first lesson free

Excel for Beginners - The Complete Course — A former Microsoft product manager walks complete beginners through the Excel interface, entering data, and basic formatting from scratch.

Create a free account to watch it. No payment needed.

On a limited data plan? Tap the gear icon (⚙️) in the video player and choose 480p or lower — standard-definition video uses a fraction of the data HD does and still looks fine on a phone.

Level 1 — Foundations

Start from zero: what this skill is, the tools you need, and your first hands-on practice.

Module 1 — Excel & Google Sheets Fundamentals

  • Lesson 1 — Excel for Beginners - The Complete Course· 55 min· ~395 MB

    A former Microsoft product manager walks complete beginners through the Excel interface, entering data, and basic formatting from scratch.

    • Name the parts of a spreadsheet and what each is for
    • Enter data so that it can be calculated on later
    • Decide whether to work in Excel or in Sheets
  • Lesson 2 — Google Sheets: Getting Started· 3 min· ~18 MB

    Covers the Google Sheets interface and cell basics for anyone new to spreadsheets.

    • Work confidently in Sheets and share a file safely
    • Set up a file so it survives no internet and a lost phone
    • Choose the right sharing permission for each person

Module 2 — Formulas and Functions in Action

  • Lesson 1 — Excel: Intro to Formulas· 4 min· ~26 MB

    A clear, beginner-friendly walkthrough of how formulas work in Excel, the foundation for every calculation skill after this.

    • Write a formula that refers to cells rather than to typed numbers
    • Predict the order in which a calculation happens
    • Fix a formula by reading what it is actually pointing at
  • Lesson 2 — Excel: Functions· 5 min· ~38 MB

    Builds on formulas by introducing built-in functions like SUM and AVERAGE, key tools for everyday spreadsheet work.

    • Use the dozen functions that cover most real work
    • Choose the right function for a counting or summing question
    • Handle errors so a sheet stays readable

Module 3 — Organising Data So It Works

  • Lesson 1 — Turning a List into a Real Table· 3 min· ~24 MB

    A short, focused look at Excel's Table feature — what it does to a plain range and why it is worth converting. Just over 3 minutes.

    • Lay out data as one record per row and one field per column
    • Convert a plain range into a proper Excel Table
    • Recognise why merged cells and blank spacer rows break sorting and formulas
  • Lesson 2 — Sorting Without Scrambling Your Data· 5 min· ~33 MB

    How sorting actually works on a range, including sorting by more than one column. About 4 and a half minutes.

    • Sort a table by one column and by several columns at once
    • Avoid the sort that reorders one column and leaves the rest behind
    • Explain why sorting never changes the data itself
  • Lesson 3 — Filtering to See Only What Matters· 11 min· ~78 MB

    Using filters to narrow a large sheet down to the rows you actually care about, without deleting anything. About 11 minutes.

    • Filter a table to just the rows that matter
    • Use number and date filters beyond simple tick-boxes
    • Recognise when a filter is active, and why leaving one on is risky

Module 4 — References, and Why Formulas Break

  • Lesson 1 — Absolute and Relative References — the $ Anchor· 8 min· ~56 MB

    What changes and what stays put when you copy a formula, and how the dollar sign controls it. Under 8 minutes, and the single highest-value 8 minutes in this course.

    • Predict how a reference changes when a formula is copied
    • Use $ to lock a column, a row, or both
    • Choose the right reference type for a calculation against a fixed value
  • Lesson 2 — Reading and Fixing Error Values· 7 min· ~54 MB

    What Excel's error codes actually mean and how to trace each one back to its cause. About 7 and a half minutes.

    • Recognise what each common Excel error is telling you
    • Trace an error back to the cell that caused it
    • Fix the cause rather than hiding the symptom

Level 2 — Intermediate Skills

Move past the basics into the techniques that separate a beginner from someone genuinely useful.

Module 5 — Intermediate Excel Skills

  • Lesson 1 — How to Use VLOOKUP and XLOOKUP in Excel· 8 min· ~55 MB

    A step-by-step walkthrough of pulling matching data from large datasets using VLOOKUP and XLOOKUP.

    • Pull matching information from one table into another
    • Diagnose the four reasons a lookup returns nothing
    • Choose between the older and newer lookup functions
  • Lesson 2 — Excel Conditional Formatting Tutorial (Beginner to Pro)· 23 min· ~167 MB

    Teaches how to visually highlight and flag data automatically using conditional formatting rules.

    • Make a sheet show its own problems without being read closely
    • Write a rule based on a formula rather than a preset
    • Keep formatting useful instead of decorative

Level 3 — Professional Practice

Work the way professionals do, then apply everything to a complete real-world project.

Module 6 — Pivot Tables, Tips, and Working Like a Pro

  • Lesson 1 — Pivot Table Excel Tutorial· 14 min· ~98 MB

    A step-by-step beginner's guide to building your first pivot table to summarize and analyze data quickly.

    • Summarise a long list into an answer in under a minute
    • Prepare data so a pivot table will work at all
    • Read a pivot table critically rather than trusting it
  • Lesson 2 — Excel Tips and Tricks· 20 min· ~141 MB

    A roundup of practical shortcuts and habits that make everyday spreadsheet work faster, useful once the basics are in place.

    • Adopt the few shortcuts that genuinely save time
    • Judge a tips list rather than trying to memorise it
    • Build habits that stop mistakes instead of fixing them

Module 7 — Building a Real Spreadsheet Project

  • Lesson 1 — Build the Ultimate Budget Tracker in Excel From Scratch· 1h 31m· ~653 MB

    A full build-along creating a working budget tracker spreadsheet from nothing.

    • Build a working tracker from a blank sheet
    • Separate entry, calculation and presentation
    • Design something you will actually keep using
  • Lesson 2 — Make a Professional Excel Dashboard From Real-World Data· 21 min· ~155 MB

    Builds a business-style interactive dashboard from raw data, using pivot tables and charts.

    • Build a dashboard in the order that prevents rework
    • Choose a chart because of the question it answers
    • Make one screen that answers what the reader came to ask

Level 4 — Freelance & Career

Turn the skill into income: finding clients, pricing your work, and building a career around it.

Module 8 — Excel Skills for Freelance & Remote Work

  • Lesson 1 — How I Made $100K as an Excel Freelancer· 16 min· ~112 MB

    Real-world lessons on turning Excel skills into paid freelance data/bookkeeping work.

    • Read an income claim critically
    • Identify the spreadsheet work that genuinely pays here
    • Win the first paid job without a portfolio
  • Lesson 2 — How to Create Professional Looking Excel Spreadsheets· 7 min· ~48 MB

    Shows formatting and layout techniques that make a spreadsheet look polished and client-ready.

    • Format a sheet so it is read rather than deciphered
    • Apply a consistent standard to every file you hand over
    • Prepare a file for someone else to maintain

Spin for a discount

One spin, one discount on this Learning Path.

10% OFF10% OFF10% OFF10% OFF10% OFF10% OFF10% OFF10% OFF
Get Full Access — KSh 500

Reviews

No reviews yet.