Spreadsheet Tutorials | Tips, Tricks, & Features For Data Analysis | DataCamp

Training 2 or more people?Try DataCamp for Business

Spreadsheets

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

Data Visualization

Visualizing Data in Excel: A Complete How-To Guide

Learn about Excel's various data visualization options that can help you analyze and interpret your data.

Jess Ahmet

May 18, 2026

How to Create a Dashboard in Excel: A Step-by-Step Guide

Build interactive Excel dashboards with this tutorial covering pivot tables, charts, slicers, and design best practices.

Joleen Bothma

May 29, 2026

Spreadsheets

The 20 Basic Excel Formulas Everyone Needs to Know

Learn the top 20 essential Excel functions and formulas, everything from SUM() and IF() to XLOOKUP() and IFERROR(), with examples and tips for combining them.

Abid Ali Awan

November 4, 2026

Python Excel Tutorial: A Complete Guide With openpyxl

Learn to read and write Excel files in Python using openpyxl. This guide covers formulas, charts, cell formatting, and worksheet manipulation with hands-on exam

Natassha Selvaraj

June 3, 2026

Spreadsheets

Time Series Analysis with Spreadsheets Tutorial

In this tutorial, you'll learn basic time-series concepts and basic methods for forecasting time series data using spreadsheets.

Avinash Navlani

January 8, 2020

Spreadsheets

Markov Analysis in Spreadsheets Tutorial

Learn Markov Analysis, their terminologies, examples, and perform it in Spreadsheets!

Avinash Navlani

December 6, 2019

Spreadsheets

Chi-square Test in Spreadsheets

In this tutorial, you'll learn how to perform the chi-square test in spreadsheets.

Avinash Navlani

November 5, 2019

Spreadsheets

Conditional Functions in Spreadsheets

Learn when and how to use conditional functions in spreadsheets.

Francisco Javier Carrera Arias

July 8, 2019

Spreadsheets

Data Wrangling with INDEX-MATCH in Spreadsheets

In this tutorial, you will get an overview of how to use the INDEX-MATCH function in spreadsheets.

Francisco Javier Carrera Arias

June 10, 2019

Spreadsheets

Inventory Model Simulation with Spreadsheets

Learn how to use spreadsheets to calculate an inventory demand model that helps determine how much inventory a business should hold moving forward.

Avinash Navlani

May 27, 2019

Spreadsheets

How to Add, Subtract, Divide and Multiply in Spreadsheets

Learn how to apply operations like add, subtract, divide, multiply, and a lot more in Google Spreadsheets with the help of an actual dataset.

Aditya Sharma

May 10, 2019