Learn Google Sheets formulas with a built-in checker
Grounded in available product and source data
Sheets Bootcamp teaches Google Sheets formulas one real problem at a time. Each lesson opens with a short video that shows a single idea on an actual sheet, then asks you to type the formula yourself in a grid that behaves like Google Sheets and checks it as you go.
The catalogue covers lookup functions such as VLOOKUP, INDEX MATCH and XLOOKUP, logic and conditions, the QUERY and FILTER functions, charts, conditional formatting, pivot tables, data validation, text functions and date functions. A course of short lessons runs alongside the guides.