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

Making Sense of Data
Google via Independent Introduction to Spreadsheets and Models
University of Pennsylvania via Coursera Comptabilité de gestion et pratique du tableur
Université Montpellier 2 via France Université Numerique The Power of Data in Health and Social Care
University of Strathclyde via FutureLearn Digital Media Analytics: Introduction
Purdue University via FutureLearn