Google Sheets for Excel Users Training Course

Course Code

googlesheets

Duration

14 hours (usually 2 days including breaks)

Requirements

  • A basic understanding of computers

Audience

  • Data Analysts

Overview

Google Sheets is a cloud-based spreadsheet application for formatting and analyzing data. Google Sheets is a great alternative to Excel that provides cloud capabilities and more.

This instructor-led, live training (onsite or remote) is aimed at data analysts who wish to use Google Sheets for data analysis.

By the end of this training, participants will be able to:

  • Build spreadsheets with Google Sheets.
  • Use formulas that work both in Google Sheets and Excel.
  • Format and analyze any data.
  • Create data visualizations with charts and graphs.

Format of the Course

  • Interactive lecture and discussion.
  • Lots of exercises and practice.
  • Hands-on implementation in a live-lab environment.

Course Customization Options

  • To request a customized training for this course, please contact us to arrange.

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

Testimonials

★★★★★
★★★★★

Related Categories

Related Courses

Course Discounts

Course Discounts Newsletter

We respect the privacy of your email address. We will not pass on or sell your address to others.
You can always change your preferences or unsubscribe completely.

Some of our clients

is growing fast!

We are looking to expand our presence in India!

As a Business Development Manager you will:

  • expand business in India
  • recruit local talent (sales, agents, trainers, consultants)
  • recruit local trainers and consultants

We offer:

  • Artificial Intelligence and Big Data systems to support your local operation
  • high-tech automation
  • continuously upgraded course catalogue and content
  • good fun in international team

If you are interested in running a high-tech, high-quality training and consulting business.

Apply now!