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:
Training 2 or more people?Try DataCamp for Business
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
Reading and Importing Excel Files Into R With readxl
In this article, learn how import excel files into R with the readxl library.
Vidhi Chugh
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.
Rohit Peesa
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.
Jason Graham
June 12, 2018