Back to catalog
SpreadsheetsBeginner

Excel for Work: From Cells to Pivot Tables

Formulas, lookups, dates and pivots — plus the traps that quietly corrupt your data

Excel for Work: From Cells to Pivot Tables

About this course

A working course for people who already open Excel every day and want to stop guessing. Eleven lessons cover how a workbook stores data, why a 12-digit SKU turns into 1.23457E+11, why a date shows up as 45231, and how to write formulas that survive being copied, sorted and handed to someone else.

You will build lookups with VLOOKUP, INDEX+MATCH and XLOOKUP and learn which one to reach for; clean imported text; do arithmetic on dates and time; turn a range into a table; summarise it with a pivot; and read every error Excel throws at you instead of hiding it behind IFERROR.

Function names are given for both the English and the Russian interface, because in real offices you meet both.

Course curriculum

  1. How a workbook actually stores your data

    Sheets and addresses, the three storage types behind every cell, and the $ sign that decides what happens when you drag a formula down.

    • 1.Workbook, sheets, cells and ranges9 min
    • 2.Text, numbers and dates: why Excel ruins your data15 min
    • 3.Relative and absolute references, and what $ really does12 min

  2. Formulas, logic and errors

    Calculation order, the functions people confuse, conditions with IF and AND, conditional totals with SUMIFS, and how to read the error text instead of hiding it.

    • 1.Basic formulas and the order of calculation12 min
    • 2.Conditions: IF, AND, OR and conditional totals18 min
    • 3.Reading errors instead of hiding them12 min

  3. Finding and shaping data

    Pulling values from another table without being lied to, cleaning imported text, and doing arithmetic on dates and time.

    • 1.Lookups: VLOOKUP, INDEX+MATCH and XLOOKUP20 min
    • 2.Text: cleaning, cutting and joining15 min
    • 3.Dates and time you can actually calculate with14 min

  4. Analysis and presentation

    Tables, sorting and filters, a pivot in three minutes, conditional formatting that means something, and picking a chart that does not lie.

    • 1.Tables, sorting, filters and pivot tables18 min
    • 2.Conditional formatting and charts that do not lie14 min