inquire@insightsmanila.com
​0977.103.1800

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

Join a public class

    We get booked fast.  Request a quote now.