VLOOKUP vs XLOOKUP: Which One to Use and How to Get the Most from Them
The differences between VLOOKUP and XLOOKUP in Excel, practical examples of each, common mistakes and when INDEX and MATCH is the better choice.
Excel Guides
Functions, PivotTables, shortcuts and Excel tips.
Excel PivotTables for Beginners: A Practical Guide
Learn to build your first PivotTable in Excel, summarize sales by month or customer, filter results and avoid the most common source data mistakes.
Conditional Formatting in Excel to Spot Changes and Errors
Use Excel’s conditional formatting to automatically highlight duplicates, out-of-range values, blank cells and differences between two lists.
Data Validation in Excel: How to Prevent Data Entry Errors
Set up drop-down lists, number limits, valid dates and help messages with Excel’s data validation so your sheets receive correct data from the start.
20 Excel Keyboard Shortcuts That Will Save You Hours
The most useful Excel keyboard shortcuts for moving around, selecting, editing, formatting and working with data without touching the mouse, plus tips to memorize them.