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

## 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

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

3:51
• Sharing

3:48

3:16
• Shortcuts

5:18
• Templates for Google Sheets

10:08
• Where to Get Templates

1:46
• Drawing

7:38
• Outro

0:47

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

20

Students

--

Projects