This class is typically ideal for someone that has taken the Google Sheets Introduction class or someone that has used Google Sheets for a long-time without any formal training. Students who have used Google Sheets for years are quite often surprised after taking this class on how much Google Sheets they did not actually know and/or how there are much more efficient ways to accomplish their business tasks in Google Sheets. This class is primarily focused on formulas, functions and pivot tables.

For the best results, participants should be familiar with the topics covered in the Google Sheets Introduction class.

• Tables Overview
• Table Structured Cell References
• Table Styles
• Table Options
• Table Slicers
• Converting Tables to Ranges
• Removing Duplicate Rows

• Range Names Overview
• Navigating Range Names
• Creating Range Names
• Assigning Range Names
• Using Range Names in Formulas
• Managing Range Names

• Functions Overview
• Functions vs Formulas
• Why use Functions?

• NOW Function
• TODAY Function
• YEAR Function
• MONTH Function
• DATE Function
• DAYS Function

• SUM Function
• AVERAGE Function
• MIN Function
• MAX Function
• MEDIAN Function
• COUNT Function
• COUNTA Function
• COUNTBLANK Function

• CONCAT Function
• PROPER Function
• UPPER Function
• LOWER Function
• LEFT Function
• RIGHT Function
• MID Function
• TRIM Function
• LEN Function
• FIND Function
• SUBSTITUTE Function
• TEXTBEFORE Function
• TEXTAFTER Function
• TEXTJOIN Function
• TEXTSPLIT Function