Sheets AcademySheets Academy
Premium

Interactive course in Excel

A course for complete beginners. Step by step, we'll cover formulas, cell references, functions, VLOOKUP and PivotTables, and practice every topic with tasks right in your browser. Everything you learn works in both Excel and Google Sheets.

Module 1

First steps

Cells and addresses, editing and freezing rows, sorting and filtering, numbers, text, dates and formats.

Module 1
How the course works
How a table works
Copy, paste, freeze
Sort and filter
Numbers, text and dates
Format is not the value
Module 2

Formulas

The table does the math: formulas, filling down, the $ sign, your first functions, percentages and rounding.

Module 2
Your first formula
References instead of numbers
Filling a formula down
Locking a cell: $ and F4
Functions: SUM, AVERAGE, MIN, MAX, COUNT
Percentages and rounding
Module 3

Conditions

The table makes the choice: IF with two or more outcomes, sums and counts by condition, highlighting what matters.

Module 3
Comparisons: TRUE and FALSE
IF: choosing a result
Two conditions: AND and OR
Several outcomes: IF inside IF
COUNTIF and SUMIF
Several conditions: SUMIFS
Conditional highlighting
Module 4

Data cleanup and VLOOKUP

Clean up exports, pull out part of a text, calculate with dates and bring in data from a lookup table with VLOOKUP.

Module 4
Cleaning up text
Part of a text: LEFT, MID, FIND
Dates are numbers
Dates in reports: YEAR, MONTH, DATEDIF
VLOOKUP: data from another table
Why VLOOKUP returns #N/A
Module 5

PivotTables and charts

Short reports from long tables without formulas, grouping by month and charts from reports.

Module 5
Your first PivotTable
Sum, count, average, share
Two fields in a report
Filters and grouping by month
Which chart to choose
A chart from a PivotTable
Course finish

Certificate for 30 Trainer tasks

After the lessons, sharpen your skills in the Trainer: solve 30 tasks and earn a personalized certificate.

Go to the Trainer