Learn Google Spreadsheets Step by Step, and Ditch Excel for the More Powerful Google Docs!
Free tutorial
4.8
1hr 14min of on-demand video
Created by Justin Mares
English
English [Auto]
What you’ll learn
- Use Google Spreadsheets like they can use Excel
- Understand and be able to create charts and graphs in Spreadsheets
- Create their own formulas
- Format, filter and manipulate data in Google Spreadsheets
Requirements
- Access to Google Spreadsheets
Description
Become a master Google Docs user with this course on using Google Spreadsheets. You’ll learn:
- How to use Google Spreadsheets just like you use Microsoft Excel
- 3 amazing tools only available in Google Spreadsheets
- How to write your own scripts and use Google addons to get more done
- How to create charts, tables, graphs and format data
This course will give you you everything you need to know about Google Spreadsheets.
From the fundamentals, to the most advanced features, after taking this class you will be able to use Spreadsheets like a MASTER. Pretty soon, you’ll be using Spreadsheets better than most people can use Excel… and be able to take advantage of the super useful features that only Google Spreadsheets has to offer.
In this course, you will learn all of the following about Google Spreadsheets:
- Learn how to navigate around Spreadsheets
- Learn how to adjust the way data and information are displayed
- Learn how to write formulas quickly and easily with the point-and-click method
- Learn how to create powerful calculations
- Learn how to visually represent your data with charts and graphs
- Learn how to use data tools like sorting, subtotaling, and filtering
- Learn how to automate tasks with time-saving scripts and addons
- Learn Spreadsheets secrets and shortcuts
As bonus material, you will also learn two very incredible, and super valuable, skills:
- how to harvest data from the web
- how to create online forms which allow you to gather data from individuals
As an additional bonus, you can follow along and complete challenges and quizzes as you learn the material. You will also be shown how to find and download free Spreadsheet templates that will allow you to do all kinds of things.
Another great aspect of this course is that, at the end of this class, you will be given a CERTIFICATE OF COMPLETION.
This class is guaranteed to teach you Google Spreadsheets. Once enrolled, you will have access to this course for the rest of your life. You will always be able to come back to this class to review material or to learn new material. Try this course for yourself and see how quickly and easily you too can learn to use Google Spreadsheets.
Who this course is for:
- Anyone who works regularly with Excel and wants to experience the power of Google Docs
- Anyone who wants to get up and running with Google Spreadsheets
Show less
Course content
4 sections • 18 lectures • 1h 16m total lengthCollapse all sections
Introduction1 lecture • 1min
- Introduction & Why Google Spreadsheets are Awesome01:14
Spreadsheet Basics4 lectures • 22min
- Creating, Renaming and Sharing06:37
- Formatting Data in Spreadsheets09:01
- Freezing Rows and Columns01:56
- Conditional Formatting04:49
- Formatting Quiz!3 questions
Manipulating Data like a Boss5 lectures • 16min
- Sorting Data04:19
- Filters and Filter Views05:50
- Find and Replace02:28
- Revision History03:06
- Data Manipulation Quiz!3 questions
- Learning More about Data Manipulation00:39
Creating Charts and Formulas8 lectures • 36min
- Building Formulas and Functions09:52
- Overview of Formula Types04:06
- Logic Formulas08:27
- Assignment: Create Your Own Formulas00:20
- Introduction to Charts and Graphs00:51
- Create Our First Chart!07:51
- Create a Scatterplot03:59
- Bonus Lecture: Discounted Access to Full-Featured Course00:38
