Google Sheets: Advanced Topics

Focused View

Google Cloud

46:49

137 View

01 - Introduction

01 - Course introduction.mp4

02:26

02 - Agenda.mp4

01:17

02 - 1. Advanced Formatting in a Google Sheet

01 - Advanced formatting in a Google Sheet.mp4

01:53

02 - Conditional formatting.mp4

01:48

03 - Activity 1 explained.mp4

00:12

03 - 2. Advanced Formulas and Functions

01 - Advanced formulas and functions.mp4

02:45

02 - Using IF and IFS to analyze data.mp4

04:07

03 - Activity 2 explained.mp4

00:10

04 - Data validation and named ranges.mp4

03:25

05 - Activity 3 explained.mp4

00:11

04 - 3. Analyze and Report

01 - Analyze and report.mp4

01:17

02 - Exploring charts.mp4

02:49

03 - Activity 4 explained.mp4

00:06

04 - Pivot tables.mp4

00:47

05 - Create a pivot table.mp4

03:37

06 - Activity 5 explained.mp4

00:08

07 - Integration and publishing in Google Sheets.mp4

03:54

08 - Activity 6 explained.mp4

00:08

09 - Macros.mp4

02:35

10 - Apply a macro.mp4

01:16

05 - 4. Populate Data Using a Google Form

01 - Populate data using a Google Form.mp4

03:47

02 - Activity 7 explained.mp4

00:05

03 - Form settings and sharing a Google Form.mp4

03:39

04 - Activity 8 explained.mp4

00:12

05 - Managing feedback.mp4

01:25

06 - 5. Business Challenge

01 - Business challenge overview.mp4

01:25

02 - Business challenge explained.mp4

00:02

03 - Wrap-up.mp4

01:23

Description

Take your skills to the next level with Google Sheets. In this course, continue to develop your data analytics capabilities, building on the lessons learned in the previous course Introduction to Google Sheets.

Learn how to apply and customize themes and a wide variety of conditional formatting options before getting started with advanced formulas and functions. Get an overview of how to reference and validate your data in a Google Sheet, which holds millions of numbers, formulas, and text. Find out how to make your data more accessible to nontechnical stakeholders using charts and pivot tables as well as other data visualization options built into the app. Along the way, discover how easy it is to integrate Google Sheets with Google Forms to create and collect data from online surveys for quick analysis. Test out your new skills with Sheets and Forms in the hands-on business challenge offered at the end of the course.

Note: This course was created by Google. We are pleased to host this training in our library.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Office Productivity

Google Sheets

Google Cloud

Instructor's Courses

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.