Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Google Sheets: Advanced Topics

via LinkedIn Learning

Go to class Write review

Details

Provider

LinkedIn Learning
Pricing

Free Trial Available
Languages

English
Certificate

Certificate Available
Duration & workload

47 minutes
Sessions

On-Demand
Level

Intermediate

Found in

Part of

Google Workspace

Corporate Finance Institute

Get 35% Off CFI Certifications - Code CFI35

Datacamp

Power BI Fundamentals - Create visualizations and dashboards from scratch

Overview

Coursera Flash Sale

40% Off Coursera Plus for 3 Months!

Upskill your data analytics and visualization capabilities in this advanced skills course for the online spreadsheet app Google Sheets.

Syllabus

Introduction

Course introduction
Agenda

1. Advanced Formatting in a Google Sheet

Advanced formatting in a Google Sheet
Conditional formatting
Activity 1 explained

2. Advanced Formulas and Functions

Advanced formulas and functions
Using IF and IFS to analyze data
Activity 2 explained
Data validation and named ranges
Activity 3 explained

3. Analyze and Report

Analyze and report
Exploring charts
Activity 4 explained
Pivot tables
Create a pivot table
Activity 5 explained
Integration and publishing in Google Sheets
Activity 6 explained
Macros
Apply a macro

4. Populate Data Using a Google Form

Populate data using a Google Form
Activity 7 explained
Form settings and sharing a Google Form
Activity 8 explained
Managing feedback

5. Business Challenge

Business challenge overview
Business challenge explained
Wrap-up

Taught by

Google Cloud

Reviews

4.7 rating at LinkedIn Learning based on 263 ratings

Start your review of Google Sheets: Advanced Topics