Learn the fundamental skills necessary to analyze data in Google Sheets! You’ll cover the foundational knowledge in data analysis, manipulation, and visualization and learn how to analyze and visualize data efficiently and effectively.Â
You’ll start by understanding the core functionality of spreadsheets, exploring how to use predefined functions to analyze data. You’ll then learn about data types, manipulation of numeric and logical data, missing data, and error types.Â
As you progress, you’ll discover how to use pivot tables to work with large quantities of data in Google Sheets efficiently. You’ll learn how to organize and evaluate data within seconds using a variety of real-world examples.Â
Finally, you’ll cover spreadsheet data visualization techniques. You’ll learn how to create different types of charts, including bar charts, histograms, scatter charts, sparkline, and candlestick charts, and how to use data validation and VLookup formulas.
Overview
Syllabus
- Introduction to Google Sheets
- Bring your Google Sheets to life by mastering fundamental skills such as formulas, operations, and cell references.
- Data Analysis in Google Sheets
- Learn to use Google Sheets to clean, analyze, and draw insights from data. Discover how to sort, filter, and use VLOOKUP to combine data.
- Intermediate Google Sheets
- Expand your Google Sheets vocabulary by diving deeper into data types, including numeric data, logical data, and missing data.
- Pivot Tables in Google Sheets
- Learn how to create pivot tables and quickly organize thousands of data points with just a few clicks.
- Data Visualization in Google Sheets
- Learn the fundamentals of data visualization using Google Sheets.
Taught by
Frank Sumanski, Richie Cotton, Raina Hawley, and James Chapman
