Skillnaija All courses →

Excel, Google Sheets & Business Dashboards

Turn messy shop records into clean dashboards that show profit at a glance.

Start learning free More Data & Tech courses

Free account required to open the lessons. No card, no fees.

About this course

Learn spreadsheets from zero in both Excel and Google Sheets — formulas, cleaning messy data, PivotTables, charts, and a real business dashboard. By the end you can build a daily sales, expenses and profit dashboard a Nigerian shop owner can actually use, and earn money setting them up for traders, salons and small businesses.

A spreadsheet is just a grid of boxes called cells — and once it stops scaring you, it becomes the cheapest accountant you will ever hire. Today you make your very first one, in either Google Sheets or Excel, and learn the words for the boxes.

What you'll learn

Course syllabus — 7 lessons

  1. Your first spreadsheet: Excel and Google Sheets, side by side12 min
  2. Formulas that do the maths for you: SUM, AVERAGE, IF14 min
  3. Looking things up: COUNTIF, SUMIF and VLOOKUP/XLOOKUP15 min
  4. Cleaning messy business data so your numbers can be trusted14 min
  5. Sort, filter and conditional formatting to spot what matters13 min
  6. PivotTables and charts: summarise sales and tell the story15 min
  7. Build the dashboard, track the right KPIs, and share it15 min

Your project

Build and share a working business dashboard

A shareable Google Sheets link (set to Viewer access for anyone with the link) containing the Data, Calcs and Dashboard tabs described above, with the written explanation visible on the Dashboard tab.

Certificates on Skillnaija are earned, not issued for attendance: you submit this project, it is graded against a rubric, and passing issues a certificate anyone can verify.

Frequently asked questions

Is Excel, Google Sheets & Business Dashboards free?

Yes. Excel, Google Sheets & Business Dashboards is completely free on Skillnaija. You need a free account to open the lessons, and there is no charge for the course, the project, or the certificate.

How long does Excel, Google Sheets & Business Dashboards take to complete?

5 weeks · ~4 hrs/week. There are 7 lessons, about 2 hours of material in total. You learn at your own pace and your progress is saved.

Do I need any experience to start Excel, Google Sheets & Business Dashboards?

Beginner-friendly. You can start from scratch — no prior experience is assumed.

What will I learn in Excel, Google Sheets & Business Dashboards?

You will build practical skills in Excel & Google Sheets basics, Core formulas (SUM, IF, VLOOKUP/XLOOKUP), Cleaning messy business data, PivotTables & charts, Building business dashboards, Tracking small-business KPIs, Sharing & light automation. Every lesson is written for a Nigerian context, with examples drawn from how the work is actually done and paid for here.

Do I get a certificate for Excel, Google Sheets & Business Dashboards?

Yes, but it has to be earned. You complete the course project — Build and share a working business dashboard and submit it for grading. Passing the project issues a verifiable certificate; finishing the lessons alone does not.

Related Data & Tech courses

Ready to start Excel, Google Sheets & Business Dashboards?

It's free, it's self-paced, and it ends with something you can show an employer.

Start learning free