Last updated 3/2022MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHzLanguage: English | Size: 2.24 GB | Duration: 2h 20m

Learn the advanced fundamentals of Google Sheets

What you'll learn
How to Use Logical Statements
Lookup Functions
Date & Text Functions
How to Link SpreadSheets and Sheet Files
Work with Range Names
Create Pivot Tables
Work with Macros and Scripts
Conditional Formatting
Inserting Graphics
Creating Forms
Requirements
Google Sheets Bner or equivalent experience.

Section 1: Introduction

Lecture 1 Introduction

Section 2: Linking and Protecting Data

Lecture 2 Importing Data

Lecture 3 Linking Sheets

Lecture 4 Linking to Another Spreadsheet

Lecture 5 Protecting Sheets and Ranges

Lecture 6 Working with Versions

Lecture 7 Reviewing Accessibility Settings

Section 3: Working with Range Names

Lecture 8 What are Range Names

Lecture 9 Creating Range Names

Lecture 10 Using Range Names in Formulas

Section 4: Analyzing Data with Logical Functions

Lecture 11 Understanding Logical Functions

Lecture 12 Using Logical Statements

Lecture 13 Using AND and OR Functions

Lecture 14 Working with Nested IF Statements

Lecture 15 Using SUMIF, AVERAGEIF, COUNTIF, and More

Lecture 16 Using the IFERROR Function

Section 5: Working with Lookup Functions

Lecture 17 Understanding Lookup Functions

Lecture 18 Using VLOOKUP

Lecture 19 Using HLOOKUP

Lecture 20 Using INDEX and MATCH

Lecture 21 Comparing Two Lists with VLOOKUP and IFERROR

Section 6: Working with Text Functions

Lecture 22 Using CONCAT, CONCATENATE, and TEXTJOIN

Lecture 23 Splitting Text to Columns

Lecture 24 Using LEFT, RIGHT, and MID Functions

Lecture 25 Using UPPER, LOWER, and PROPER Functions

Lecture 26 Using the LEN Function

Lecture 27 Removing Duplicates and Trimming White Space

Section 7: Working with Date Functions

Lecture 28 Understanding Date Functions

Lecture 29 Using TODAY, NOW, and DAY Functions

Lecture 30 Calculating YEARFRAC and NETWORKDAYS

Section 8: Working with Data

Lecture 31 Using Data Validation

Lecture 32 Adding Conditional Formatting

Lecture 33 Grouping and Ungrouping Data

Section 9: Understanding PivotTables

Lecture 34 What is a PivotTable

Lecture 35 Creating a PivotTable

Lecture 36 Working with PivotTables

Lecture 37 Creating a Chart from a PivotTable

Lecture 38 Filter Charts and Tables with Slicers

Section 10: Introduction to Macros and Scripts

Lecture 39 What are Macros

Lecture 40 Creating a Macro

Lecture 41 Working with Scripts

Section 11: Working with Forms

Lecture 42 Creating a Form

Lecture 43 Working with Forms

Lecture 44 Sending a Form

Section 12: Conclusion

Lecture 45 Course Recap

Section 13: Assessment Quiz

Anyone who wishes to learn the advanced functions of Google Sheets.

HomePage:

https://www.udemy.com/course/google-sheets-advanced/