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

Comprehensive Advanced Google Sheets

inquire@insightsmanila.com
​0977.103.1800

Advanced Google Sheets Training

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

Join a public class


    We get booked fast.  Request a quote now.

Submit

Home

Courses

Public Classes

Contact

Copyright © 2022