Google Spreadsheets Step by Step

Step by Step Google Spreadsheet Tutorial Guide to Using Google Spreadsheets
4.0 (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.
100 students enrolled
$19
$20
5% off
Take This Course
  • Lectures 66
  • Length 4 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 10/2012 English

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

What are the requirements?

  • web browser
  • internet connection

What am I going to get from this course?

  • 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

What 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

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: Introduction to Google Drive
Intro to Google Drive
Preview
03:16
Using Google Docs
Preview
04:53
Searching Google Drive
Preview
01:36
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
Section 2: Google Spreadsheet Basics
Understanding the The Spreadsheet Interface
05:13
Creating Spreadsheets in Google Docs
02:19
Saving Spreadsheets
Preview
01:25
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
Section 3: Editing Google Spreadsheets
Entering Text & Numbers
03:14
Entering Dates
06:10
Copy & Paste
04:46
Using the Web Clipboard
03:06
AutoFill
Preview
02:49
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
Section 4: Formatting
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
Section 5: Formulas & Functions
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
Section 6: Templates
Using Templates
02:50
Section 7: Working with Data
Sorting Data in Google Spreadsheets
04:50
Filtering Data Tables
03:45
Using Data Validation
04:55
Section 8: Charts
Creating Charts in Google Spreadsheets
08:21
Edit a Chart
03:41
Copying & Using Charts in Google Docs
02:55
Section 9: Useful Functions
If Statement
07:39
The IFERROR function
03:18
SumIf & CountIf Functions
09:50
Section 10: Sharing & Collaboration
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

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Learners Education, 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.


Ready to start learning?
Take This Course