Learn how to use VLOOKUP and XLOOKUP in Excel with simple examples, when to choose each one, and how to fix #N/A, #REF! and #NAME? errors.

Learn how to create a pivot table in Excel step by step: prepare your data, summarize totals, group dates, add slicers and fix common errors.