Google Sheets Formulas and Functions (Live Online)

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 UsersNote: 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 OutlineWorking with Sheets and Spreadsheets:Viewing, Renaming, and Color-Coding SheetsManipulating SheetsCreating Linked Formulas Between SheetsUsing Snap to View Multiple SpreadsheetsUsing IMPORTRANGEUnderstanding Functions:Using Absolute Cell ReferencesCreating and Using Named RangesWorking with FunctionsWorking with the Google Sheets Functions ListWorking with Additional Functions:Using Statistical FunctionsUsing Math FunctionsUsing Financial FunctionsUsing Date Functions Using Filter FunctionsUsing Text FunctionsWorking with Logical Functions:Using the IF functionUsing Nested FunctionsUsing Multiple Conditions with the IF FunctionUsing the IFS FunctionUsing the SWITCH FunctionUsing the IFERROR FunctionWorking with Lookup and Reference Functions:Using HLOOKUP and VLOOKUP FunctionsUsing the MATCH FunctionUsing the INDEX FunctionNesting the INDEX and MATCH FunctionsUsing an INDEX MATCH MATCH FormulaUsing an INDEX MATCH & MATCH Formula