Excel for Work (Beginner)

Build practical spreadsheet reasoning, formulas, and data-handling skills.

Start Free Practice

Learning path

Chapters

  • Beginner

    Spreadsheet Foundations

    Navigate workbooks, recognize cell identity, and choose sound spreadsheet structures.

  • Beginner

    Data Entry & Formatting

    Enter consistent values and use formatting to communicate meaning without changing data.

  • Beginner

    Spreadsheet Formulas

    Build formulas with references, operators, comparisons, and reliable calculation order.

  • Beginner

    Cell References

    Reason about relative, absolute, and mixed references when formulas move or copy.

  • Beginner

    Core Functions

    Summarize numeric ranges with SUM, AVERAGE, MIN, MAX, and COUNT.

  • Beginner

    Logical & Conditional Functions

    Translate workplace rules into IF, AND, OR, COUNTIF, and SUMIF formulas.

  • Beginner

    Sorting, Filtering & Tables

    Organize tabular data without breaking row integrity or hiding important context.

  • Beginner

    Text Functions & Data Cleaning

    Standardize messy text with deliberate cleanup and validation steps.

  • Beginner

    Date & Time

    Work with true date values, elapsed time, and date-sensitive calculations.

  • Beginner

    Lookup & Reference Functions

    Retrieve exact values from structured reference tables and validate lookup assumptions.

  • Beginner

    Charts & Visualization

    Choose clear charts, honest scales, and labels that support the decision at hand.

  • Beginner

    Pivot Tables & Summaries

    Turn transaction-level records into useful grouped summaries and cross-check totals.

  • Beginner

    Workplace Spreadsheet Tasks

    Combine formulas, checks, and clear structure to complete realistic workplace tasks.