Skip to main content
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:
AI AgentsAI NewsArtificial IntelligenceAWSAzureBusiness IntelligenceChatGPTDatabricksdbtDockerGenerative AIGitGoogle Cloud PlatformHugging FaceJavaJuliaKafkaKubernetesLarge Language ModelsMongoDBMySQLNoSQLOpenAIPostgreSQLPower BIPySparkPythonRScalaSnowflakeSpreadsheetsSQLSQLiteTableau
GroupTraining 2 or more people?Try DataCamp for Business
Excel

Excel Checkbox: How to Add, Use, and Count Them

Learn how to add checkboxes in Excel for interactive to-do lists, trackers, and dashboards. This guide covers native and legacy methods, formulas, and conditional formatting.
Khalid Abdelaty's photo

Khalid Abdelaty

January 31, 2026

Excel

Find and Replace in Excel: Save Time and Avoid Mistakes

Learn how to use Find and Replace in Excel to clean data, fix errors, and make bulk changes without breaking formulas or formatting.
Allan Ouko's photo

Allan Ouko

January 29, 2026

Excel

AutoSum in Excel: Add Numbers Instantly with One Click

Learn how to use AutoSum in Excel to quickly sum columns and rows. This guide covers shortcuts, common functions, troubleshooting, and working with filtered data.
Khalid Abdelaty's photo

Khalid Abdelaty

January 28, 2026

Excel

Gridlines in Excel: How to Add, Print, and Remove

Understand how Excel gridlines work, when they appear, and how they are different from borders. Learn to create clear worksheets on screen and in print.
Allan Ouko's photo

Allan Ouko

January 27, 2026

Excel

How to Clear Excel Cache (Windows and Mac)

Learn how to clear Excel cache on Windows and Mac to solve common problems like lag and sync errors, and follow best practices to keep Excel running smoothly.
Allan Ouko's photo

Allan Ouko

January 26, 2026

Excel

Excel Version History: How to View, Restore, and Recover Your Work

Learn how Excel version history helps you view, restore, and recover previous file versions without losing your current work.
Allan Ouko's photo

Allan Ouko

January 23, 2026

Excel

How to Add Days to a Date in Excel: All Methods Explained

Learn how to add days to a date in Excel using simple arithmetic and functions like DATE(), EDATE(), and WORKDAY(), with practical examples and pitfalls to avoid.
Allan Ouko's photo

Allan Ouko

January 22, 2026

Excel

How to Show Formulas in Excel (Instead of Results)

Learn how to show formulas for a full worksheet, check individual cells, prepare files for review or printing, and avoid common issues.
Laiba Siddiqui's photo

Laiba Siddiqui

January 15, 2026

Excel

Reduce Excel File Size: Effective Methods That Actually Work

Large Excel files slow everything down and make sharing harder than it should be. This guide explains why Excel files grow over time and shows practical, safe ways to reduce file size.
Laiba Siddiqui's photo

Laiba Siddiqui

January 10, 2026

Excel

Excel Power Pivot: A Step-by-Step Guide

Learn how to connect tables, write DAX formulas, and build interactive reports inside Excel.
Laiba Siddiqui's photo

Laiba Siddiqui

January 6, 2026

Excel

SUMPRODUCT() Excel: What You Should Know

A practical guide to using SUMPRODUCT() for conditional, weighted, and matrix-based calculations in Excel
Laiba Siddiqui's photo

Laiba Siddiqui

January 6, 2026