4.25 out of 5
4.25
14 reviews on Udemy

I Heart Google Sheets: Training for Skills Employers Want

Comprehensive Beginner's Course to Google Sheets, a Powerful Online Cloud Alternative to Microsoft Excel
Instructor:
Jon Chu
382 students enrolled
English [Auto-generated]
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

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

Welcome!

1
Introduction
2
Creating Your First Spreadsheet

Menu Items & Tool Bar

1
Summary of Menu Items & Tool Bar
2
File Menu
3
Edit Menu
4
View Menu
5
Insert Menu
6
Format Menu
7
Data Menu
8
Tools
9
Add-ons
10
Form
11
Help Menu
12
Tool Bar

Basic Formulas

1
Overview of Formulas
2
Adding, Subtracting, Multiplying, and Dividing
3
COUNT and COUNTA
4
Average
5
Minimum and Maximum
6
If
7
Or/And
8
Rounding Your Numbers!
9
Sumif(s), Countif(s), and Averageif(s)
10
Len, Find, Left, Mid, Right, what?!
11
Concatenate & Ampersand

Lookup Functions & Data Manipulation

1
Vlookup and Hlookup
2
Match Function, used with Vlookup and Hlookup
3
Index Function
4
Pivot Table

Charts

1
Let Google Sheets Do the Charts for You!
2
Creating and Customizing Your Own Charts

Other Functions and Know-Hows!

1
Business & Statistics Formulas
2
Autofill
3
Anchoring
4
Conditional Formatting
5
Borders
6
Sharing Your Projects
7
Commenting on Your Google Sheet
8
Keyboard Shortcuts
9
Navigating Efficiently through Google Sheets

Common Uses for Google Sheets & Templates!

1
Overview of Kinds of Templates
2
Where to Get Templates

Bonus

1
Bonus: Creating Art with Google Sheets

Graduation

1
Graduation & Congratulations!
You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
4.3
4.3 out of 5
14 Ratings

Detailed Rating

Stars 5
6
Stars 4
6
Stars 3
0
Stars 2
2
Stars 1
0
f440c2e52015da6a541c46b044d2a014
30-Day Money-Back Guarantee

Includes

4 hours on-demand video
Full lifetime access
Access on mobile and TV
Certificate of Completion