Google Sheets - Advanced 2022

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 Beginner or equivalent experience.
Description
Overview
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/

Google Sheets - Advanced 2022 Fast Download
Google Sheets - Advanced 2022 Full Download