Section · 1 guide

Spreadsheets

Excel and Google Sheets for people who live in them, from the first lookup to the monthly report.

  1. A shallow tray of loose blank beige keycaps sorted into neat rows on a pale desk, one red-orange keycap among them in sharp focus, the rest softly out of focus
    Spreadsheets

    XLOOKUP vs VLOOKUP: which to use in Excel and Sheets

    When to use XLOOKUP and when VLOOKUP is still the right one, in Excel and Google Sheets, with a VLOOKUP rewritten step by step and the keys to build it.

    By 8 min read

In plenty of office jobs the spreadsheet is the job: lists to clean, numbers to look up, a report due every month. This section covers Excel and Google Sheets side by side, from formulas and lookups to pivot tables, charts and the scripts behind them, with the keyboard routes through each.

Most people start at the first lookup. XLOOKUP vs VLOOKUP says when each is the right one in Excel and Google Sheets, and rewrites a VLOOKUP step by step.

Inside Formulas and functions, XLOOKUP and VLOOKUP, Pivot tables, Charts, Cleaning and formatting data, Conditional formatting, Templates, Excel versus Google Sheets, Macros and Apps Script, AI in spreadsheets, Spreadsheet courses

Newest in other sections

  1. Automation

    By 11 min read

  2. Desk Setup

    By 10 min read

  3. Shortcuts

    By 10 min read