Master Google Sheets (and see why it's better than Excel) (Udemy.com)

Ditch Excel and Learn Skills to Become a Google Spreadsheet Power User!

( 304 Reviews )

Created by: Justin Mares

Produced in 2015

What you will learn

Use Google Spreadsheets like Da Vinci
Create charts and graphs using Spreadsheet data
Format and customize any data
Use advanced tools like Macros, ImportHTML and Scripts to do things you can do with Excel

Quality Score

Content Quality

Video Quality

Qualified Instructor

Course Pace

Course Depth & Coverage

Overall Score : 78 / 100

Course Description

**Updated to Include Google Sheets November 2015 Updates!!**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 Excel3 amazing tools only available in Google SpreadsheetsHow to write your own scripts and use Google addons to get more doneHow 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 SpreadsheetsLearn how to adjust the way data and information are displayed Learn how to write formulas quickly and easily with the point-and-click methodLearn 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 filteringLearn how to automate tasks with time-saving scripts and addonsLearn Spreadsheets secrets and shortcutsAs bonus material, you will also learn two very incredible, and super valuable, skills:
how to harvest data from the webhow to create online forms which allow you to gather data from individualsAs 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.
Justin Mares, Google Sheets wizardWho this course is for:
This course is meant for anyone looking to master Google Spreadsheets. You'll learn why Spreadsheets is more powerful than Excel, and how to do everything in Spreadsheets you can do with Excel (and more). Students should not take this course if you are a horse, lack thumbs, or already know how to do advanced things with Spreadsheets like write scripts and use pivot tables.

Time: 2.5h

Instructor Details

Justin Mares

3.9 Rating
304 Reviews

Hi! My name is Justin Mares. I formerly ran growth at developer tools company Exceptional (acquired by Rackspace in March of 2013).
While there, I taught myself how to become a technical marketer and use tools like SQL to run important analyses on our customer data. Along with learning the basics of HTML, CSS and Python, I've found learning to become a more technical marketer has been one of the most valuable investments in myself I've ever made.
In addition, I'm the co-author of Traction Book, a book about how startups can get traction. For the book, we interviewed Jimmy Wales (founder of Wikipedia), Paul English (founder of Kayak), Dharmesh Shah (HubSpot founder) and pulled together an actionable framework for how startups should think about getting traction and distribution.
I also founded an ecommerce company, Kettle & Fire, that's on a multi-million dollar run rate in just a few months.

Reviews

3.9

304 total reviews

5 star 4 star 3 star 2 star 1 star

Write a Review

By Beatrice Pascual on 11/8/2020

Section 8 and 9 weren't necessary.

By Tanya Thakur on 9/27/2020

Very Quick and Informative.

By Ketan Khurana on 9/26/2020

Star

By Mathieu PRADERE on 9/26/2020

yes good

By Kahlua Peeples on 9/23/2020

It was confusing in parts when there were errors and the instructor went back to fix them and they kept continuing and then he just moved forward. Really loved his tone of voice though and he showed examples so you could walk through with him.

By Sudarsh Sharma on 9/18/2020

Too basic. Won't make you a master. Important areas like macros, dashboard, pivot, etc. were skimmed & not even touched.

By Paulina Porter on 9/14/2020

Great course!

By Genny Brezina on 9/11/2020

Don't like the highlight cursor. It's distracting and turns the rest of the sheet gray or black. Would rather he just use the cursor; we can follow along, no problem.

By Chad Fell on 9/10/2020