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.
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 problem, use ours.
If you’re short on computers, we will gladly supply a laptop for each person.
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.
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
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.
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
- The Order of Operations
- Functions vs Formulas
- SUM Function
- Functions Button Options
- Using the Fill Handle
- Using the Fill Handle to Continue a Series
- Copy and Paste Cells
- Working with Multiple Sheets
- Using Multiple Sheets
- Naming Worksheets
- 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
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.
- 21 November @ 9:00 am - 4:00 pm at The Thrive Network – Melbourne
- What are Relative and Absolute References?
- Relative References
- Absolute References
Linking and 3D Formulas
- Thinking in 3 Dimensions
- Working with Multiple Worksheets
- Building 3D Formulas
- Linking with IMPORTRANGE
- Checking the References
- Breaking it up
- Check the Arguments
- Walk Through the Order of Operations
Sorting and Filtering
- Types of Sorting
- Creating Filters
- Applying Multiple Filters
- Logical Functions
- Using True and False
- Using Comparison Operators
Nested IF Functions
- Building Nested Functions
- Using the Choose Function
- Using Lookup Functions
Index and Match Functions
- Using Index
- Using Match
- Using Index and Match Together
- About Conditional Formatting
- Applying Conditional Formatting
- Colour Scale Function
Frequently Asked Questions
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.
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
- 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.
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.
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.
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”.
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.
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.
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.
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.