Google Sheets - Advanced

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. Email info@intellezy.com 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.