Digital upskilling

Google Sheets, Google Slides and Google Docs are all available for use in the Google Workspace. Each of these formats can be utilised for various tasks. Google Docs can be used for longer form writing, meeting agendas and so on. Google Slides is similar to Powerpoint and should be your go to for visual presentations, while Google Sheets allows you to add and manipulate data.

All formats can be used to collaborate with your team members or external suppliers through the view, comment and edit functionality. View allows you to share a presentation without the user having permissions to edit or comment. Providing commenter access enables a user to add relevant comments at any point throughout your presentation, spreadsheet or document. Editor gives the individual with your Sheets, Docs or Slides link the opportunity to collaborate and adjust your presentation, spreadsheet or document.

To share with a user, click file > share > share with others, toggle to ‘anyone with the link’ and assign a user role.

Google Docs

• On Google Docs, you can create headings that enable you or the user to click and drop down to a specific section of the document. To do this, add in a heading and then fill out your body text as normal.

Google Slides

• Google Slides can be used to design and template presentations, as well as adding in visual and written content.
• To utilise the themes functionality and, for example, add a logo to each slide, you simply click slide > edit themes and adjust your slide as required.

Google Sheets

• Google Sheets is the perfect place to manipulate data and use formulas to quickly add, subtract and determine percentages and so much more.

Formulas

=SUM(A2:A10) allows you to add up a total from a range of cells. Simply adjust the cell numbers as needed to use this formula.

=(A2/$A$9) allows you to find a percentage. If you are working with a constant figure such as a cell range total, add the $ sign into your formula.

=COUNTIF(A2:A10, “Victoria”) allows you to count the number of times the same piece of information occurs in a range of cells.

Filter

The filter icon enables you to filter out information from a subset of data. For example, if you only want to look at individuals from Victoria, you can select this and the cells will filter for you.

Check out our short video to learn more about using Google documents.