Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ AWS Certified Developer - Associate
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Mindfulness Meditation Personal Transformation Life Purpose Emotional Intelligence Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Google Analytics
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Modeling Data Analysis Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Blogging Freelancing Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee
Office Productivity Google Excel

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

Ditch Excel and Learn Skills to Become a Google Spreadsheet Power User!
Rating: 4.4 out of 54.4 (3,196 ratings)
16,883 students
Created by Justin Mares
Last updated 11/2015
English
English [Auto]
30-Day Money-Back Guarantee

What you'll 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
Curated for the Udemy for Business collection

Requirements

  • Students will need to have a Google account of some kind.

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

Justin Mares, Google Sheets wizard

Who 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.

Featured review

Dorothy Ogues
Dorothy Ogues
8 courses
5 reviews
Rating: 5.0 out of 510 months ago
There is a hidden treasure in Google Sheets that will help my data entry and data organizing much easier! The course teacher is VERY engaging, uses great illustrations/examples, and talks in a simple way that's easy to comprehend. Love learning this!!! ^ ^

Course content

11 sections • 48 lectures • 2h 50m total length

  • Preview01:14

  • Preview06:37
  • Preview09:01
  • Freezing Rows and Columns
    01:56
  • Conditional Formatting
    04:49
  • Formatting Quiz
    3 questions

  • Sorting Data
    04:19
  • Filters and Filter Views
    05:50
  • Find and Replace
    02:28
  • Revision History
    03:06
  • Data Manipulation Quiz!
    3 questions

  • Building Formulas and Functions
    09:52
  • Overview of Formula Types
    04:06
  • List of All Formulas
    00:17
  • Math Functions
    05:28
  • Logical Functions
    08:27
  • Text Functions
    06:28
  • Left and Right
    05:05
  • Find, Replace, Search, Split and Substitute
    09:40
  • Assignment: Creating your own functions
    00:29
  • Functions and Formulas Quiz
    3 questions
  • Questions?
    00:05

  • Introduction to Charts and Graphs
    00:51
  • Different Kinds of Charts
    05:05
  • Creating our First Chart!
    07:51
  • Creating a Scatterplot
    03:59
  • Assignment: Create your own chart!
    00:27
  • Charts and Graphs Quiz
    2 questions

  • Note from Justin
    00:17

  • Kinds of Lookups
    00:46
  • Fun with VLOOKUP
    06:41
  • Exercise: Using VLOOKUP
    00:24
  • Answer to VLOOKUP Exercise
    03:35
  • VLOOKUP Additional Resources
    00:28
  • Fun with HLOOKUP
    02:02
  • HLOOKUP Exercise
    00:16
  • Lookups Quiz
    3 questions

  • Introduction to ImportXML
    01:30
  • ImportXML Syntax
    00:37
  • Importing XML Data into Spreadsheets
    05:47
  • Importing Alexa Data with ImportXML
    08:45
  • ImportXML Resources
    00:49
  • ImportXML Quiz
    1 question
  • Using ImportHTML
    07:30
  • ImportXML and ImportHTML quiz
    3 questions

  • Introduction to Macros
    00:57
  • Writing our First Macro
    05:35
  • Example: Write Your Own Macro
    00:35
  • Macros Quiz!
    3 questions

  • Spreadsheet Add-ons
    04:03
  • Using Spreadsheet Booster
    04:54
  • Advanced Spreadsheet Booster
    04:48

Instructor

Justin Mares
Traction Book author, growth at Airbrake/Exceptional
Justin Mares
  • 4.3 Instructor Rating
  • 7,198 Reviews
  • 115,350 Students
  • 6 Courses

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.

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Impressum Kontakt
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.