Boost Your Data Capability with a 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.
Flexible
Training
Options
Why Our
Manuals
Are Unique
Custom
Curriculum
Available
Flexible
Training
Schedule
We’ll work around you. Course times are completely negotiable but are typically
9:00am – 4:00pm.
Standard 1 day Google Sheets Courses
Standard 1 Day
Google Sheets Courses
Comprehensive training manual with exercise files. Lifetime post-course support.
Pricing from: $550 / per participant for Public courses.
Learn the fundamentals of Google Sheets by building worksheets and creating formulas, then applying formatting and preparing for print.
Public Courses
Build on your existing Google Sheets knowledge by working with IF functions and Lookup Functions, and apply filtering to data.
Public Courses
Do you need Google Sheets
Training for a Group ?
Any of our Google Sheets training 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 here for advice on the best way to structure your customised training course.
To help you with your customised Google Sheets 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 FAQ's Frequently Asked Questions
Google Sheets FAQ's
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 it.
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.
