This training includes a thorough review of the basics and a thorough discussion of the advanced topics.  There are more exercises and participants will be exposed to various practical and complicated scenarios.

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
  • Absolute vs Relative Cell References
• Date Functions
• ​Lookup Functions
  • VLOOKUP
  • Advanced Usage of VLOOKUP
• Advanced Lookup Functions
  • INDEX
  • MATCH
• ​Functions Unique to Google Sheets
  • Text and Math Functions
  • Filter Function
  • Parser Functions
  • Google Functions

Part 2. Data Management Tools

• Text-to-Columns
  • Delimited
  • Fixed Width
• Conditional Formatting
  • Basic Conditional Formatting
  • Formula-Based Format
• Data Validation
  • Basic Dropdown Menus and Cell Validations
  • Advanced Dropdown Menus
• Security Options (Protecting Sheets)

Part 3.  Charts

• Basic Charts
• Combination Charts

Part 4.  PivotTables
​
Part 5.  Google Collaboration Tools