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
How to Create a Heat Map in Excel: Step-by-Step Guide
Learn how to create a heat map in Excel using Conditional Formatting, customize color scales, and visualize patterns in your data.
Laiba Siddiqui
August 6, 2026
SUMIF() in Excel: A Beginner's Guide
Learn how to use Excel’s SUMIF() function to add values that meet a condition, with syntax explanations, practical examples, and common mistakes to avoid.
Laiba Siddiqui
August 2, 2026
Grok in Excel: A Hands-On Guide With 6 Practical Examples
Learn how to use Grok in Microsoft Excel to analyze data, generate formulas, clean spreadsheets, create charts, and run financial scenarios using natural-language prompts.
Khalid Abdelaty
July 30, 2026
How to Track Changes in Excel: View & Restore Edits
Learn how to track changes in Excel using Show Changes, Version History, and collaboration features.
Laiba Siddiqui
July 23, 2026
XLOOKUP(): Excel's Most Versatile Lookup Function
Learn how to use Excel's XLOOKUP() function with step-by-step examples. We cover the syntax, exact and approximate matches, multi-column returns, and how to fix common errors.
Laiba Siddiqui
July 16, 2026
What-If Analysis in Excel: Goal Seek, Scenario Manager, and Data Tables
Learn how to use Excel What-If Analysis tools to test assumptions, compare scenarios, and model different outcomes without changing your original data.
Laiba Siddiqui
July 13, 2026
How to Use Name Manager in Excel (Step-by-Step Guide)
Learn how to use Excel Name Manager to create, edit, and delete named ranges and write cleaner, easier-to-maintain formulas.
Amole Oluwaferanmi
April 17, 2026
How to Calculate Time in Excel: A Guide With Examples
Master time calculations in Excel. Apply ready-to-use formulas directly to your own data.
Amole Oluwaferanmi
March 19, 2026
How to Count Words in Excel: 4 Easy Methods
Explore simple formulas, modern Excel functions, and newer AI tools to count words in Excel.
Laiba Siddiqui
March 9, 2026
Waterfall Chart Excel: A Step-By-Step Guide
Learn how to build clear and accurate waterfall charts in Excel using both built-in tools and manual methods. Explore useful variations such as stacked, dynamic, and vertical layouts.
Laiba Siddiqui
March 9, 2026
How to Remove Leading Zeros in Excel: 4 Methods
Learn step-by-step methods to remove leading zeros from both numeric and text values in Excel.
Laiba Siddiqui
March 9, 2026
How to Combine Cells in Excel: 2 Different Approaches
This guide walks you through safe, formula-based approaches and visual merge options to help you format your worksheets without breaking your data.
Laiba Siddiqui
March 4, 2026