Google Workspace
Google Sheets - Advanced
Self-paced lessons on advanced Google Sheets: linking and protecting data, named ranges, logical, lookup, text and date functions, PivotTables, macros and forms.
2 hours 15 minAdvanced12 modules
About this course
Self-paced lessons on advanced Google Sheets: linking and protecting data, named ranges, logical, lookup, text and date functions, PivotTables, macros and forms.
Curriculum
12 modules
- Introduction
- Importing Data
- Linking Sheets
- Linking to Another Spreadsheet
- Protecting Sheets and Ranges
- Working with Versions
- Reviewing Accessibility Settings
- What are Range Names?
- Creating Range Names
- Using Range Names in Formulas
- Understanding Logical Functions
- Using Logical Statements
- Using AND and OR Functions
- Working with Nested IF Statements
- Using SUMIF, AVERAGEIF, COUNTIF, and More
- Using the IFERROR Function
- Understanding Lookup Functions
- Using VLOOKUP
- Using HLOOKUP
- Using INDEX and MATCH
- Comparing Two Lists with VLOOKUP and IFERROR
- Using CONCAT, CONCATENATE, and TEXTJOIN
- Splitting Text to Columns
- Using LEFT, RIGHT, and MID Functions
- Using UPPER, LOWER, and PROPER Functions
- Using the LEN Function
- Removing Duplicates and Trimming White Space
- Understanding Date Functions
- Using TODAY, NOW, and DAY Functions
- Calculating YEARFRAC and NETWORKDAYS
- Using Data Validation
- Adding Conditional Formatting
- Grouping and Ungrouping Data
- What is a PivotTable?
- Creating a PivotTable
- Working with PivotTables
- Creating a Chart from a PivotTable
- What are Macros?
- Creating a Macro
- Working with Scripts
- Creating a Form
- Working with Forms
- Sending a Form
- Course Recap
Who it's for
Sheets users who analyse data regularly.
Before you start
No formal prerequisites. Bring curiosity and a willingness to practise.
Related courses
More in Google Workspace →Foundation
Collaborating in Google Workspace - Beginner
Google Workspace
View course →Intermediate
Gmail - A Complete Guide
Google Workspace
View course →Intermediate
Google Chat and Meet - A Complete Guide
Google Workspace
View course →Foundation
Google Chat and Meet - Beginner
Google Workspace
View course →Foundation
Google Classroom - Beginner
Google Workspace
View course →Advanced
Google Docs - Advanced
Google Workspace
View course →Let's plan your next step together.
Tell us the course or certification you have in mind and we'll send the outline, upcoming dates, fees and private-team options.