Learn more about spreadsheets for data analysis, visualisation, and processing. Our spreadsheet tutorials include tips & tricks for various spreadsheets applications.
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.
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.
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.
March 7, 2019
Reading and Importing Excel Files Into R With readxl
In this article, learn how import excel files into R with the readxl library.
March 10, 2023
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.
August 13, 2018
Using Python to Power Spreadsheets in Data Science
Learn how Python can be used more effectively than Excel, with the Pandas package.
June 12, 2018