category
Spreadsheets Tutorials
Learn more about spreadsheets for data analysis, visualisation, and processing. Our spreadsheet tutorials include tips & tricks for various spreadsheets applications.Other technologies:
The 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
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
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
Data Wrangling with VLOOKUP in Spreadsheets
In this tutorial, you will get an overview of how to use the VLOOKUP function and also a basic explanation of INDEX-MATCH.
Francisco Javier Carrera Arias •
March 13, 2019
Video: Intro to Python for Spreadsheet Users
In this video tutorial, you'll watch the end-to-end automation of a routine spreadsheet task being completed using Python.
Ryan Sheehy •
March 7, 2019
Reading and Importing Excel Files into R Tutorial
R Tutorial on Reading and Importing Excel Files into R. Understand how to read and import spreadsheet files using basic R and packages.
Karlijn Willems •
December 21, 2018
Datasets from Images
This tutorial will demonstrate how you can make datasets in CSV format from images and use them for Data Science, on your laptop.
Rohit Peesa •
August 13, 2018