Google Sheets: Your Data Analysis Assistant

Google Sheets: Your Data Analysis Assistant

R250.00 includes VAT

Google Sheets is a powerful tool for visualising and analysing data. So often we shy away from spreadsheets when actually we need to embrace them as they can truly help you in so many different ways.

In this course we cover formatting in Google Sheets, a range of need to know formulas, importing and linking in data, conditional formatting, filters and filter views, visualising data with charts, working with images, pivot tables, validating data, data validation, the explore tool and protected sheets and ranges.

By the end of the course you will have a thorough understanding of Google Sheets and be able to use it with confidence. 

More about this course

Access custom video tutorials

Throughout the course you will be shown how to use these tools through video material. This includes

13 videos

1 hour 5 minutes worth of content

GIFS & Screenshots to show further explanation

As you work through the course, you will be guided by various screenshot guides as well as GIFS to showcase the features being discussed. 

Activities to practise

You will be have practical activities that you can complete in order to reinforce the skills being taught throughout the course. 

We understand that you learn best by doing.

Course Certificate

At the end of the course, there is a quiz that you can complete. This is set up to help you check your knowledge and ensure you are truly a Google Drive Master. 

Once you complete the quiz with 80%, you will be issued a course certificate to showcase your newfound skills. 

What You Need to Complete the Course

Google Sheets is an online browser based data capturing and analysis spreadsheet tool. Although it does work offline, you will need the following to engage with this course: 

  • An internet connection 
  • Google Account (this can be your Gmail account as you have access to Sheets from there)
  • Device such as a laptop or a desktop
  • An eagerness to learn and become a Google Sheets Master

Refunds are available within 7 days of registering for a course only if 20% or less of the course has been completed.

Course Content

Introduction: Why Google Sheets?
  • Cloud Storage 
  • Live Collaboration
  • Version History 
  • Templates
  • Easy Data Visualization
Sheet Fundamentals
  • Getting started with Google Sheets
  • Formatting Fundamentals In Google Sheets 
  • Navigation Check In
Functional Formulas in Sheets
  • Formulas you should know 
  • Formulas to take things further
Fetch Data from other Locations
  • Import Formulas
  • Functional Formulas Understanding
See your Data in New Ways
  • Automatically Highlight information with Conditions
See certain data with Filters
  • Visualising data with filters & filter views
Chart your data efficiently
  • See certain data with Filters
Adding images to your data
  • Working with images in Google Sheets
Pivoting your Data
  • Interpreting data with Pivot Tables
Make it easy to Validate information
  • Validating Data in Google Sheets
Exploring your Data
  • The explore tool and Macro recording
Sharing with Others
  • Sharing from Google Drive
Keeping your Team in the Loop
  • Commenting and Fostering Collaboration
  • Version History in Google Workspace
Protecting Data from Changes
  • Protecting Data from changes
Are you a Google Master?