I Heart Google Sheets: Training for Skills Employers Want
4.2 (7 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.
352 students enrolled
Wishlisted Wishlist

Please confirm that you want to add I Heart Google Sheets: Training for Skills Employers Want to your Wishlist.

Add to Wishlist

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.2 (7 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.
352 students enrolled
Created by Jon Chu
Last updated 2/2016
English
Current price: $10 Original price: $20 Discount: 50% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 3.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I Learn?
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
View Curriculum
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"
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


Who is the target audience?
  • The course is meant for those who are already well-versed in spreadsheet software for years.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 44 Lectures Collapse All 44 Lectures 03:35:36
+
Menu Items & Tool Bar
12 Lectures 01:03:43

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
+
Basic Formulas
11 Lectures 40:15
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
+
Lookup Functions & Data Manipulation
4 Lectures 27:08
Vlookup and Hlookup
07:19

Match Function, used with Vlookup and Hlookup
06:01

Index Function
06:18

Pivot Table
07:30
+
Charts
2 Lectures 20:37
Let Google Sheets Do the Charts for You!
10:12

Creating and Customizing Your Own Charts
10:25
+
Other Functions and Know-Hows!
9 Lectures 36:14
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
+
Common Uses for Google Sheets & Templates!
2 Lectures 11:54
Overview of Kinds of Templates
10:08

Where to Get Templates
01:46
+
Bonus
1 Lecture 07:38
Bonus: Creating Art with Google Sheets
07:38
+
Graduation
1 Lecture 00:47
Graduation & Congratulations!
00:47
About the Instructor
Jon Chu
4.5 Average rating
22 Reviews
1,239 Students
3 Courses
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!