Google Sheets: Analyze Data in the Cloud | Online

About this workshop

Mastering the tools to analyze data is important in every job function. Google Sheets is a powerful spreadsheet application in the cloud. It offers similar functionality to Excel but includes a host of amazing additional features unique to Google Sheets.

In this class, you will learn the fundamentals of how to use Google Sheets. We will also review the features unique to Google Sheets like importing web data and using Forms to collect survey data.

Takeaways

• Learn how to navigate Google Sheets
• Apply Google Sheets formulas to perform powerful calculations
• Create Pivot Tables and charts to quickly analyze data
• Introduction to gathering data from the web
• Introduction to building Forms for collecting data from individuals to analyze in Google Sheets
• Introduction to Google Add-ons e.g. Google Analytics reporting

Prereqs & Preparation

Laptop and Gmail account required. Basic familiarity with spreadsheets.