Course Code: 18999

Google Sheets - Beginner Level 1

Class Dates:
1 Days
Class Time:
Instructor-Led Training, Virtual Instructor-Led Training


  • Course Overview
  • Google Docs is a free, Web-based office suite and data storage service offered by Google. It allows users to create and edit documents online while collaborating in real-time with other users. It is a collection of applications that make it easier to produce the kinds of files commonly used in corporate environments: documents, spreadsheets, and presentations. In this course you will be given a basic introduction to Google Docs. Topics covered in the course include: Google collaboration and the sharing of information online, Google Documents, Google Spreadsheets.. This course will be of great interest to business professionals and individuals who would like to know how Google Docs can help improve productivity.
  • Audience
  • This course is intended for students who wish to gain the foundational understanding of Google Sheets fundamentals that is necessary to create and work with electronic spreadsheets.

    Upon successful completion of this course, you will be able to create and develop Google worksheets and workbooks in order to work with and analyze the data that is critical to the success of your organization.

    What you'll learn:

    Create or import
    Add content
    Share and collaborate
    Print and download
    Access your calendar, notes, and tasks


  • To ensure success, students will need to be familiar with using personal computers and should have experience using a keyboard and mouse. Students should also be comfortable working in the Windows® 10 environment and be able to use Windows 10 to manage information on their computers. Specific tasks the students should be able to perform include: opening and closing applications, navigating basic file structures, and managing files and folders. Know how to connect to an online environment and using a Browser on the internet.

Course Details

  • Getting Started with Google Sheets
  • Set up Practice Files
  • Upload and Convert Practice Files
  • Update Google Drive
  • Update Google Drive File Conversion Settings
  • Create and Open a Practice Folder
  • Upload Practice Files
  • Sheets Fundamentals
  • Create Spreadsheets
  • Create and Name Spreadsheet, Save and Close
  • Create a Spreadsheet from a Template
  • Open a Spreadsheet from Google Drive
  • Open a Spreadsheet from Google Sheets
  • Navigate Spreadsheet
  • Select a Cell
  • Navigate Between Cells and Pages, Navigate Between Sheets
  • File Management, Rename a Spreadsheet
  • Star a Spreadsheet, Copy, Move and Delete a Spreadsheet
  • Print Spreadsheets
  • Search for a Command, Search for Help
  • Edit Spreadsheets.
  • Select Cells and Ranges
  • Select a Sell, a Row, a Column, Range of Cells, Select All cells
  • Edit Cell Data, Enter Cell Data, Replace Cell Data, Edit Cell Data, Clear Cell’s Contents.
  • Cut, Copy, and Paste Data, Copy and Paste, Cut and Paste
  • Undo, Redo, and Repeat
  • Use Paste Special., Paste Formulas, Paste Values, Transpose Data, Paste Special Options
  • Insert and Move Cells, Insert Cells, Insert Rows or Columns, Move Cells
  • Delete Cells, Rows and Columns
  • Hide Rows and Columns, Hide and Unhide a Row or Column
  • Find and Replace Text
  • Check Spelling
  • Format Spreadsheets
  • Format Text, Change Font, Change Font Size
  • Apply Font Effects. Clear Text Formatting
  • Align and Merge Cells.
  • Change Horizontal Alignment
  • Change Vertical Alignment
  • Wrap Text, Merge Cells, Unmerge Cells
  • Cell Borders and Background Colors
  • Add a Cell Border, Edit a Cell Border, Change Fill Color
  • Format Numbers and Dates
  • Apply Currency Format, Date Format, Custom Date & Time Format, Create a Custom Number Format
  • Adjust Row Height and Column Width
  • Freeze Rows & Columns, Copy and Paste
  • Formulas and Functions
  • Formula Basics, Create a Formula, Update & Edit
  • Autofill, Use Autofill to Duplicate Data
  • Sums and Averages
  • Min and Max, Count
  • Insert Functions
  • Absolute and Relative Cell References
  • Cell Range Names
  • Manage Sheets and Data
  • Insert, Rename, and Delete Sheets
  • Duplicate, Move, and Hide Sheets
  • Sort Data
  • Filter Data
  • Data Validation
  • Protect Spreadsheets