Discover the impressive power and capabilities that Google Sheets provides in this advanced full-day workshop. While Google Sheets appears straightforward at an elementary level, it also offers substantial capability for sophisticated analysis and data manipulation. This intensive class covers advanced features and tools, including conditional logic (IF statements and conditional operations), text processing techniques, date field operations, and numerous additional sophisticated functions. You'll be amazed by the advanced capabilities and features available in Google Sheets that you may not have known existed.
Recommended Student Level:
This course targets intermediate to advanced Google Sheets users who want to maximize the platform's power.
Important Prerequisites:
Before enrolling, you should have practical experience building spreadsheets in Google Sheets or have completed our Introduction to Google Sheets course to develop the necessary foundational skills.
Comprehensive Course Curriculum:
Managing Multiple Sheets and Spreadsheet Organization
- Displaying, renaming, and color-coding individual sheets
- Modifying sheet organization and structure
- Establishing formulas that reference and link multiple sheets
- Using Snap features to view and work with multiple spreadsheets simultaneously
- Using IMPORTRANGE to pull data from external spreadsheets
Understanding Functions and Formula Building
- Using absolute cell references for fixed references
- Creating and applying named ranges for improved readability
- Understanding and working with functions
- Accessing the Google Sheets functions list and documentation
Exploring Additional Functions and Capabilities
- Applying statistical functions for analysis
- Using mathematical functions for calculations
- Implementing financial functions for business calculations
- Applying date functions for temporal data
- Using filter functions to work with large datasets
- Applying text functions for string manipulation
Working with Conditional and Logical Functions
- Using the IF function for conditional logic
- Creating nested functions for complex conditions
- Using multiple conditions with the IF function
- Using the IFS function for simplified multi-condition logic
- Using the SWITCH function for pattern matching
- Using the IFERROR function for error handling
Working with Lookup and Reference Functions
- Using HLOOKUP and VLOOKUP functions for data retrieval
- Using the MATCH function for position finding
- Using the INDEX function for data extraction
- Combining INDEX and MATCH functions for powerful lookups
- Creating INDEX MATCH MATCH formulas for complex queries
- Creating INDEX MATCH and MATCH formulas for multi-dimensional lookups
