Google Sheets: The Basics | Online

About this class

Mastering the tools to analyze data is important in every job function. Google Sheets is one of the most powerful data analysis tools today, but is vastly underutilized. It offers similar functionality to Excel while working seamlessly with all other Google Applications.

In this class, you will learn the basics of how to use Google Sheets like you would Excel. We will also review some functions unique to Google Sheets that allow you to import real-time data, like currency exchange rates.

Takeaways

• Learn how to navigate Google Sheets menus and work with absolute and relative references
• Apply Google Sheet formulas from SUMS to VLookup
• Create Pivot Tables to quickly analyze data
• Work with Google Sheets documentation, so no formula is off limits
• Use Google Sheets "Explore" to create helpful charts

Prereqs & Preparation

Laptop and Gmail account required.