Excel 1: Excel for Work
Type, format, total, chart and print a real sheet.
GH₵ 95 paid once, 12 months of access
See how it works
Each lesson has a practice computer beside it. You copy each step, and the course tells you when it is right. This is a real lesson, sped up.
Start from a blank sheet and finish with a working price lookup.
A video course: you watch. A SchoolRegistry short course: you do the task yourself on a practice computer, and the course checks it as you go.
Who it is for
Anyone who needs Excel for a job, a business or a job application.
What you will be able to do
- Total a column and let Excel decide with IF
- Sort and filter a list, then make a clear chart
- Print a sheet on one page, not fourteen
By the end you will build a real spreadsheet that totals, checks and charts your numbers, then print it neatly or turn a PDF into Excel.
How it works
Each lesson starts with a short video. Tolu, your guide, shows you what to do and says it in plain words. You practise on a real-looking Excel, with Tolu guiding each step.
You work on a practice computer inside the course, so you cannot break anything. More than 75% of your time is hands-on practice, not watching.
Every lesson is split into steps, and a row of step bars shows where you are. If a step is too hard, press Skip and come back to it later.
All 16 lessons5 modules. The free lessons are marked.
Module 1: Find your way and type fast
Cells, sheets, typing, AutoFill and Flash Fill.
- 1.1Why Excel pays, and what you're looking atFree, try it: Why Excel pays, and what you're looking at
- 1.2Typing in data
- 1.3Fill faster: AutoFill and Flash Fill
Module 2: Make it look professional
Money, dates, percentages, rows, columns and sheets.
- 2.1Formatting money, dates and percentages
- 2.2Rows, columns and sheets
Module 3: Formulas
SUM, AVERAGE, IF, COUNTIF and SUMIF, and fixing errors.
- 3.1Your first 5 formulasFree, try it: Your first 5 formulas
- 3.2Copying formulas: relative and absolute
- 3.3IF: let Excel decide
- 3.4COUNTIF and SUMIF
- 3.5When formulas go wrong
Module 4: Sort, filter, chart and print
Answers you can show your manager.
- 4.1Sort and filter
- 4.2Charts that make sense
- 4.3Printing without 14 pages of mess
Module 5: Lookups, PDFs and your toolkit
XLOOKUP, PDF to Excel and a final project.
- 5.1VLOOKUP and XLOOKUP in plain EnglishFree, try it: VLOOKUP and XLOOKUP in plain English
- 5.2Turn a PDF into an Excel sheetFree, try it: Turn a PDF into an Excel sheet
- 5.3Your Excel toolkit
What you need
A laptop or desktop computer with a web browser and an internet connection. You practise inside the course, so you do not need to install anything.
Part of the Excel series
Excel 1 to Excel 4. Start at step 1, or jump ahead if you already know the basics.
- Excel 1: Excel for WorkBeginner, 4 hours
- Excel 2: Bigger lists and lookupsIntermediate, 5 hours
- Excel 3: Reports and dashboardsAdvanced, 6 hours
- Excel 4: Automate the boring partsExpert, 6 hours
Questions people ask
Who is Excel 1 for?
Anyone who needs Excel for a job, a business or a job application. It is step 1 of 4 in the Excel series.
Can I try it before I pay?
Yes. 4 lessons are free, starting with Lesson 1, "Why Excel pays, and what you're looking at". You do not need to pay to start.
How long does it take?
There are 16 lessons and about 4 hours of learning. You go at your own pace, and you have 12 months of access.
What do I need?
A laptop or desktop computer with a web browser and an internet connection. You practise inside the course, so you do not need to install anything.
How much does it cost?
GH₵ 95, paid once. That opens every lesson for 12 months.