Menu
Insights Training
  • Home
  • Webinars
  • Public Schedules
  • Course List
  • Clients / Class Pictures
    • 2019 Class Pics/ Clients
    • 2018 Class Pics / Clients
    • 2017 Class Pics / Clients
  • Testimonials
  • Self-Paced
  • Convert Courses to Online
  • Request for Proposal
  • Insights Online
  • Take an Assessment
  • Laptops for Rent
  • Blog
  • Contact Us
  • OTHER SERVICES
  • Privacy Policy
  • DBSC Upload
  • Upload_infinitovba032021
  • upload_asurion
  • Upload Excel Public Class
  • Home
  • Webinars
  • Public Schedules
  • Course List
  • Clients / Class Pictures
    • 2019 Class Pics/ Clients
    • 2018 Class Pics / Clients
    • 2017 Class Pics / Clients
  • Testimonials
  • Self-Paced
  • Convert Courses to Online
  • Request for Proposal
  • Insights Online
  • Take an Assessment
  • Laptops for Rent
  • Blog
  • Contact Us
  • OTHER SERVICES
  • Privacy Policy
  • DBSC Upload
  • Upload_infinitovba032021
  • upload_asurion
  • Upload Excel Public Class

Advanced Google Sheets Training
​(1 Day Compressed)

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.

Submit
Powered by Create your own unique website with customizable templates.