Google Sheets Unleashed: Skills for Power Users

This advanced Google Sheets course is designed for users who have a solid understanding of the basic functions and features of Google Sheets. Participants will delve deeper into the platform's capabilities by exploring a variety of advanced functions and techniques. The course will cover logical functions, lookup functions, array formulas, date and time functions, pivot tables, and more. 

By the end of the course, participants will be able to use Google Sheets to perform complex data analysis, create dynamic spreadsheets, and streamline their workflows.

Course Objectives
You will be able to perform complex data analysis, create dynamic spreadsheets, and streamline your workflows for enhanced productivity and efficiency. 
- Use logical functions to create complex conditional statements
- Perform efficient lookups using VLOOKUP, HLOOKUP, and XLOOKUP
- Apply array formulas to perform calculations across multiple cells
- Work with dates and times to calculate differences and perform time-based calculations
- Create and analyze pivot tables to summarize and understand data
- Use the QUERY function to extract and manipulate data
- Filter and extract unique values from data sets
- Import data from other spreadsheets using IMPORTRANGE

Course Outline

Module 1: Logical Functions
- IF function: Understanding conditional statements
- AND and OR functions: Combining multiple conditions
- IFERROR function: Handling errors gracefully
- IFS function: Creating nested IF statements

Module 2: Lookup Functions
- VLOOKUP function: Vertical lookups
- HLOOKUP function: Horizontal lookups
- XLOOKUP function: Enhanced lookup capabilities

Module 3: Array Formulas
- Understanding array formulas
- Using ARRAYFORMULA to perform calculations across multiple cells
- Common array formula applications

Module 4: Date and Time Functions
- DATE function: Creating dates
- DATEDIF function: Calculating differences between dates
- NETWORKDAYS and WORKDAY functions: Working with business days

Module 5: Pivot Tables
- Creating and customizing pivot tables
- Analyzing data using different aggregation functions
- Filtering and sorting pivot table data

Module 6: QUERY Function
- Using the QUERY function to extract and manipulate data
- Writing SQL-like queries in Google Sheets
- Filtering, sorting, and aggregating data

Module 7: FILTER and UNIQUE Functions
- Filtering data based on criteria
- Extracting unique values from a range

Module 8: IMPORTRANGE Function
- Importing data from other spreadsheets
- Combining data from multiple sources

Prerequisite: Previous experience using either Google Sheets or Microsoft Excel