Google Sheets Training Course

Google Sheets Training when you need it

Google Sheets is an online spreadsheet application that used to create and format spreadsheets and simultaneously work with other people. Google Sheets is used every day by businesses to manage spreadsheet data. Data is inserted into individual cells in rows or columns, which are then used for various calculations using formulas.

Sorting, filtering and many other data related tasks are performed with Google Sheets. Data can be analysed and displayed using charts to create business reports and sales material.

Discuss your needs. (03) 9999 7780

Want training on your site? We travel to you.

Training delivered right to your office on a day that works best for your team.

Get fully interactive, hands-on experience.

Professional instruction, lots of practice time, and solutions for your Google Sheets concerns.

We have everything you need to succeed.

Fill out our free assessment and we will determine the right course content for your team.

No Computer?
No problem, use ours.

If you’re short on computers, we will gladly supply a laptop for each person.

Custom Computer Training Course- Build Your Own Course

Build your own custom course

Any of our courses can be tailored to the unique requirements of your team. Our Off the Shelf courses are modularised with this option in mind, which means that you could mix and match from a selection of existing topics, or we can work with you to develop something specific to your organisation. Either way, we are on hand for advice on the best way to structure your customised training course.

To help you with your customised option, you can choose from our extensive list of course topics. We can then help you to assign the appropriate amount of content based on your training timeframe, and the best order of topics to ensure your training flows well. Our aim is to help every participant gain valuable knowledge and skills.

Google Sheets

Standard 1 Day Google Sheets Courses

Comprehensive training manual with exercise files. Lifetime post-course support.
Pricing
from: $480 / per participant.

Google Sheets Introduction

Learn the fundamentals of Google Sheets by building workbooks and creating formulas, then applying formatting and preparing for print.

Google Sheets Intermediate

Complement your existing skills by adding conditional formatting,
IF functions and Lookup Functions,
as well as filtering data.

Google Sheets Introduction

Overview

Participants on this Google Sheets Introduction 1 day course will gain an understanding of the fundamentals of Google Sheets, including creating and managing workbooks, using simple formulas, before moving on to formatting workbooks for presentation and printing. You will receive a solid foundation of skills upon which to build.

The course assumes no prior knowledge of Google Sheets, however, people with limited exposure to the software and those who are currently using spreadsheets created by others will also benefit from attending this course.

Call us on (03) 9999 7780 to discuss your invoice requirements, such as a Purchase Order Number or information about our Public Liability and Professional Indemnity insurance.

Reviews

Training was very well set out and informative. Exactly what I wanted and needed for my position in the company.

W. Tan

Upcoming Courses

Course Details

  • Skill Level: Beginner
  • Duration: One Day
  • Time: 9am-4pm (approx)
  • Class Size: 10 Students (max)
ratings 4.8

Course Instructors

Course Content

Google Sheets Orientation

  • Introduction to Google Sheets
  • The Google Sheets Interface
  • Worksheet Tabs
  • Understanding Cells and Content
  • Freezing Rows & Columns
  • How to Save a Google Sheet
  • Using Help

Basic Workbook Techniques

  • Create a New Google Sheet
  • Name the Spreadsheet
  • Editing Data Methods
  • Selecting Cells and Range
  • Modifying Columns, Rows & Cells
  • Insert, Delete and Moving Rows & Columns

Using Formulas in Google Sheets

  • Formulas
  • The Order of Operations
  • Functions vs Formulas
  • SUM Function
  • Functions Button Options
  • Using the Fill Handle
  • Using the Fill Handle to Continue a Series

Managing Worksheets

  • Copy and Paste Cells
  • Working with Multiple Sheets
  • Using Multiple Sheets
  • Naming Worksheets

Formatting Efficiently

  • Overview of Formatting
  • Formatting Cells
  • Cell Borders and Background Colours
  • Number Formats
  • Date Formats
  • Increasing and Decreasing Decimals
  • Using the Paint Format Command
  • Sheet Tab Colour

Preparing to Print

  • Print Previewing

Google Sheets Intermediate

Overview

Students on this Google Sheets Intermediate 1 day course will build on their existing skills to gain a deeper understanding of Google Sheets analysis by exploring IF functions and Lookup formulas. You will also explore conditional formatting to enhance visual representation of data as well as tips and shortcuts to help you save time in your daily tasks.

This course is designed for participants who already have a good understanding of the fundamentals of Google Sheets and wish to progress to the next level.

Call us on (03) 9999 7780 to discuss your invoice requirements, such as a Purchase Order Number or information about our Public Liability and Professional Indemnity insurance.

Reviews

Brendon was very knowledgeable and answered questions sufficiently.
He took the time to ensure the course content was understood by all.

B. Wharton

Upcoming Courses

Course Details

  • Skill Level: Intermediate
  • Duration: One Day
  • Time: 9am-4pm (approx)
  • Class Size: 10 Students (max)
ratings 4.9

Course Instructors

Course Content

Cell Referencing

  • What are Relative and Absolute References?
  • Relative References
  • Absolute References

Choose Function

  • Using the Choose Function

Conditional Formatting

  • About Conditional Formatting
  • Applying Conditional Formatting
  • Modifying Formatting
  • Using Colour Scale
  • Finding and Clearing Formats

IF Functions

  • Logical Functions
  • Using True and False
  • Using Comparison Operators

Lookup Functions

  • Using Lookup Functions
  • VLookup
  • HLookup

Index and Match Functions

  • Using Index
  • Using Match
  • Using Index and Match Together

Nested IF Functions

  • Logical Functions

Linking between Worksheets

  • Working with Multiple Worksheets
  • Building Formulas across worksheets
  • Using the IMPORTRANGE function

Sorting and Filtering Data

  • Sorting Sheet Data
  • Sort Ranges
  • Filtering Data

Frequently Asked Questions

What is Google Sheets?

Google Sheets is an online spreadsheet application used to store, organise and manipulate your numerical data. You open it in your web browser, but you have all the functionality of a full spreadsheet application for doing powerful data analysis.

The column and row interface provides a simple but powerful structure for storing and working with numbers, text, and dates. Various tasks can be performed with data, along with charts to visually portray your results. Just like Excel, Google Sheets has tools and functions to allow you to calculate and manipulate your data.

Understanding how to work efficiently with Google Sheets is a great skill to have in any business or organisation.

Who uses Google Sheets?

Just about anyone who uses a computer may have a use for spreadsheets. Google Sheets has a great range of tools that can be used for many different tasks. Some common uses for Google Sheets are:

  • Sorting and Filtering Lists
  • Creating Charts
  • Budgeting
  • Statistical Analysis
  • Summarising Data

These are just a few ways to use Google Sheets, but there are many more. Google Sheets has a place in just about any business role you can think of, from Business Analysis to Sales Summaries, Attendance Tracking to KPI Reporting. Skills you learn in Google Sheets are transferable, so you can continue to use and build on them as you progress through your career.

What’s better, Google Sheets for Dummies or a training course?

Have you ever wondered why the Google Sheets for Dummies books are so popular? After all, you didn’t get this far in your career by being a dummy, did you? Well, mostly it’s because many of us are self-taught, searching online to find out how to use a function, or asking a workmate how to use Google Sheets. Although this can be helpful, it also means we spend a lot of time on trial and error, or we are just picking up somebody else’s bad habits. These habits then spread further across an organisation, so that you might see an entire department working on inefficient, poorly constructed worksheets.

At this point, you might head to the bookstore or do an online search to find a Google Sheets for Dummies book to help with those tricky problems. That’s a step in the right direction, we use reference manuals ourselves. The problem is that it still takes time to find the information you need.

Our Google Sheets courses are designed to show you the key features and tools you need so you can get back to work and apply them right away.

Why should I attend a Google Sheets Training Course?

Attending a Google Sheets course with Keystroke Learning will show you how to use the most efficient methods to achieve your daily tasks. Not only that, but you will discover best practices and shortcuts to make your business tasks even quicker, so you can get on with your day. Our goal is to help you get to the point where you are focussed on the task at hand rather than the tool you are using.

Typically, one of our experienced trainers will walk you through the features and functions of the software, then you will try them out on your own, with tips and guidance on getting the best out of the features. We also encourage participants to ask lots of questions to help you maximise your learning experience.

You’ll receive a manual to take away at the end of the course, as well as exercise files so you can practice later, or just to jog your memory when you need.

How do I name my worksheet?

If you have a look at the top left corner of your screen you will see the words “Untitled spreadsheet”. Click in this section and type in whatever name you want to give your Sheet, for example “Profit and Loss Analysis”.

My worksheet has some formatting I need to remove, is there a quick method?

You bet! Just select the cell or range you want to clean up, then on the keyboard, use Ctrl + /. (Control Key + Forward Slash). This will quickly remove any unwanted formatting, so you can apply fresh formatting if you want.

I need to edit a sheet with a colleague in a different office, can I do it?

One of the strengths of Google Sheets is collaboration. You can open your worksheet, share it and you and your colleague (or colleagues) can be up and editing in no time. Not only that, but you can chat and give feedback in real time using comments (located at the top right of the screen). Google Sheets will also automatically keep track of the changes with version history in case you need to dial it back.

Where to from here?

Your learning shouldn’t stop once you have completed your course. We encourage you to continue your experience by taking some time to practice what you have learned and applying it to your own situation and environment.

If we have done our job well, you may be inspired to learn even more by attending further courses with us. If you are looking for something other than Google Sheets, we have a comprehensive range of courses available for you to choose from.

We are here to help, so please don’t hesitate to contact us if you need any further advice.

Keystroke Learning

Learn Today with Keystroke Learning

As you can see, we have a wide array of top computer courses. Out training approach is professional yet friendly, motivating participants to learn quickly and easily. When you complete our training, you will be ready to apply your new skills right away. Course prices are listed on the Upcoming Courses page alongside the relevant course.

If you have a customised training solution in mind, please call us for a quote.

To schedule our popular computer courses, call (03) 9999 7780 or email us @ [email protected]