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

Social Network Analysis
University of Michigan via Coursera Intro to Algorithms
Udacity Data Analysis
Johns Hopkins University via Coursera Computing for Data Analysis
Johns Hopkins University via Coursera Health in Numbers: Quantitative Methods in Clinical & Public Health Research
Harvard University via edX