Zafari Academy
Data Analysis for Excel and Google Sheets

Free first lesson · Zafari Academy

  • Free
  • About 11 hours
  • 62 lessons
Join free
Step 1 of 5

Your first sheet

Step 1 · Read · 3 min

Welcome to Pellingham

Your new job

You have just joined Pellingham Provisions as its analyst. Pellingham is a wholesaler: it sells coffee, tea, syrups, milk, bakery and packaging to 20 cafés.

Ines Halloran owns the business. Her message on your first morning: "I can see every order. I can't see what they add up to."

The team

  • Ines, the owner, asks the big questions.
  • Mei Osei runs orders and stock, and the lists that come with them.
  • Ravi, Joy and Sam are the sales reps. Each café has one.

What this course gives you

  • Short lessons, each ending in a lab: a real sheet, with tasks that tick as your formulas start to work.
  • Three chapters: formulas you can trust, clean and connected data, and summaries and charts.
  • A timed skills test on data you have never seen, and a certificate.

Where it works

What you learn works in Microsoft Excel and in Google Sheets. The labs run in our own spreadsheet, here in your browser, so you need nothing else. A phone is enough.

The last step of this part, "Where you start", is 15 questions that show what you know already. It is optional and does not count.

Carry on with Data Analysis for Excel and Google Sheets

Your progress and certificate are kept.