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

4.2
2 865 комментариев
Payment
Обучение платное
Certificate
Сертификация бесплатная
Duration
3 часа курса
О курсе

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

Программа
Introduction
What we'll cover in this course

In this course we'll start by covering the basics of Google Spreadsheets so you can be just as proficient using it as you are with Excel. Google spreadsheets can do everything Microsoft Excel can do, but is better for multiple reasons.

Docs comes with sharing, auto-updating and commenting features that Excel lacks. Plus, you can pull in data from the internet (APIs, XML feeds and other cool stuff we cover in the course) in real time that you can't with Excel.

Once you learn how to use Google Spreadsheets, you'll never go back. This lecture covers some of the main reasons why Google Spreadsheets is so awesome.

Spreadsheet Basics
Students will be able to format any data however they like.
Creating, Renaming and Sharing
In this lecture, we cover the basics of creating a Google Spreadsheet, naming it, and sharing it with others.Please, if you are already familiar with Excel, feel free to skip down to the next section on manipulating data. Many of the things covered in this section (formatting data and rows/columns) are done the same way they're done in Excel.
Formatting Basics
This lecture covers the basics of formatting:
  • how to format each cell individually
  • how to change background and font colors
  • how to add or remove borders
  • how to format large groups of cells at once
Freezing Rows and Columns
In this lecture, we cover how to freeze rows and columns for easier viewing when scrolling through large amounts of data or a really big spreadsheet.
Conditional Formatting
Conditional formatting is amazing. It allows you to filter out and change the format of only data that meets certain conditions or criteria.In this lecture, we cover how to use conditional formatting to display only the data you care about, and to gain insight at-a-glance. This is a very useful tool when dealing with large amounts of data.
Formatting Quiz
Quick quiz to determine your spreadsheet formatting knowledge!
Manipulating Data like a BOSS
Students will be able to manipulate data and views via sorting, filtering and find/replace.
Sorting Data
In this lecture we cover how to sort data using the filter and sort functionality in Google Spreadsheets.
Filters and Filter Views
This lecture covers how to use Google Spreadsheet's filter views. This is a really useful tool to quickly filter what data you see and how it's displayed within your document.
Find and Replace
Find and replace is a useful tool to find any data on a spreadsheet. With replace, you can also automatically replace any data (misspellings, grammatical errors, spacing problems) by having Spreadsheets do the searching and replacing for you!
Требования
  • Students will need to have a Google account of some kind.
Что Вы изучите?
  • 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
Лекторы
Justin Mares
Justin Mares
Traction Book author, growth at Airbrake/Exceptional

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
Курсы Udemy подойдут для профессионального развития. Платформа устроена таким образом, что эксперты сами запускают курсы. Все материалы передаются в пожизненный доступ. На этой платформе можно найти курс, без преувеличений, на любую тему – начиная от тьюториала по какой-то камере и заканчивая теоретическим курсом по управлению финансовыми рисками. Язык и формат обучения устанавливается преподавателем, поэтому стоит внимательно изучить информацию о курсе перед покупкой.
Master Google Sheets (and see why it's better than Excel)
113.99 $ 174.99 $
Рейтинг
4.2
1 229
970
514
130
55