Spreadsheet Tutorials | Tips, Tricks, & Features For Data Analysis

Training 2 or more people?Try DataCamp for Business

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

Spreadsheets

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 Analysis

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

Spreadsheets

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

Python

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

Technologies

Topics

Spreadsheets Tutorials