Demo data resets every hour — next reset in 38 min.

English

Course

Spreadsheets for Everyday Productivity

Build tidy tables, use the ten formulas you will actually need and turn raw lists into summaries you can share, in Excel, Google Sheets or LibreOffice Calc.

Instructor
Lena Fischer
Lessons
7
Level
Beginner
Price
$29.00 · was $39.00

Spreadsheets save hours when the data is laid out well, and cost hours when it is not. This course starts with structure, then adds the formulas and summaries that come up in everyday office work.

What you will learn

  • How to lay out a table so formulas and filters keep working
  • Ten formulas: SUM, AVERAGE, COUNTIF, SUMIF, IF, XLOOKUP and more
  • How to turn a long list into a one-page summary
  • How to check your numbers before you send them

Software

Every example works in Microsoft Excel, Google Sheets and LibreOffice Calc. Where the menus differ, the lesson shows both.

Course content

Tables that stay tidy3 lessons
  1. Course tour — Video2 minPreview
  2. Structure your data before you calculate — Text9 minLocked
  3. Ten formulas for daily work — Text12 minLocked
Formulas and summaries4 lessons
  1. Formula reference card (PDF) — File3 minLocked
  2. Practice: match the formula to the task — Interactive page5 minLocked
  3. Self-check: table structure — Quiz5 minLocked
  4. Final test — Quiz8 minLocked