Google Sheets - Advanced 2022
Posted on 27 Nov 09:15 | by huayting | 6 views
Google Sheets - Advanced 2022
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/
PLEASE SUPPORT ME BY CLICK ONE OF MY LINKS IF YOU WANT BUYING OR EXTENDING YOUR ACCOUNT
https://rapidgator.net/file/4411b12f394f633c461076a80fca40e0/j6qb5G4o__Google_She.part1.rar.html
https://rapidgator.net/file/18488d4617006c9a0e15295d2c7392af/j6qb5G4o__Google_She.part2.rar.html
https://rapidgator.net/file/ca1f3ffe2cff1298577c66a53960dd8b/j6qb5G4o__Google_She.part3.rar.html
https://uploadgig.com/file/download/64f18983e0daD535/j6qb5G4o__Google_She.part1.rar
https://uploadgig.com/file/download/1994fF19912c88fe/j6qb5G4o__Google_She.part2.rar
https://uploadgig.com/file/download/fe3cD6715e61887F/j6qb5G4o__Google_She.part3.rar
Related News
System Comment
Information
Users of Visitor are not allowed to comment this publication.
Facebook Comment
Member Area
Top News