Skip to main content
Iroko Skills Academy
Menu

Data & Analytics

Spreadsheets to Insights

Turn spreadsheets into a real analysis tool: cells, formulas and references, the essential functions, organizing data for analysis, summarizing with pivot tables, and turning results into honest, decision-useful insight. Beginner-friendly, ending with an analyze-a-dataset capstone.

BEGINNER · en · ~240 min

Instructor: Self-paced · Reviewed by: Iroko Skills Academy team · Published by: Iroko Skills Academy team

Learning objectives

  • Use cells, references, and essential functions (SUM, AVERAGE, COUNT, IF, lookups)
  • Organize messy data into analysis-ready form and use sort/filter
  • Summarize large tables with pivot tables
  • Turn analysis into an honest, decision-useful insight with caveats

Before you start

Prerequisites: None

Device/connectivity: Laptop or desktop computer with a modern web browser and keyboard, Internet access for lessons, tools, and assignment submission

Sign in to enroll

What you'll cover

  1. Spreadsheet Foundations

    • The spreadsheet as a thinking tool
    • Formulas and functions that do the work

  2. Organizing and Summarizing

    • Organizing data so it can be analyzed
    • Summarizing with pivot tables

  3. Insight

    • From numbers to a decision
    • Capstone: analyze a dataset and report an insight

Assessment and completion criteria

Complete every published lesson to earn a completion badge. A self-paced certificate also requires passing every server-graded quiz. Practical assignments provide project feedback and may support a separate verified-proficiency record, but they do not delay the standard course certificate.

  • Optional reviewed project: Analyze a dataset and report an insight · rubric v1 · pass ≥ 70%