Backing Up Excel Files: How to Never Lose Your Work Again
Set up AutoRecover, use version history and apply the 3-2-1 rule so your important spreadsheets are always safe.
5 min read
Blog
Guides, tips and tricks to work better with Excel, CSV and spreadsheets.
-
-
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.
5 min read -
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.
5 min read -
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.
5 min read -
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.
5 min read -
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…
5 min read
