Google Sheets: Advanced Topics

Offered By: LinkedIn Learning

Tags

Data Analysis Courses Data Visualization Courses Google Sheets Courses Data Validation Courses

Course Description

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!

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

Related Courses

Rails with Active Record and Action Pack
Johns Hopkins University via Coursera Excel Skills for Business: Intermediate II
Macquarie University via Coursera Programming 103: Saving and Structuring Data
Raspberry Pi Foundation via FutureLearn Everyday Excel, Part 1
University of Colorado Boulder via Coursera Creating Dashboards in Google Spreadsheets
Coursera Project Network via Coursera