Cell Reference
Sign inStart free

Simulated Spreadsheet Right in Your Browser

Build confidence in Excel

Practice the exact clicks you'll make at work.

No credit card required

A lesson: the steps to follow on the left, next to Excel

What you'll learn

The Excel skills most office workers need, in about 5 hours

  1. Free

    1. The Excel interface

    Find your way around the window, cells, and sheets

    • The Excel window
    • Selection
    • Worksheets

  2. 2. Data entry and editing

    Type, change, and copy data without retyping it

    • Entering data
    • Copy and paste
    • Rows and columns

  3. 3. Formatting

    Make numbers, text, and columns easy to read

    • Number formats
    • Fonts, text, and colors
    • Alignment
    • Column and row size

  4. 4. Formulas and functions

    Calculate totals, averages, and simple decisions

    • Formulas
    • Basic functions
    • Logical functions
    • Formula errors

  5. 5. Cell references

    Reuse formulas without breaking them

    • Formula reuse
    • Absolute references
    • References to other sheets

  6. 6. Filtering and sorting

    Find the rows you need in a big sheet

    • Filtering
    • Sorting
    • Duplicates

  7. 7. Lookup functions

    Pull matching values from another table

    • VLOOKUP
    • Lookup errors
    • Lookups across sheets

  8. 8. Pivot tables and charts

    Summarize a table and chart the results

    • Building a pivot table
    • Working with a pivot table
    • Charts

Pricing

Start for free, and pay only if you want the rest.

  • Preview

    $0No credit card required

    • All 8 lessons in Chapter 1
    • Nothing to install
    Start for free

  • Full access

    $129One year of access, paid once

    • All 48 lessons
    • Every Learn and Practice part
    • No subscription
    Buy

Questions

Start your free lessons today

Short, hands-on lessons, step by step. No credit card needed.