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.
Mar 2019 · 11 min read
Learn the basics of spreadsheets by working with rows, columns, addresses, and ranges.
Expand your spreadsheets vocabulary by diving deeper into data types, including numeric data, logical data, and missing data.
Data Analysis in Spreadsheets
Learn how to analyze data with spreadsheets using functions such as SUM(), AVERAGE(), and VLOOKUP().
See MoreSee More
Data-Driven Thinking for Everyday Life
Gary Wolf talks about what The Quantified Self is, why self-tracking projects can be life-changing, how to get started with self-tracking, and how to connect with others.
Excel Basics Cheat Sheet
Learn the basics of Excel with our quick and easy cheat sheet. Have the basics of formulas, operators, math functions and more at your fingertips.
Reshaping Data with pandas in Python
Pandas DataFrames are commonly used in Python for data analysis, with observations containing values or variables related to a single object and variables representing attributes across all observations.
Reshaping Data with tidyr in R
In this cheat sheet, you will learn how to reshape data with tidyr. From separating and combining columns, to dealing with missing data, you'll get the download on how to manipulate data in R.
Data Quality Dimensions Cheat Sheet
In this cheat sheet, you'll learn about data quality dimensions, allowing you to ensure that your data is fit for purpose.
Top Techniques to Handle Missing Values Every Data Scientist Should Know
Explore various techniques to efficiently handle missing values and their implementations in Python.