Course Outline

Introduction

Google Sheets Overview

  • What is Google Sheets?
  • Google Sheets features
  • Google Sheets vs Excel

Google Sheets Fundamentals

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

Functions and Formulas

  • Creating functions and formulas
  • Using lookups

Data Visualization

  • Creating charts and graphs

Google Sheets Advanced

  • Pulling data
  • Creating macros
  • Using add-ons

Summary and Conclusion

Requirements

  • A basic understanding of computers

Audience

  • Data Analysts
  14 Hours

Number of participants



Price per participant

Related Courses

Big Data Business Intelligence for Govt. Agencies

  35 Hours

Big Data Business Intelligence for Telecom and Communication Service Providers

  35 Hours

Related Categories