Google Sheets - Advanced 2022

0

1

2

3

4

5

Posted on 28 Nov 12:28 | by mitsumi | 12 views

Last updated 3/2022
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: 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 Beginner or equivalent experience.
Description
This course will teach students advanced concepts and formulas in Google Sheets. Students will learn to use logical statements, lookup functions, and date and text functions. Additionally, students will learn how to link spreadsheets and Sheets files, work with range names, learn the options for spreadsheet protection, create PivotTables, work with macros and scripts. Students will also learn about conditional formatting, inserting graphics, and creating Forms.With nearly 10,000 training videos available for desktop applications, technical concepts, and business skills that comprise hundreds of courses, Intellezy has many of the videos and courses you and your workforce needs to stay relevant and take your skills to the next level. Our video content is engaging and offers assessments that can be used to test knowledge levels pre and/or post course. Our training content is also frequently refreshed to keep current with changes in the software. This ensures you and your employees get the most up-to-date information and techniques for success. And, because our video development is in-house, we can adapt quickly and create custom content for a more exclusive approach to software and computer system roll-outs.Like most of our courses, closed caption subtitles are available for this course in: Arabic, English, Simplified Chinese, German, Russian, Portuguese (Brazil), Japanese, Spanish (Latin America), Hindi, and French.This course aligns with the CAP Body of Knowledge and should be approved for 2.25 recertification points under the Technology and Information Distribution content area. with proof of completion of the course to obtain your certificate.
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.