Zafari Academy

Data Analysis for Excel and Google Sheets

Work as the analyst for a wholesaler. Answer real business questions with formulas, pivot summaries and charts, and pass a timed skills test.

  • Free
  • About 11 hours
  • 62 lessons
  • Beginner

249 practice questions · 2 timed tests · a score for each skill area

You’ll learn to
  • Write formulas that stay right when they are copied: relative and absolute references, totals, averages and percentages
  • Make decisions in a sheet with IF, AND, OR and IFERROR
  • Clean a messy list: stray spaces, mixed capitals, numbers stored as text, blanks and duplicates
  • Bring two tables together with XLOOKUP, VLOOKUP and INDEX with MATCH
  • Total and count by any rule with SUMIFS, COUNTIFS and AVERAGEIFS, and check them with a pivot summary
  • Choose the right chart for the question and report the answer in one honest sentence
About

Free, about 11 hours, all in your browser, even on a phone. You join Pellingham Provisions, a wholesaler that supplies cafés, as their analyst. The owner and the team send you questions. You answer them with formulas on real-looking, messy data: totals you can trust, clean lists, lookups, conditional totals, pivot summaries and charts. Every part has a lab that checks your work as you go. You finish with a timed skills test on data you have never seen, and a certificate. The skills work in Microsoft Excel and Google Sheets.

Contents
  1. Chapter 1 · Getting started: your first week at PellinghamMeet Pellingham Provisions and the team, write a first formula in under 10 minutes, and see where you start.
  2. Your first sheet4 lessons · 1 optionalFree
    • Welcome to PellinghamReading
    • Your first formula, one step at a timeReading
    • How the lab worksReading
    • First look at the ordersSpreadsheet
    • Where you startShort assessment
  3. Chapter 2 · Chapter 1: Formulas you can trustAnswer Ines's first questions with formulas that stay right when the data changes or the formula is copied.
  4. Totals that update themselves6 lessons · 1 optional
    • How did January go?Reading
    • Build it one step at a timeReading
    • Traps, and how to checkReading
    • January's order linesSpreadsheet
    • Key termsFlashcards
    • AssessmentShort assessment
    • Key pointsReading
  5. Rates, shares and the $ sign6 lessons · 1 optional
    • What do we keep from each product?Reading
    • Build it one step at a timeReading
    • Traps, and how to checkReading
    • Margins on the price listSpreadsheet
    • Key termsFlashcards
    • AssessmentShort assessment
    • Key pointsReading
  6. Decisions with IF6 lessons · 1 optional
    • Which orders get free delivery?Reading
    • Build it one step at a timeReading
    • Traps, and how to checkReading
    • Flag the big ordersSpreadsheet
    • Key termsFlashcards
    • AssessmentShort assessment
    • Key pointsReading
  7. Chapter 3 · Chapter 2: Clean and connect the dataTurn Mei's messy lists into clean ones, and bring products, customers and orders together in one sheet.
  8. Cleaning a messy list6 lessons · 1 optional
    • Mei's messy customer listReading
    • Clean a list, one step at a timeReading
    • Cleaning traps, and how to checkReading
    • Clean the customer listSpreadsheet
    • Key termsFlashcards
    • AssessmentShort assessment
    • Key pointsReading
  9. Lookups: one table into another6 lessons · 1 optional
    • Ravi's April linesReading
    • Build a lookup, one step at a timeReading
    • Lookup traps, and how to checkReading
    • Bring in the product detailsSpreadsheet
    • Key termsFlashcards
    • AssessmentShort assessment
    • Key pointsReading
  10. Codes, dates and months6 lessons · 1 optional
    • June's import won't add upReading
    • Fix the import, one step at a timeReading
    • Dates, codes and checksReading
    • Fix June's importSpreadsheet
    • Key termsFlashcards
    • AssessmentShort assessment
    • Key pointsReading
  11. Chapter 4 · Chapter 3: Summarise and tell the storyBuild the half-year report Ines asked for: totals by any rule, a pivot summary that checks them, and charts that make the answer plain.
  12. Totals by any rule6 lessons · 1 optional
    • Who sells what?Reading
    • Build the rep summary, step by stepReading
    • Traps, and how to checkReading
    • Sales by rep and categorySpreadsheet
    • Key termsFlashcards
    • AssessmentShort assessment
    • Key pointsReading
  13. Pivot summaries6 lessons · 1 optional
    • Half a year on one screenReading
    • Build the summary, step by stepReading
    • Traps, and how to checkReading
    • Summarise the half yearSpreadsheet
    • Key termsFlashcards
    • AssessmentShort assessment
    • Key pointsReading
  14. Charts and the one-page report6 lessons · 1 optional
    • One page for the bankReading
    • Build the dashboard, step by stepReading
    • Report it honestlyReading
    • Ines's half-year dashboardDashboard
    • Key termsFlashcards
    • AssessmentShort assessment
    • Key pointsReading
  15. Chapter 5 · Show what you can doPractise on a bike workshop's data if you like, then pass a timed skills test on a garden centre's data you have never seen.
  16. Practice testOptional
    • The practice testReading
    • Practice test: Kelvessa's jobsSpreadsheet
    • Practice skills testPractice exam
  17. Skills test4 lessons
    • Before you startReading
    • Skills test: Orrinvale's salesSpreadsheet
    • Skills testPractice exam
    • Your certificate, and what nextReading