TARGET AUDIENCE

The class is for Google Sheets Power Users.

PRE-REQUISITE

Before taking this class, we recommend that you have experience creating worksheets in Google

Sheets or have taken Google Sheets class.

Viewing, Renaming, and Color-Coding Sheets

Manipulating Spreadsheets

Creating Linked Formulas

Using Snap to View Multiple Spreadsheets

Using IMPORTRANGE

Using Absolute Cell References

Creating and Using Named Ranges

Working with Functions

Working with the Google Sheets Functions List

COURSE OUTLINE ::GS Formula & Function::

Using Statistical Functions

Using Math Functions

Using Financial Functions

Using Date Functions

Using Filter Functions

Using Text Functions

Using the IF function

Using Nested Functions

Using Multiple Conditions with the IF Function

Using the IFS Function

Using the SWITCH Function

Using the IFERROR Function

Using HLOOKUP and VLOOKUP Functions

Using the MATCH Function

Using the INDEX Function

Nesting the INDEX and MATCH Functions

Using INDEX MATCH MATCH

Using INDEX MATCH & MATCH

Programme scope, delivery arrangements and suitability are confirmed during enquiry.