Category
Technologies
Excel Tutorials
Keep up to date with the latest news, techniques, and resources for Excel. Our tutorials are full of practical walk throughs & use cases you can use to upskill.
Other technologies:
Training 2 or more people?Try DataCamp for Business
A Comprehensive Guide to Using ANOVA in Excel
Learn the simplified process of conducting ANOVA in Excel, and interpreting the results with clear, step-by-step instructions.
Arunn Thevapalan
June 7, 2024
How to Clean Data in Excel: A Beginner's Guide
Learn essential data cleaning techniques in Excel, including removing duplicates, handling missing values, and maintaining consistent formatting.
Laiba Siddiqui
July 19, 2024
What is Data Validation in Excel? A Comprehensive Guide to Add, Edit, and Remove Data Validation Rules in Excel
Applying data validation in Excel is simple: Open the 'Data' tab. Go to the 'Data Tools' group. Click on the 'Data Validation' button.
Elena Kosourova
May 31, 2024
How to Use XLOOKUP() with Multiple Criteria in Excel
Master Excel's powerful XLOOKUP() function with concatenation and boolean expressions to search data using multiple conditions
Elena Kosourova
December 23, 2025