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
 

Testimonials

Related Courses

Business Intelligence in MS SQL Server 2008

  14 hours

Big Data Business Intelligence for Govt. Agencies

  35 hours

Big Data Business Intelligence for Telecom and Communication Service Providers

  35 hours

Datameer for Data Analysts

  14 hours

Big Data Business Intelligence for Criminal Intelligence Analysis

  35 hours

Pentaho Open Source BI Suite Community Edition (CE)

  28 hours

Business Intelligence with SSAS

  14 hours

Power BI Dashboards

  14 hours

IRIS: Document Classification and Data Capture

  7 hours

Qlik Sense for Data Science

  14 hours

QlikView Server Administration

  14 hours

Qlik: Advanced Topics in Design and Development

  14 hours

55232-A: Writing Analytical Queries for Business Intelligence

  21 hours

AWS QuickSight

  14 hours

Sisense Business Intelligence

  14 hours