Course 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.
Curriculum
Advanced Spreadsheet Booster
Answer to VLOOKUP Exercise
Assignment: Create your own chart!
Assignment: Creating your own functions
Building Formulas and Functions
Charts and Graphs Quiz
Conditional Formatting
Creating a Scatterplot
Creating our First Chart!
Creating, Renaming and Sharing
Data Manipulation Quiz!
Different Kinds of Charts
Example: Write Your Own Macro
Exercise: Using VLOOKUP
Filters and Filter Views
Find and Replace
Find, Replace, Search, Split and Substitute
Formatting Basics
Formatting Quiz
Freezing Rows and Columns
Fun with VLOOKUP
Functions and Formulas Quiz
Google Spreadsheet Templates
HLOOKUP Exercise
Importing Alexa Data with ImportXML
Importing XML Data into Spreadsheets
ImportXML and ImportHTML quiz
ImportXML Quiz
ImportXML Resources
ImportXML Syntax
Introduction to Charts and Graphs
Introduction to ImportXML
Introduction to Macros
Kinds of Lookups
Left and Right
List of All Formulas
Logical Functions
Lookups Quiz
Macros Quiz!
Math Functions
Note from Justin
Official Google Spreadsheet Resource
Overview of Formula Types
Questions?
Revision History
Section 1: Introduction
Section 10: Tools to Use with Google Docs
Section 11: Resources
Section 2: Spreadsheet Basics
Section 3: Manipulating Data like a BOSS
Section 4: Functions and Formulas
Section 5: Charts and Graphs
Section 6: Advanced Google Spreadsheets
Section 7: Lookups
Section 8: Pulling Data a Spreadsheet with ImportXML and ImportHTML
Section 9: Macros
Sorting Data
Spreadsheet Add-ons
Text Functions
Using ImportHTML
Using Spreadsheet Booster
VLOOKUP Additional Resources
What did you think of the course? Plus, bonus inside!
What we'll cover in this course
Writing our First Macro
LINK FOR THE FREE COURSE
100% Off, Udemy 100% Off, Udemy Coupon, Udemy Coupon Code, Udemy course, Udemy course download, Udemy course reviews, Udemy courses, Udemy courses for free, Udemy courses free, Udemy courses free download, Udemy discount, Udemy download, Udemy education, Udemy free, Udemy free course, Udemy free courses, Udemy free online courses, Udemy online, Udemy online course, Udemy online courses, Udemy online courses review, Udemy reviews, Udemy tutorial, Udemy tutorials, Udemy.com free courses,
