Google Spreadsheets Step by Step
4.2 (15 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.
120 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Google Spreadsheets Step by Step to your Wishlist.

Add to Wishlist

Google Spreadsheets Step by Step

Step by Step Google Spreadsheet Tutorial Guide to Using Google Spreadsheets
4.2 (15 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.
120 students enrolled
Last updated 3/2013
English
Current price: $10 Original price: $20 Discount: 50% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 4 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I Learn?
Learn how to use Google Drive
Be able to use Spreadsheets proficiently
Understand and apply the various Google Spreadsheet features
Be able to share and work together on Google Docs files
View Curriculum
Requirements
  • web browser
  • internet connection
Description

Why pay for your spreadsheet software when you can get it for FREE?

It's a great alternative to Microsoft Excel without the cost.

Google Spreadsheets is a web-based spreadsheet application created by Google that allows you to create and edit your spreadsheet files online in real-time with other users.

In Google Spreadsheets, because your files are stored online:

  1. Your data is always backed up, and you don't have to worry about losing it if something happens to your computer
  2. You can access your files from anywhere and work from anywhere
  3. You and your team can work on any of your files together at the same time across teams, companies and locations.
  4. Automatically get upgrades of the software without having to buy it or even install it

This “Google Spreadsheet Tutorial: Learn How to Use Google Spreadsheet”course introduces you to the different functions and features of Google Spreadsheets, going through each process step by step from the very beginning.

By the end of the Google Spreadsheet tutorial course, you will be able to:

  1. Manage, Use, Upload and Download your files from Google Drive
  2. Create, Edit, Delete and Print Spreadsheets
  3. Format the contents and change your spreadsheet's layouts
  4. Create and Use Formulas and Functions
  5. Create and Edit Charts
  6. Share and Work on your spreadsheets together with your teammates using real-time collaboration tools like chat, comments, and discussion threads
  7. Go back to previous versions of your spreadsheet if you need to

Take this Google Spreadsheet Tutorial course now and learn how to use Google spreadsheet as a free effective alternative.

</p>

Who is the target audience?
  • Anyone who wants to learn to work in the cloud
  • Business owners who want to streamline their software costs
  • Group Leaders who want to be able to work and collaborate with their teammates simultaneously
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 66 Lectures Collapse All 66 Lectures 04:12:49
+
Introduction to Google Drive
7 Lectures 18:43



Managing Files in Google Drive
03:16

Uploading Files to Your Google Drive Documents List
02:55

Downloading Files From Your Google Drive
01:01

Sharing & Working on Files with Others
01:46
+
Google Spreadsheet Basics
10 Lectures 29:21
Understanding the The Spreadsheet Interface
05:13

Creating Spreadsheets in Google Docs
02:19


Using Existing Excel, Open Office and CSV files in Google Spreadsheets
02:13

Uploading Excel, Open Office & CSV files to Google Spreadsheets
05:29

Renaming Spreadsheets
01:58

Copying Spreadsheets
03:03

Deleting Spreadsheets
01:38

Printing
01:41

Adding, Deleting and Moving Sheets
04:22
+
Editing Google Spreadsheets
14 Lectures 55:46
Entering Text & Numbers
03:14

Entering Dates
06:10

Copy & Paste
04:46

Using the Web Clipboard
03:06


Undo & Redo
02:31

Inserting Rows & Columns
05:40

Moving Rows & Columns
02:48

Resize Rows & Columns
05:24

Freezing Rows & Columns
02:48

Hiding Rows & Columns
03:16

Using the Find & Replace Tool
05:43

Adding Hyperlinks to Spreadsheets
04:22

Understand the Different Views in Google Spreadsheets
03:09
+
Formatting
12 Lectures 41:56
Formatting Text Appearance
03:02

Formatting Numbers
04:38

Formatting Currency & Percentages
03:42

Formatting Dates & Plain Text
02:28

Alignment & Borders
04:19

Merging Cells
04:48

Using the Paint Format Tool
03:22

Text Wrapping
03:56

Protecting Sheets
02:05

Using Named Ranges
02:37

Protecting Named Ranges
02:52

Conditional Formatting
04:07
+
Formulas & Functions
8 Lectures 35:59
Introduction to Formulas
05:46

Relative & Absolute Cell Referencing
08:34

Displaying Formulas
02:20

Using the Counting Functions
05:07

Using the Sum & Average Functions
04:10

Using the Max & Min Functions
03:15

Using Data in Other Sheets
04:01

Using Named Ranges In Formulas
02:46
+
Templates
1 Lecture 02:50
Using Templates
02:50
+
Working with Data
3 Lectures 13:30
Sorting Data in Google Spreadsheets
04:50

Filtering Data Tables
03:45

Using Data Validation
04:55
+
Charts
3 Lectures 14:57
Creating Charts in Google Spreadsheets
08:21

Edit a Chart
03:41

Copying & Using Charts in Google Docs
02:55
+
Useful Functions
3 Lectures 20:47
If Statement
07:39

The IFERROR function
03:18

SumIf & CountIf Functions
09:50
+
Sharing & Collaboration
5 Lectures 19:00
Work with Others on Your Spreadsheets Real-Time
07:51

Using Comments and Discussion Threads for Real-Time Collaborations
04:47

Chatting within Google Spreadsheets
02:39

Using Revision History to Restore Previous Versions of Your Spreadsheet
02:23

Getting Update Notifications and Emailing Collaborators
01:20
About the Instructor
Learners Education
4.2 Average rating
15 Reviews
120 Students
1 Course
Accessible Training

Hi, I’m Joe Garcia. After graduating with a degree in Computer Science, I spent the next 5 years as a software engineer at a multinational company working on projects in the US and Asia. 

Three years ago, I began teaching web development classes part time as a way of giving back, thinking I’d be there for a couple of semesters or so.

Well, two semesters has turned into 3 years and shows no signs of stopping.

I am also a great proponent of Google Docs, using it in all my classes, as it has greatly improved the way I work in projects as well as productivity in my classes. In fact, I have added it to the curriculum of one of my classes, Introduction to Computers

I continue to consult in software and web development projects.

LearnersEd is a venture I started to provide quality learning that is both accessible and affordable for people of all ages and experience levels.