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:
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
How to Create a Dashboard in Excel in 3 Easy Steps
Learn everything you need to know about how to create a dashboard in Excel, with tips and examples.
Joleen Bothma
November 11, 2022
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
September 22, 2024
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
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
Markov Analysis in Spreadsheets Tutorial
Learn Markov Analysis, their terminologies, examples, and perform it in Spreadsheets!
Avinash Navlani
December 6, 2019
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
Conditional Functions in Spreadsheets
Learn when and how to use conditional functions in spreadsheets.
Francisco Javier Carrera Arias
July 8, 2019
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
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
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
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
May 7, 2019