Google Sheets Intermediate Workshop

Course Overview

Google Sheets Intermediate Workshop

Course overview

By the end of the course you will be able to create multiple sheet spreadsheets, use logical functions, sort, filter and subtotal data. You will also be able to present data in a graphical format.

Course content

What Will Be Covered?

• Working with multiple worksheets and spreadsheets
• Conditional formatting
• More formulas and functions
• Absolute referencing
• Calculating percentages
• IF functions
• More on data lists and tables
• Duplicate values
• Subtotals
• Grouping data
• Creating and modifying charts

The workshop is a very hands-on course. The content of the course will be covered by the tutor explaining a topic, then demonstrating it to you by walking you through the process, and finally this is consolidated by you performing the exercises from the manual on your own.