Google Sheets Training Course

person icon Uplatz

Google Sheets Training Course

Comprehensive training on Google Sheets. Store, manage & analyze your data, use functions, build lookup, pivots, charts.

updated on icon Updated on Sep, 2023

language icon Language - English

person icon Uplatz

architecture icon IT & Software,IT Certification,Google Sheets


30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 19,000+ top Tutorialspoint courses anytime, anywhere.

Course Description

A warm welcome to the Google Sheets course by Uplatz.

Google Sheets is the spreadsheet application software available within Google's cloud-based office suite. Google Sheets has been designed with the needs of agile organizations in mind. AI features mean you can tap into the right insights to make meaningful business decisions. A cloud-based architecture enables you to collaborate with anyone, anytime, anywhere. Compatibility with external systems, including Microsoft Office, removes the friction of working with multiple data sources. Based on Google’s infrastructure, Sheets provides the flexibility to create amazing spreadsheets while helping to keep your information secure.

Google sheets is being used by more and more companies instead of Microsoft Excel. There are many advantages to using Google Sheets the main one being the ability to share a sheet with multiple users. It is free to use and works in a browser! So there is no need to install anything on your machine neither to buy any license.

This Google Sheets training course by Uplatz will get you used to Google sheets and be able to create and manage it in practical situations even if you have never used spreadsheets before. The Google Sheets course will introduce you to the basics of creating spreadsheets using the free Google Sheets application. This course will teach you some of the essential features of Google Sheets and how they can be used to work together in an interactive and graphical way. You will be able to take a deep-dive into all the features and options available in Google Sheets. This Google Sheets training provides detailed demonstration on how to use functions, build pivot tables, charts, formatting, filtering, sorting, AI-based and dynamic functions, analyze data on the fly, and more in Google Sheets.

Course Topics at high-level

An Introduction to Google Sheets

  • Create a new Google Sheet

  • Name a Spreadsheet

  • Upload an Existing Excel Spreadsheet

  • Edit Cells

  • Use Auto-fill

  • Format Cells

  • Format Text and Numbers

  • Basic Formulas and Functions

  • Use the Sum function

  • Create and Copy Formula using Auto-fill

  • Sort and Filter data

  • Finding your way around Google Sheets

  • Opening Files

  • Move data from Excel Files to Google Sheets and vice-versa

  • What about saving files?

  • File Management

  • Adding/Deleting Worksheets

  • Renaming Worksheets

Basic Formatting

  • Formatting Numbers

  • Dealing with Dates

  • Changing the Typeface

  • Adding more fonts

  • Adding Colors

  • Format Painter

Formulas in Google Sheets

  • Basic Arithmetic

  • Operator Preference

  • Absolute References

  • Using Functions

  • Calculating between Worksheets

Printing Google Sheets

  • Selecting a print area

  • Fitting everything onto a page

  • Creating a PDF

  • Printing all sheets

Sharing a Google Sheet

  • Choosing people to share with

  • Restricting Editing

  • Preventing others from downloaded and printing

Google Sheets course curriculum

  • Introduction

  • Menu Options - File

  • Menu Options - Edit

  • Menu Options - View

  • Menu Options - Insert

  • Menu Options - Format

  • Menu Options - Data and more

  • Entering Data and Filtering

  • Functions - Numeric Function

  • Functions - Text Function

  • Functions - Data Functions

  • Charts and Conditional Formatting

  • Pivot Tables

  • Saving, Sharing, Collaboration

Course Objectives

  • Learn how to navigate around Google Sheets

  • Learn how to adjust the way data and information are displayed

  • Learn how to write formulas quickly and easily

  • Learn how to create powerful calculations

  • Learn how to visually represent your data with charts and graphs

  • Learn how to use data tools like sorting, subtotaling, and filtering

  • Learn Google sheets shortcuts, tips, tricks

Who this course is for:

  • Data Analysts and Consultants
  • Project Managers
  • Newbies aspiring to learn Google Sheets
  • Beginners aspiring to become Data Analysts
  • Data Management Professionals
  • Business and Financial Analysts
  • Project Support Personnel
  • Students aspiring for a career in Management Consulting or IT Operations
  • Students who want to build quick and easy-to-share online spreadsheets


What will you learn in this course:

  • End-to-end knowledge of Google Sheets

  • Understand fully the Menu options - File, Edit, View, Insert, Format, Data, more

  • Entering Data and Editing

  • Format and Customize Data

  • Filtering, Sorting, Conditional Formatting

  • Functions - Numeric, Text, Date

  • Pivot Tables, VLookup, HLookup

  • Charts and Graphs

  • Advanced Functions such as Google Translate

  • Introduction to Script Editor

  • Saving, Sharing, Collaboration in Google Sheets

  • Get fully familiarized in a spreadsheet environment

  • Tips and Tricks


What are the prerequisites for this course?

  • Enthusiasm and determination to make your mark on the world!

Google Sheets Training Course


Check out the detailed breakdown of what’s inside the course

Introduction to Google Sheets
1 Lectures
  • play icon Introduction to Google Sheets 02:31 02:31
Menu Options
6 Lectures
Entering Data and Editing
1 Lectures
3 Lectures
Charts and Conditional Formatting
1 Lectures
Pivot Tables
1 Lectures
Saving, Sharing, Collaboration
1 Lectures

Instructor Details



Uplatz is UK-based leading IT Training provider serving students across the globe. Our uniqueness comes from the fact that we provide online training courses at a fraction of the average cost of these courses in the market. 

Over a short span of 3 years, Uplatz has grown massively to become a truly global IT training provider with a wide range of career-oriented courses on cutting-edge technologies and software programming.

Course Certificate

User your certification to make a career change or to advance in your current career. Salaries are among the highest in the world.

sample Tutorialspoint certificate

Our students work
with the Best

Related Video Courses

View More

Annual Membership

Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses

Subscribe now
People having fun around a laptop

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
People having fun around a laptop

Talk to us