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:
Data Visualization

Visualizing Data in Excel

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

Jess Ahmet

April 27, 2023

Spreadsheets

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's photo

Abid Ali Awan

September 22, 2024

Python

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's photo

Natassha Selvaraj

December 3, 2024

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's photo

Avinash Navlani

January 8, 2020

Spreadsheets

Markov Analysis in Spreadsheets Tutorial

Learn Markov Analysis, their terminologies, examples, and perform it in Spreadsheets!
Avinash Navlani's photo

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's photo

Avinash Navlani

November 5, 2019

Spreadsheets

Conditional Functions in Spreadsheets

Learn when and how to use conditional functions in spreadsheets.
Francisco Javier Carrera Arias's photo

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's photo

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's photo

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's photo

Aditya Sharma

May 10, 2019

Spreadsheets

Conditional Formatting in Spreadsheets

Learn how to utilize conditional formatting with one or multiple conditions and how to color cells by custom criteria with the help of a dataset.
Aditya Sharma's photo

Aditya Sharma

May 7, 2019