Get in Touch

Course Outline

Introduction

Google Sheets Overview

  • What is Google Sheets?
  • Key features of Google Sheets
  • Google Sheets vs. Excel

Google Sheets Fundamentals

  • Creating, sharing, and formatting spreadsheets
  • Working with pivot tables
  • Sorting and filtering data
  • Using find and replace functions

Functions and Formulas

  • Creating functions and formulas
  • Using lookups

Data Visualization

  • Creating charts and graphs

Advanced Google Sheets

  • Pulling data from external sources
  • Creating macros
  • Using add-ons

Summary and Next Steps

Requirements

  • Basic understanding of computers.

Audience

  • Data analysts.
 14 Hours

Related Categories