Google Sheets - Managing Data Duration: 1 Day

Course Overview

Google Sheets can be used in many ways to manage dynamic data. Data may be captured by forms or imported regularly from other sources. Learn tips to work with multiple sheets and multiple data sources and how best to work smart.

Module 013: Google Sheets - Intermediate

Functions

Data Validation

Conditional Formatting

Pivots

Charts

Drawings

Useful Functions

Module 017: Google Sheets - Sharing & Forms

Google Sheets vs Excel

Add-ons

Sharing Options

Protect Sheet

Revision History

Publish to Web

Capturing Data using Forms

Notification Rules

Create a Survey & Send via Email

Create a Self-grading Quiz

Module 018: Google Sheets – Working with Data

Pivots

Image(), Hyperlink()

ArrayFormula()

Match(), Offset(), Indirect()

ImportRange()

Vlookup()

If(), And(), IfError()

Maths, Stats & Database Functions

Working with Multiple Sheets

Importing Data

Refreshing Data

This training can be tailored and combined with any of the further Google courses advertised