Skillnaija Start free

DATA & TECH

Excel, Google Sheets & Business Dashboards

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

  • 7 lessons
  • ~2 hours
  • Beginner-friendly
  • Project + certificate

Free account required to open the lessons. Any price is shown before you pay.

What you'll learn

  • 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

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.

Who it's for

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

The lessons 7 lessons, ending in a graded project

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

THE PROJECT AND YOUR CERTIFICATE

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, an examiner grades the real work against a published rubric (you need 65% to pass), and passing issues a certificate anyone can verify. If you don't pass yet, you get written feedback and can try again.

  • Clean, well-structured data: separate tabs, clear headers, real numbers, consistent DD/MM/YYYY dates, dropdown validation and no duplicates20%
  • Correct use of formulas and at least one working PivotTable (SUM/SUMIF, profit and profit-margin calculations that compute correctly)25%
  • A clear, decision-ready dashboard: headline KPIs, conditional formatting for negatives, a working low-stock flag, and at least two well-titled charts30%
  • Sharing set correctly so the link opens as Viewer, and the sheet is genuinely usable by a shop owner15%
  • A clear written explanation with one real insight and one concrete, actionable recommendation10%

See the full project brief, rubric and free workbook →

Frequently asked questions

Is Excel, Google Sheets & Business Dashboards free?

Most Skillnaija courses can be started free with a free account: your first two courses are free to start, then one new course each month. Some courses are paid; the course page in the app shows whether Excel, Google Sheets & Business Dashboards is one, and its price, before you pay. You can also buy any course on its own for twelve months, or open every course with the All-Access Pass. Certificates are never sold: you earn one by passing the course's project.

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 in plain English, with examples drawn from how the work is actually done and paid for, in Nigeria and beyond.

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.

Ready to start Excel, Google Sheets & Business Dashboards?

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

Start learning free