Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Google Sheets - Advanced
Introduction
Introduction (1:03)
Linking and Protecting Data
Importing Data (2:22)
Linking Sheets (3:20)
Linking to Another Spreadsheet (4:36)
Protecting Sheets and Ranges (3:06)
Working with Versions (2:16)
Reviewing Accessibility Settings (1:32)
Working with Range Names
What are Range Names? (2:17)
Creating Range Names (2:12)
Using Range Names in Formulas (2:09)
Analyzing Data with Logical Functions
Understanding Logical Functions (2:25)
Using Logical Statements (3:27)
Using AND and OR Functions (3:46)
Working with Nested IF Statements (5:20)
Using SUMIF, AVERAGEIF, COUNTIF, and More (4:10)
Using the IFERROR Function (2:53)
Working with Lookup Functions
Understanding Lookup Functions (2:40)
Using VLOOKUP (7:25)
Using HLOOKUP (2:02)
Using INDEX and MATCH (7:21)
Comparing Two Lists with VLOOKUP and IFERROR (2:50)
Working with Text Functions
Using CONCAT, CONCATENATE, and TEXTJOIN (3:35)
Splitting Text to Columns (1:31)
Using LEFT, RIGHT, and MID Functions (2:27)
Using UPPER, LOWER, and PROPER Functions (3:29)
Using the LEN Function (1:54)
Removing Duplicates and Trimming White Space-v3 (2:39)
Working with Date Functions
Understanding Date Functions (1:57)
Using Today Now and Days functions (3:47)
Calculating Yearfrac and NetworkDays (3:28)
Working with Data
Using Data Validation (7:01)
Adding Conditional Formatting (5:12)
Grouping and Ungrouping Data (2:11)
Understanding PivotTables
What is A Pivot Table? (2:22)
Creating a Pivot Table (3:24)
Working with Pivot Tables (2:04)
Creating A Chart From a Pivot Table (2:58)
Filter Charts and Tables with Slicers (4:58)
Introduction to Macros and Scripts
What are Macros? (1:33)
Creating a Macro (3:14)
Working with Scripts (2:21)
Working with Forms
Creating a Form (3:46)
Working with Forms (2:34)
Sending a Form (1:21)
Conclusion
Course Recap (1:02)
Grouping and Ungrouping Data
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock