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:
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 28, 2022
Python Excel Tutorial: The Definitive Guide
Learn how to read and import Excel files in Python, write data to these spreadsheets, and find the best packages to do this.
Aditya Sharma •
May 22, 2020
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
Pivot Tables in Spreadsheets
Learn how to organize rows and columns, add values, find the sum of revenue, and finally apply filtering to select a subset of data from a given dataset.Aditya Sharma •
April 8, 2019