Google Sheets - Beginner

2 Hours, 47 Minutes


Delivery Method

UT Pro from New Horizons

This class is part of a 12‑month UT Pro Subscription

Course Overview

This course is designed to teach the student the fundamentals of Google Sheets. Students will learn how to create, save, enter data, and print spreadsheets in addition to learning how to create formulas and use functions to calculate in Sheets. Additionally, students will learn how to format spreadsheets, manipulate columns and rows, prepare a spreadsheet for printing. Students will also learn how to create and format charts, and insert graphics and images.

Course Objectives

Introduction, Getting Started with Google Sheets, Entering Data, Understanding Formula Basics, Formatting a Spreadsheet, Managing Spreadsheets, Printing a Spreadsheet, Creating Charts, Working with Graphics, Conclusion

Course Prerequisites

Basic computer skills


1 - Introduction

  • Introduction

2 - Getting Started with Google Sheets

  • What is Google Sheets?
  • Opening Google Sheets
  • Importing and Converting Spreadsheets to Sheets
  • Navigating the Sheets User Interface
  • Understanding Sheet Components
  • Using the File Menu
  • Creating a Spreadsheet
  • Saving a Spreadsheet
  • Accessing Help

3 - Entering Data

  • Navigating a Spreadsheet by Mouse or Keyboard
  • Working with Cell and Ranges
  • Using Various Data Selection Techniques
  • Working with Common Sheet Commands
  • Working with Copy and Paste
  • Understanding Data Types
  • Formatting Values
  • Using the Autofill Handle
  • Inserting Links

4 - Understanding Formula Basics

  • What are Formulas and Functions?
  • Understanding the Components of A Formula
  • Understanding Calculation Hierarchy and the Order of Operations
  • Creating Basic Formulas
  • Working with Basic Functions and Autosum
  • Using Cell References
  • Using Explore

5 - Formatting a Spreadsheet

  • Formatting and Aligning Data
  • Modifying Columns and Rows
  • Using Borders and Fill
  • Using Paint Format
  • Inserting Notes or Comments
  • Inserting Checkboxes

6 - Managing Spreadsheets

  • Using Zoom Tools
  • Working with Sheets
  • Working with Spreadsheet Tabs
  • Hiding and Unhiding Spreadsheets
  • Sorting Sheets Data
  • Filtering Sheets Data
  • Using Filter Views
  • Using Freeze Panes

7 - Printing a Spreadsheet

  • Using Find and Replace
  • Using Spell Check
  • Preparing a Spreadsheet for Printing
  • Changing Spreadsheet Settings
  • Finalizing Printing
  • Downloading and Emailing Files
  • Sharing a Spreadsheet

8 - Creating Charts

  • Inserting a Chart
  • Formatting a Chart
  • Moving and Sizing a Chart

9 - Working with Graphics

  • Inserting Images
  • Creating Drawings

10 - Conclusion

  • Course Recap

What is UT Pro?

UT Pro is a 12-month subscription that provides unlimited access to full-day or short-duration live classes, on-demand video courses, class recordings, and quick reference cards. New Horizons offers more learning solutions for Microsoft Office than any other training provider and they are all included in your UT Pro subscription.

  • Unlimited enrollments into over 90 full-day and short-duration live training classes
  • Over 750 hours of on-demand video based content
  • A full library of digital quick reference cards for your favorite Office applications
  • Access to class recordings so you never have to worry about missing a scheduled class

Benefits of a UT Pro Subscription

Our UT Pro subscription is built to fit in and around your schedule. It will change the way you think about training.

  • Ask questions and get immediate answers during our full-day and short-duration live classes
  • Learn how to perform specific tasks instead of wasting time learning things you already know
  • Collaborate with fellow students and gain insight into new ways to solve problems
  • View on-demand courses with instructors that never leave your screen
  • Utilize course assessments to validate new skills
  • Take full day training classes on your schedule by accessing our class recordings
  • Revisit a prior class to further enhance your skills

Need more information? Click here to learn more about UT Pro.