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