Google Sheets Introduction

Ready to unlock the power of spreadsheets in the cloud? Welcome to our “Google Sheets Introduction” course, where we’ll transform you from spreadsheet skeptic to data dynamo!

Ever stared at rows and columns wondering how to make sense of it all, or wished you could create formulas that actually work? Maybe you’ve been using spreadsheets created by others but want to build your own? Well, get ready to discover just how friendly and powerful spreadsheets can be!

We’ll take you from “what’s a cell?” to “watch me calculate this!” Whether you’re completely new to spreadsheets or have been exploring Google Sheets on your own, this course will teach you everything from basic calculations to formatting that makes your data look great.

By the end of the day, you’ll be wondering why spreadsheets ever seemed intimidating, and you’ll be ready to tackle your data challenges with confidence!

Google Sheets Introduction

Welcome to the “Google Sheets Introduction” course, a comprehensive one day workshop that transforms complete beginners into confident spreadsheet users through mastery of essential skills in data management, calculation, and formatting. This foundational course demystifies spreadsheet basics and empowers you to create, organise, and analyse data effectively in the cloud, taking you from basic cell operations to creating functional, professional looking spreadsheets that can tackle real world data challenges.

What You'll Get With This Course

Live Instructor-Led Training

Highly experienced and approachable trainers

Guaranteed to Run Courses

Book with confidence, guaranteed to go ahead

Outrageous Money Back Guarantee

Not satisfied? If we can’t fix it, get a refund

FREE Repeat Option

Retake within 6 months at no cost

Small Classes

No more than 6 people per class

Comprehensive Materials

PDF manual and training files included!

eCertificate of Completion

Proudly recognise your achievement

Lifetime Support

Expert help, always within reach

Google Sheets Introduction 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

*Our outlines are a guide to the content covered in a typical class.
We may change the course topics to meet the objectives of a particular class.

Prior Knowledge

This course assumes no prior knowledge of Google Sheets. It is suitable for complete beginners who want to learn how to create, edit, and manage spreadsheets effectively using Google’s cloud based spreadsheet software.

Required Software

You will need a Google account to access Google Sheets through a web browser. As Google Sheets is a web based application no software installation is required, but you will need a up-to-date web browser (Chrome, Firefox, Edge, or Safari recommended).

Course Materials

All necessary exercise files will be provided during the training session. You don’t need to prepare any materials beforehand.

Note About Different Versions

As Google Sheets is a web-based platform that’s regularly updated, you’ll always have access to the latest version. While the interface may receive updates, the core features and skills learned in this course remain consistent. Any new features will be highlighted during the training as they become available.
Is this the right course for me?
Visit our main course page to take a quick, anonymous Google Sheets skills test. You’ll discover your true proficiency level in minutes, no registration required.

Why Bring Your Own Laptop?

Training is most effective when you’re working in a familiar environment. By bringing your own laptop to our training sessions, you’ll maximise your learning experience in several important ways.

Personal Comfort and Efficiency

Working on your own laptop means you’ll be instantly familiar with your keyboard layout and system preferences. No need to spend 20 minutes figuring out why the volume button is launching the calculator instead. This familiarity allows you to focus entirely on learning new skills rather than wondering why someone set the desktop background to dancing hamsters.

Access to Your Complete Work Environment

Your laptop comes with your personal setup of applications, customised settings, and existing files. Think of it as bringing your digital home with you, minus the dirty dishes in the sink. This means you can immediately apply what you learn to your real work documents and seamlessly integrate new skills into your daily workflow.

Practical Setup

During the training, you’ll enjoy the best of both worlds, your personal laptop connected to our professional training setup. Each workspace is equipped with a 27-inch monitor (perfect for those who squint at their phones even with reading glasses), full-size USB-A keyboard, and USB-A mouse.

Software Accessibility

With your own laptop, you’ll have immediate access to your licensed software and saved preferences. This is particularly important for applications where having your existing login credentials readily available ensures a smooth training experience. No need to remember that complex password you created after your third coffee of the day.

Don’t Have A Laptop?

Bring Your Enthusiasm!

We provide the coffee and biscuits, but your enthusiasm is the one program we can’t install for you. Don’t worry, our trainers are experts at generating enough energy to power a small city!
Brendon Farrell Co Founder Facilitator Keystroke Learning

Brendon Farrell

Co-Founder / Facilitator

From my early days wrestling with DOS commands to navigating today’s cloud-based world, I’ve dedicated my career to demystifying technology for others.

As a certified Microsoft and eLearning specialist, there’s nothing I enjoy more than seeing that spark of understanding when a student masters a new skill.

Outside of the training room, my passions run deep, whether I’m spending quality time with my wife and son, sharing my four decade love of lacrosse with junior players as their coach, or cycling around Melbourne’s on either my road bike or mountain bike.

Mark Finney Co Founder Facilitator Keystroke Learning

Mark Finney

Co-Founder / Facilitator

With a coffee in hand and a passion for problem solving in my heart, I’ve made it my mission to turn tech frustrations into success stories. Through years of hands-on experience, I understand the challenges learners face.

Being both a co-founder and trainer at Keystroke Learning lets me combine my love for teaching with creating innovative learning solutions that actually work in the real world.

When I step away from the keyboard, find me strumming my favorite tunes on guitar, relaxing with my wife watching movies on the couch, or tending to my garden.

Upcoming Public Courses

Price:  

$550.00

1 Day Training Course

Course Location & Dates

Still Need Approval?

This course is for
Group Bookings Only

Our Clients