Free guides
Clear, step-by-step answers to the questions people search for most, with the exact keys and clicks.
Excel
VLOOKUP in Excel: a simple guide with examples
How to use VLOOKUP in Excel step by step: the formula, a worked example, the 4 most common errors and when to use XLOOKUP instead.
Read the guideExcelHow to make a pivot table in Excel (beginner guide)
Make your first pivot table in Excel in 5 steps: prepare the data, insert the pivot table, drag the fields, change Sum to Count and refresh it.
Read the guideExcel20 Excel keyboard shortcuts every beginner should know
The 20 Excel shortcuts that save the most time for beginners: moving around, selecting, formatting, formulas and tables. Windows keys, with Mac notes.
Read the guide