Google Sheets - in 30 minutes or less!
- 35 mins on-demand video
- 1 article
- Full lifetime access
- Access on mobile and TV
- Certificate of Completion
Get your team access to Udemy's top 3,000+ courses anytime, anywhere.Try Udemy for Business
- 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
- Internet connection
- Google account to access Google Sheets
- If you know how to use email, you'll be able to follow along
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, you'll do great!
You will learn to use:
- 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!
All Videos come with Closed Captions (English) and are downloadable
- 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
Here we'll go over the interface and I'll show you how to freeze frames, and write text on a newline in the same cell. We'll also cover how to stop turning your data into dates.
Pivot tables can do much more than this, but this makes for a good intro
In the real application of Pivot tables, you would use them when you have data that is 'typed'. That is, you want to group the information by a value that occurs frequently in a column. Take a look at the worksheet to see what I mean.
Here, we'll cover how to sum up numbers only if the column next to it says "Bob". I'll also explain what those $ mean when you see cells referred to like: $c$12
The URL for this sheet is:
If you liked what you saw here, let's keep in touch - I plan to release more productivity articles on my site at: http://www.efficientHacks.com - you can have random productivity tips delivered to your inbox as well. Here's a sample email: http://preview.mailerlite.com/d8j1q8