Menu
Insights Training
  • Home
  • Webinars
  • Public Schedules
  • Course List
  • Clients / Class Pictures
    • 2017 Class Pics / Clients
    • 2018 Class Pics / Clients
    • 2019 Class Pics/ Clients
    • 2020 Class Pictures
    • 2021 Class Pics
  • Testimonials
  • Convert Courses to Online
  • Request for Proposal
  • Insights Online
  • Take an Assessment
  • Blog
  • Contact Us
  • OTHER SERVICES
  • Privacy Policy
  • Code Verifier
  • Blog
  • Refer and Earn
  • Home
  • Webinars
  • Public Schedules
  • Course List
  • Clients / Class Pictures
    • 2017 Class Pics / Clients
    • 2018 Class Pics / Clients
    • 2019 Class Pics/ Clients
    • 2020 Class Pictures
    • 2021 Class Pics
  • Testimonials
  • Convert Courses to Online
  • Request for Proposal
  • Insights Online
  • Take an Assessment
  • Blog
  • Contact Us
  • OTHER SERVICES
  • Privacy Policy
  • Code Verifier
  • Blog
  • Refer and Earn

Advanced Google Sheets Training
​(1 Day Compressed)

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
Find Public Class
Button Text

Home

Courses

Public Classes

Contact

Copyright © 2022