I Heart Google Sheets: Training for Skills Employers Want

Comprehensive Beginner's Course to Google Sheets, a Powerful Online Cloud Alternative to Microsoft Excel
4.1 (5 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
347 students enrolled
Instructed by Jon Chu Office Productivity / Google
$19
$20
5% off
Take This Course
  • Lectures 44
  • Length 3.5 hours
  • Skill Level Beginner Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 2/2016 English

Course Description

Google Sheet is an extremely powerful alternative to Microsoft's Excel spreadsheet software. Jon will teach you step-by-step how to create a basic spreadsheet and analyze the. This course covers all the essentials that will help you manipulate and analyze large sets of data. Of course, you will learn the fundamentals such as the basic calculations, formulas, creating charts, and tips & tricks that will get you started quickly.

By the end of this introductory course, you will feel confident maneuvering around Google Sheets and gain instincts to use it effectively for data analysis, and ultimately adding value to your company or to your own personal life.

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

  • As a fun bonus material, you will also learn how to create art with Google Sheets!

    Enroll today in this course! We are 100% confident that you will learn


What are the requirements?

  • Students will need a Google account. Get one free at https://drive.google.com
  • Students will need a thirst and curiosity for experimenting with newly learned formulas and "what ifs"

What am I going to get from this course?

  • Students will be become familiar of the capabilities of Google Sheets and have competencies to build their own worksheets and create their own calculations
  • Students will be able to harness their new found abilities to manipulate, analyze, and visualize data intelligibly
  • Students will be able to deconstruct and build upon already-made spreadsheets and add value in their workplace

What is the target audience?

  • The course is meant for those who are already well-versed in spreadsheet software for years.

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Welcome!
Introduction
Preview
05:08
Creating Your First Spreadsheet
Preview
02:12
Section 2: Menu Items & Tool Bar
Summary of Menu Items & Tool Bar
Preview
05:32
File Menu
04:27
Edit Menu
03:32
View Menu
05:34
Insert Menu
06:08
Format Menu
04:07
Data Menu
10:08
Tools
03:46
Add-ons
04:07
Form
08:16
Help Menu
03:14
Tool Bar
04:52
Section 3: Basic Formulas
Overview of Formulas
03:24
Adding, Subtracting, Multiplying, and Dividing
04:28
COUNT and COUNTA
01:58
Average
01:35
Minimum and Maximum
01:12
If
03:33
Or/And
04:47
Rounding Your Numbers!
02:47
Sumif(s), Countif(s), and Averageif(s)
05:20
Len, Find, Left, Mid, Right, what?!
07:30
Concatenate & Ampersand
03:41
Section 4: Lookup Functions & Data Manipulation
Vlookup and Hlookup
07:19
Match Function, used with Vlookup and Hlookup
06:01
Index Function
06:18
Pivot Table
07:30
Section 5: Charts
Let Google Sheets Do the Charts for You!
10:12
Creating and Customizing Your Own Charts
10:25
Section 6: Other Functions and Know-Hows!
Business & Statistics Formulas
02:58
Autofill
01:54
Anchoring
08:40
Conditional Formatting
04:18
Borders
02:11
Sharing Your Projects
03:48
Commenting on Your Google Sheet
03:16
Keyboard Shortcuts
05:18
Navigating Efficiently through Google Sheets
03:51
Section 7: Common Uses for Google Sheets & Templates!
Overview of Kinds of Templates
10:08
Where to Get Templates
01:46
Section 8: Bonus
Bonus: Creating Art with Google Sheets
07:38
Section 9: Graduation
Graduation & Congratulations!
00:47

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Jon Chu, Never Stop Learning

As someone who loves learning, cooking, building, and tinkering with all things technology, art, and entrepreneurship, Jon spends his time reading voraciously and crafting his skills on various online projects, including teaching courses online. He loves teaching and helping other people understand topics he has learned himself.

Some of his favorite books includes The Great Divorce and Freakonomics.

He is also a Cal alumni. Go Bears!

Ready to start learning?
Take This Course