This one-day Google Sheets Formulas and Functions class will show you some of the amazing things that Google Sheets can do. While Google Sheets is easy to use at an introductory level, it also has significant power to do more complex things. Covered in this class are advanced features and functions for conditional processing (IF statements and conditional functions), dealing with text, working with date fields and much more! You will be amazed by all of the advanced features that you never knew were available in Google Sheets.
Who Should Attend: The class is for Google Sheets Power Users
Note: Before taking this class, we recommend that you have experience creating spreadsheets in Google Sheets or have taken our Introduction to Google Sheets Introduction class.
Course Outline
Working with Sheets and Spreadsheets:
- Viewing, Renaming, and Color-Coding Sheets
- Manipulating Sheets
- Creating Linked Formulas Between Sheets
- Using Snap to View Multiple Spreadsheets
- Using IMPORTRANGE
Understanding Functions:
- Using Absolute Cell References
- Creating and Using Named Ranges
- Working with Functions
- Working with the Google Sheets Functions List
Working with Additional Functions:
- Using Statistical Functions
- Using Math Functions
- Using Financial Functions
- Using Date Functions
- Using Filter Functions
- Using Text Functions
Working with Logical 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
Working with Lookup and Reference Functions:
- Using HLOOKUP and VLOOKUP Functions
- Using the MATCH Function
- Using the INDEX Function
- Nesting the INDEX and MATCH Functions
- Using an INDEX MATCH MATCH Formula
- Using an INDEX MATCH & MATCH Formula
