Google Sheets - Learn the useful stuff in 30 minutes or less (Full Course) by Ambrose

Google Sheets - Learn the useful stuff in 30 minutes or less (Full Course)

Learn how you can conquer formulas, charts, and pivot tables. Oh my!

Get access for $5

Overview

Don't waste your time on a 2+ hour tutorial, learn the most useful features of Google Sheets the efficient way - in less than 30 minutes!

If you're just looking for the good stuff, you've come to the right place.  In this course, you're going to get access to a spreadsheet that already has data in it so you aren't starting from scratch.

There is no need to be a data analyst, if you can use Gmail (or Yahoo mail... I'm not judging), you'll do great!

You will learn to use:

  • Formulas
  • Conditional formatting
  • Combination of data from 2+ different tables
  • Pivot tables
  • Publish Charts to your website
Learn Google Sheets the efficient way!  Let's get started!

What are the requirements?
  • Internet connection
  • Google account to access Google Sheets
  • If you know how to use email, you'll be able to follow along
What am I going to get from this course?
  • Create surveys (and get notifications in email)
  • Lookup stock prices with formulas
  • Combine the data of 2+ different sheets (using index/match lookups)
  • Use pivot tables to impress your friends and family
  • Automatically color the data based on certain conditions
What is the target audience?
  • People who aren't necessarily data analysts and want to manipulate small sets of data
  • People who are tight on time and want to learn the most useful features in Google Sheets

What's included?

Video Icon 16 videos File Icon 1 file

Contents

Let's get it started in here! ... with freeze frames and formulas
Introduction
1 min
Spreadsheet Basics
4 mins
Using Formulas
3 mins
Worksheet
Splitting and Filtering
Splitting comma separated strings into columns
2 mins
Using filters and saving them as 'views'
2 mins
Combining two datasets
Introducing the index match formula
2 mins
Index Match... revisited
3 mins
Conditional Formatting
Color code a todo list implemented as a spreadsheet
3 mins
Highlight duplicate items
5 mins
Pivot Tables and Charts
Use a Pivot table to count occurrences
1 min
Use a Pivot table for real (i.e. when you have "types" in your data set)
2 mins
Publishing Charts
2 mins
All Done!
Conclusion
1 min
Bonus Lectures
Bonus: Publish Google Analytics Charts (external video)
1 min
Bonus: Creating a survey in Google Sheets
4 mins
Bonus: Splitting Birthday Party costs fairly
5 mins
Mid ambrose

Resources to help you 10X your effectiveness and efficiency*

*unless your effectiveness and efficiency is 0, in that case 10X-ing that won't help much.... Life's too short to be wasting time reading stuff and doing things that are unnecessary. The tools and information found here will help you become an efficient hacker.