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:
Training 2 or more people?Try DataCamp for Business
Featured
The 15 Basic Excel Formulas Everyone Needs to Know
Learn how to add arithmetic, string, time series, and complex formulas in Microsoft Excel.
Abid Ali Awan
March 14, 2025
How to Analyze Data in Google Sheets With Python: A Step-By-Step Guide
Boost your data analysis skills with our step-by-step guide on how to analyze, manipulate and write back data in Google Sheets using Python.
Filip Schouwenaars
May 18, 2023
Python Excel: A Guide With Examples
Learn how to read and import Excel files in Python, write data to these spreadsheets, and find the best packages to do this.
Natassha Selvaraj
December 3, 2024
All posts
Excel Compound Interest Formula: A Comprehensive Guide
Learn to use Excel to calculate compound interest along with practical techniques and real-world applications to enhance your financial analysis skills.
Arunn Thevapalan
April 17, 2025
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 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
April 10, 2025
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
April 10, 2025
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
April 8, 2025
PivotTable Conditional Formatting: Two Good Methods
Learn two reliable methods for applying PivotTable conditional formatting and avoid common pitfalls.
Elena Kosourova
April 4, 2025
Unprotect Excel Sheet: Methods to Unlock and Edit Your Data
Learn how to unprotect an Excel sheet with and without a password.
Laiba Siddiqui
March 26, 2025
Conditional Formatting in Excel: A Beginner’s Guide
Explore conditional formatting in Excel with simple to advanced examples and their best practices.
Joleen Bothma
July 8, 2024
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
May 30, 2024
How to Calculate the Coefficient of Variation in Excel
Calculating the coefficient of variation in Excel is a straightforward process: we divide STDEV.P by AVERAGE.
Arunn Thevapalan
May 15, 2024
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
May 2, 2024
How to Calculate Confidence Intervals in Excel
A beginner-friendly, comprehensive tutorial on understanding Confidence Interval calculations in Microsoft Excel.
Arunn Thevapalan
April 26, 2024