Skip to main content
Category
Technologies

Spreadsheets Tutorials

Learn more about spreadsheets for data analysis, visualisation, and processing. Our spreadsheet tutorials include tips & tricks for various spreadsheets applications.
Other technologies:
GroupTraining 2 or more people?Try DataCamp for Business
All posts
Excel

Excel Macros Tutorial: Automate Formatting, Reporting, and Data Entry

Learn how to automate repetitive Excel tasks with Excel macros. Create, use, and manage macros to boost productivity and transform your data workflows.

Rajesh Kumar

April 15, 2025

Excel

Excel INDIRECT(): How to Build Dynamic References in Your Formulas

Discover how Excel's INDIRECT() function transforms text into live references. Learn how to use it for dynamic worksheets, stable cell references, named ranges, and more.
Allan Ouko's photo

Allan Ouko

April 10, 2025

Excel

Excel Table: The Essential Tool for Organizing Data

Discover how Excel tables go beyond formatting with powerful features like structured references, automatic expansion, filtering, and integration with PivotTables and charts.
Javier Canales Luna's photo

Javier Canales Luna

April 10, 2025

Excel

Excel Dark Mode: A Smarter Way to Work in Low Light

Learn how to activate Excel’s built-in dark mode and create a fully dark spreadsheet experience. Discover tips and workarounds for reducing eye strain and creating a workbook that looks nice.
Allan Ouko's photo

Allan Ouko

April 8, 2025

Excel

PivotTable Conditional Formatting: Two Good Methods

Learn two reliable methods for applying PivotTable conditional formatting and avoid common pitfalls.
Elena Kosourova's photo

Elena Kosourova

April 4, 2025

Excel

Unprotect Excel Sheet: Methods to Unlock and Edit Your Data

Learn how to unprotect an Excel sheet with and without a password.
Laiba Siddiqui's photo

Laiba Siddiqui

March 26, 2025

Spreadsheets

Conditional Formatting in Excel: A Beginner’s Guide

Explore conditional formatting in Excel with simple to advanced examples and their best practices.
Joleen Bothma's photo

Joleen Bothma

July 8, 2024

Spreadsheets

Correlation Matrix In Excel: A Complete Guide to Creating and Interpreting

Learn the statistical concept of correlation, and follow along in calculating and interpreting correlations for a sample dataset, in a step-by-step tutorial.
Arunn Thevapalan's photo

Arunn Thevapalan

May 30, 2024

Spreadsheets

Monte Carlo Simulation in Excel: A Complete Guide

A beginner-friendly, comprehensive tutorial on performing Monte Carlo Simulation in Microsoft Excel, along with examples, best practices, and advanced techniques.
Arunn Thevapalan's photo

Arunn Thevapalan

May 2, 2024

Spreadsheets

How to Calculate Confidence Intervals in Excel

A beginner-friendly, comprehensive tutorial on understanding Confidence Interval calculations in Microsoft Excel.
Arunn Thevapalan's photo

Arunn Thevapalan

April 26, 2024