Google Sheets Advanced Workshop

Course Overview

Google Sheets Advanced Workshop

By the end of the course, you will be able to create sophisticated spreadsheets, which include complex functions. You will be able to validate data entries and analyse tables using pivot tables. You will also be able to automate actions using macros.

Course Content

What Will Be Covered:

• Practical Functions
• Logical Functions
• Logical IF Functions
• Statistical IF Functions
• Lookup Functions
• Text Functions
• Data Validation
• Pivot Tables
• Recording and Running Macros

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 a number of exercises from the manual on your own.