Excel Essentials for Business

Go from blank sheet to clean, formula-driven reports you can trust.

Beginner 45 min English
AMTaught by Ama Mensah

What you'll learn

  • Structure data so it is easy to analyse
  • Write SUM, AVERAGE, IF and COUNTIF formulas with confidence
  • Use absolute and relative references correctly
  • Look up values with XLOOKUP
  • Summarise sales data with PivotTables
8lessons
1interactive activity
1quiz
Yescertificate

Course content

3 sections · 8 lessons · 45 min
Getting started 4 lessons · 18 min
Preview 3 min
Rows, columns and tidy data 6 min
Cell references explained 7 min
Interactive check: spreadsheet basics Interactive 2 min
Formulas that do the work 3 lessons · 22 min
SUM, AVERAGE and friends 8 min
Looking things up with XLOOKUP 8 min
Quiz: formulas Quiz 6 min
Summarising data 1 lessons · 5 min
PivotTables in five minutes 5 min

Before you start

  • A computer with Excel 2019, Microsoft 365 or Google Sheets
  • No prior spreadsheet experience needed

About this course

Spreadsheets run small businesses, NGOs and finance teams across Ghana. This course teaches the Excel skills you will actually use at work: tidy data, reliable formulas, lookups and quick summaries.

Every section mixes short lessons with hands-on checks, so you practise as you go.

Your instructor

AM

Ama Mensah

Demo instructor · Business analyst and trainer

This is a demo instructor profile created by the installer. Edit or delete it in Admin → Users.

Learner reviews

No reviews yet. Learners who enrol can leave the first one.

Frequently asked

How do I pay for a course?

Pay securely with MTN MoMo, Telecel Cash, AT Money, Visa or Mastercard through Hubtel. You get access straight after payment.

How long do I have access?

For life. Once you enrol, the course stays in your account and you can learn at your own pace, including any updates we make.

Do I get a certificate?

Yes. Finish every lesson in a course and a certificate is issued automatically. Each one has a QR code and a public link employers can use to check it.

Can I learn on my phone?

Yes. Everything works on a phone, tablet or computer, and your progress follows you between devices.

Free
Enrol for free