Start Learning
Beginner 5 lessons

Working with Data in Excel

A second beginner path — sorting, filtering, charts, and a few more essential functions.

Your Progress 0 of 5 complete
  1. 1 Sorting and Filtering Data
    Put your data in order, and hide the rows you don't need to see right now.     Beginner 7 min
  2. 2 Understanding Cell References: Relative vs. Absolute
    Why copying a formula sometimes breaks it — and how a dollar sign fixes that.     Beginner 8 min
  3. 3 Creating Your First Chart
    Turn a table of numbers into a chart that's actually easy to read at a glance.     Beginner 8 min
  4. 4 The COUNT and COUNTA Functions
    Count how many cells actually have something in them — numbers, or anything at all.     Beginner 6 min
  5. 5 Freezing Panes and Printing Your Worksheet
    Keep your headers visible while you scroll, and get a printed page that actually looks right.     Beginner 5 min