Congratulations!

Data Analysis in Google Sheets

James Chapman

Curriculum Manager, DataCamp

The data analysis process

 

 

All stages of data analysis: formulate the problem, collect the data, explore the data, clean and prepare the data, analyze the data, and present the findings.

Data Analysis in Google Sheets

Chapter 1

 

A magnifying glass zooming in on some data.

 

 

  • Built-in functions
  • Summary statistics for exploring data
  • Filtering and sorting data
Data Analysis in Google Sheets

Chapter 2

 

 

  • Extracting date and time components
  • Calculating date intervals
  • Cleaning and manipulating text data

A mop and bucket.

Data Analysis in Google Sheets

Chapter 3

 

A complex maze with the line from entrance to exit drawn through it.

 

 

  • Conditional and logical functions
  • Conditional aggregations
  • VLOOKUP()
Data Analysis in Google Sheets

What next?

 

Spreadsheets Fundamentals

  • Write more advanced formulas
  • Learn lots more functions!
  • Pivot tables
  • Data Visualization
Data Analysis in Google Sheets

Congratulations!

Data Analysis in Google Sheets

Preparing Video For Download...