ExplorePricingSupport
Sign inGet started
FreeSpreadsheetsProductivity

Excel and Google Sheets essentials

Format data, write formulas, look things up, and turn a table into pivots and charts in Excel or Google Sheets.

4 modules · 12 lessons · about 3 hours · Beginner

Start freeNo card needed

What you'll be able to do

Use spreadsheets confidently for everyday work.

  • Cells, ranges, data types and formatting that makes a sheet readable.
  • Write formulas, copy them safely with $ references, and fix errors.
  • Summaries, decisions with IF and SUMIF, and lookups across tables.
  • Sort, filter, pivot and chart a table to answer real questions.

Course outline

  1. 1Getting around a spreadsheet

    • Cells, rows and columns
    • Entering and formatting data
    • Making sheets easy to read
  2. 2Formulas and references

    • Your first formulas
    • Relative and absolute references
    • Reading and fixing formula errors
  3. 3Functions you'll use every day

    • Everyday functions
    • Decisions with IF, COUNTIF and SUMIF
    • Lookups with XLOOKUP and VLOOKUP
  4. 4Making sense of your data

    • Sorting and filtering
    • Pivot tables
    • Charts that make the point

How you'll learn

  • Short lessons that build on each other, so every step makes sense.
  • A tutor you can ask anytime. It knows the lesson you're on.
  • Quick checks along the way, so you know it stuck.

Questions

Is Excel and Google Sheets essentials really free?

Yes. Make a free account and start right away. No card needed, and nothing to cancel later.

Do I need any experience?

No. It starts from zero and explains each new idea as it comes up.

How long does it take?

12 lessons in all, about about 3 hours in total. Go at your own pace: your progress is saved.

What if I get stuck?

Ask the tutor. It knows the lesson you're on and explains things another way until it clicks.

Can I learn on my phone?

Yes. Lernelle works in any browser, on your phone, tablet or computer.

Does it stay up to date?

Yes. We update the course when things change, and you can bring the new version into yours with one click.

Ready to start?

It takes a minute to sign up, and the first lesson is waiting.

Start freeNo card needed

Learn anything, one step at a time, with a tutor by your side.

Product

  • Free tracks
  • Pricing
  • Create an account

Made for

  • Learning for work
  • Languages

Help

  • Support
  • Contact us

Legal

  • Terms of service
  • Privacy policy

© 2026 Lernelle. All rights reserved.