This training includes a thorough discussion of the advanced topics.  Participants will be exposed to various practical and complicated scenarios.  A special consideration is given to Financial personnel who works with various worksheets to present different financial models.

Part 1.  Advanced Google Sheets Functions

• Text Functions
  • Combining Texts
  • Changing Case
  • Other Accessory Text Functions
• Logical Functions
  • Basic IF Statements
  • Nested and Series IF Statements
• Math Functions
  • Basic Math Functions
  • Named Ranges
  • Conditional Math Functions
  • Shortening Long Formulas with Arrays
• Lookup Functions
  • VLOOKUP
  • Advanced Usage of VLOOKUP
  • INDEX and MATCH
• Functions Unique to Google Sheets
  • Text and Math Functions
  • Filter Function
  • Parser Functions
  • Google Functions​

 Part 2.  Data Management Tools

• Conditional Formatting
  • Basic Conditional Formatting
  • Formula-Based Format
• Data Validation
  • Basic Dropdown Menus and Cell Validations
  • Advanced Dropdown Menus

Part 3. PivotTables

Part 4.  Google Collaboration Tools