Google Sheets Online Training

Sale price€450.00


A spreadsheet refers to a file made of rows and columns where users can put their data. It allows you to sort, arrange and perform numerical calculations in different fields. Google Sheets is a web-based application that allows users to create, modify and update spreadsheets online. Using Sheets, users can analyze and organize their information, add, delete, and sort their rows and columns. This Google product enables multiple users to chat and collaborate in a secure environment in real-time and track changes. Every change made to your spreadsheets is saved automatically in Sheets, and you can track edits using a feature called Version History that presents changes. Google Sheet supports several file types, including XLS, XLSX, XLSM, TXT, ODS, and CSV, making it easy to view and convert Microsoft Office files directly from Google Drive.
In this course, students will learn how to work with Google Sheets effectively. They will learn how to create and edit a sheet, how to format their spreadsheets and modify columns and rows, get familiar with functions and formulas, work with data, and learn how to sort, format, and filter their data and how to work collaboratively with other users. Also, students will learn about using charts, pictures, and drawings and how to print and share their spreadsheets.

Learning outcomes

  • Learn about the Google Sheets app and its uses
  • Learn how to create and edit a sheet
  • Learn how to edit and format a spreadsheet
  • Learn how to modify columns and rows
  • Get familiar with using functions and formulas
  • Learn how to work with data
  • Learn how to sort, filter, or format data
  • Learn how to create and edit charts
  • Learn how to print a spreadsheet
  • Get familiar with using pictures and drawing
  • Get familiar with settings and different tools

Table of contents

Chapter 1: Intro to Course

  • 1.1. Welcome!
  • 1.2. About TechClass Office Product...
  • 1.3. Learning Outcomes
  • 1.4. Your Expectations, Goals, and Knowledge
  • 1.5. Abbreviations
  • 1.6. Copyright Notice

Chapter 2: Introduction

  • 2.1. What is Google Sheets?
  • 2.2. What Can You Do with Sheets?

Chapter 3: Get Started with Google Sheets

  • 3.1. Sign in and Launch Google Sheets
  • 3.2. Google Sheets Interface
  • 3.3. Access Sheets from Google Drive
  • 3.4. Use Help
  • 3.5. Quiz

Chapter 4: Create and Edit a Document

  • 4.1. Create and Name a New Spreadsheet
  • 4.2. Insert, Rename and Delete Sheets
  • 4.3. Enter Constant Values and Use Autofill
  • 4.4. Select and Modify Cell Contents
  • 4.5. Open and Download a Spreadsheet
  • 4.6. Cut, Copy, and Paste Data
  • 4.7. Undo and Redo
  • 4.8. Check Spelling
  • 4.9. Find and Replace
  • 4.10. Publish Sheets
  • 4.11. Share and Collaborate on a Spreadsheet
  • 4.12. Quiz

Chapter 5: Edit and Format a Spreadsheet

  • 5.1. Change Data Format
  • 5.2. Change Cell Borders
  • 5.3. Alignment and Resize
  • 5.4. Format Numbers
  • 5.5. Change the Theme and Use Conditional Formatting
  • 5.6. Quiz

Chapter 6: Modify Columns and Rows

  • 6.1. Insert and Delete Columns or Rows
  • 6.2. Move and Resize Columns or Rows
  • 6.3. Group Columns or Rows
  • 6.4. Freeze and Unfreeze Columns or Rows
  • 6.5. Protect and Hide Sheets
  • 6.6. Edit Sheets
  • 6.7. Quiz

Chapter 7: Use Functions and Formulas

  • 7.1. Google Sheets Formulas
  • 7.2. Add Formulas
  • 7.3. Use the SUM and Average Function
  • 7.4. Use Common Functions
  • 7.5. Quiz

Chapter 8: Work with Data

  • 8.1. Create and Use Pivot Tables
  • 8.2. Reference Data from Other Sheets
  • 8.3. Import Data Sets and Spreadsheets
  • 8.4. Automatically Create a Series or List
  • 8.5. Name a Range of Cells
  • 8.6. Quiz

Chapter 9: Sort, Filter, or Format Data

  • 9.1. Sort and Filter Your Data
  • 9.2. Create an in-cell Dropdown List
  • 9.3. Add and Use Checkboxes

Chapter 10: Create and Edit Charts

  • 10.1. Add and Edit a Chart or Graph
  • 10.2. Types of Charts and Graphs
  • 10.3. Add and Edit a Trendline
  • 10.4. Add Data Labels, Notes, or ErrorBars to a Chart
  • 10.5. Edit Your Chart's Axes
  • 10.6. Save or Publish Your Chart
  • 10.7. Quiz

Chapter 11: Print a Spreadsheet

  • 11.1. Preview and Print a Sheet
  • 11.2. Print Settings
  • 11.3. Quiz

Chapter 12: Work with Pictures and Drawing

  • 12.1. Insert an Image
  • 12.2. Create and Edit a Drawing
  • 12.3. Quiz

Chapter 13: Settings and Tools

  • 13.1. Set a Spreadsheet’s Location and Calculation Settings
  • 13.2. Use Google Products Side by Side
  • 13.3. Automate Tasks
  • 13.4. Turn on Notifications in a Spreadsheet
  • 13.5. Use Smart Fill in Sheets to Automate Data Entry
  • 13.6. Add-ons

Chapter 14: Final Tasks

  • 14.1.Final Project


Study Options

At TechClass, we understand that every learner is unique. That's why we offer two flexible and engaging learning paths to cater to your individual needs and preferences.

TechClass is dedicated to pushing the boundaries of online education. We started TechClass by making our students believe in “Learning Smartly”.

Self-Paced Learning: The Power to Learn at Your Own Pace

Our Self-Paced Learning option puts you in complete control of your educational experience. Gain access to a wealth of carefully curated digital resources, including interactive videos, quizzes, and assignments that you can study at your convenience. This approach empowers you to balance your personal, professional, and educational life seamlessly, progressing at a pace that aligns with your goals and commitments. Take charge of your learning and achieve mastery on your terms.

Learn more

Blended Learning: The Best of Both Worlds

Experience the perfect blend of online and in-person learning with our Blended Learning workshops. This approach combines the flexibility of self-paced study with the dynamic engagement of instructor-led workshops. Dive into our comprehensive digital resources and then enhance your understanding by attending interactive workshops led by industry experts. Benefit from real-time feedback, group discussions, and hands-on activities to solidify your knowledge and develop essential skills. Our Blended Learning path fosters collaboration, cultivates critical thinking, and offers a rich learning experience tailored to your success.

Learn more

Training Support


Training Certificate

Upon completing this training path, you will receive a certification from TechClass that recognizes your expertise and knowledge in your field. With this certification, you can demonstrate your skills and knowledge to employers, clients, and peers, and take your career to the next level.

Our Clients