I Heart Google Sheets: Introduction to Useful Skills Employers Look For | Jon Chu | Skillshare

# I Heart Google Sheets: Introduction to Useful Skills Employers Look For

#### Jon Chu

Play Speed
• 0.5x
• 1x (Normal)
• 1.25x
• 1.5x
• 2x
43 Videos (3h 31m)
• Promo

1:23
• Intro

5:08
• Data

10:08
• Help

3:13
• File

4:27
• Insert

6:08
• Format

4:07
• Edit

3:32
• Tools

3:46
• View

5:34
• Toolbar Overview

4:52
• Forms

8:16
• Menu Summary

5:32
• And Or

4:47
• Basic Functions Overview

3:23
• Basic Math

4:28
• Average

1:35
• Concatenate and Ambersand

3:41
• Count

1:57
• If

3:33
• LenFindLeftMidRiight

7:30
• Min Max

1:12
• Sumifs

5:20
• Rounding

2:47
• Pivot

7:30
• Vlookup and Hlookup

7:19
• Index

6:18
• Match

6:01
• Automatic Charts

10:12
• Manual Charts

10:25
• Anchoring

8:40
• Business & Statistics Functions Overview

2:58
• Autofill

1:54
• Borders

2:11
• Conditional Formatting

4:18
• Navigation Keys

3:51
• Sharing

3:48
• Comments

3:16
• Shortcuts

5:18
• Templates for Google Sheets

10:08
• Where to Get Templates

1:46
• Drawing

7:38
• Outro

0:47

## About This Class

In this course you will learn how to:

• Effectively and efficiently navigate around Google Sheets
• Enter and edit data in Google Sheets
• Adjust the way data and information are displayed in Google Sheets
• Write formulas quickly and easily
• Leverage data with Vlookup, Hlookup, Index, and Pivot Tables
• Use relative, absolute, and mixed references in Google Sheets
• Create powerful calculations with Google Sheets functions
• Visually represent your data with charts and graphs in Google Sheets
• Use data tools like sorting, filtering, and filter views
• Utilize freeze panes in Google Sheets
• Format worksheets in Google Sheets for impact and appeal
• Learn shortcuts, tips, and tricks
• Learn how to use commenting and sharing in Google Sheets

92

Students

--

Projects

• --
• Beginner
• Intermediate
• Advanced
• All Levels
• Beg/Int
• Int/Adv

Level

Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.

Report class