LOOKING FOR RATES AND SCHEDULES
​TO JOIN A PUBLIC CLASS?
CLICK HERE.

NEED A PROPOSAL FOR COMPANY?
EMAIL INQUIRE@INSIGHTSMANILA.COM

This training includes a thorough discussion of the advanced topics.  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
    • 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

Related Courses

Basic Google Sheets

Advanced MS Excel