Data Analysis in Google Sheets

Overview

Learn to use Google Sheets to clean, analyze, and draw insights from data. Discover how to sort, filter, and use VLOOKUP to combine data.

Learn how to clear and analyze data in Google Sheets, discover how to use built-in functions to sort and filter data, and use the VLOOKUP function to combine data from different tables.

These Google Sheets skills, functions, and time-saving shortcuts can be applied to any industry, whether you’re looking to move to a career in data analysis, or looking to improve your skills in marketing, finance, HR, logistics, and more.

Syllabus

Exploring Data

Learn how data analyst skills in spreadsheets can help you draw clearer insights from data. In this chapter, you'll learn how built-in functions can streamline your spreadsheet workflows and improve the readability of your formulas. You'll learn data exploration techniques, such as calculating summary statistics and manipulations like sorting and filtering.

Cleaning and Preparing Data

It is often said that data professionals spend 80% of their time cleaning data and only 20% analyzing it. In this chapter, you'll learn useful functions for cleaning text and DateTime data, two of the trickiest data types to clean. You'll extract date and time components, calculate intervals, and perform a host of common text manipulations on a dataset of the highest-grossing films.

Analyzing Data

In this chapter, you'll learn to draw insights from your data. You'll perform complex calculations using conditional functions, logical expressions, and conditional aggregation functions. You'll also learn and apply the most important spreadsheet function: VLOOKUP!