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:
Learn Google Sheets the efficient way! Let's get started!
All Videos come with Closed Captions (English) and are downloadable
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.
The formulas covered here are:
The link to the spreadsheet can be found in the resources.
If you have a list like this: a,b,c,d,e,f and you want to have a in column A, b in column B, etc. here's how you do it.
Learn to filter and sort your data and use filter views to save the filter without changing the data.
The index match lookup is actually better than the vlookup formula because vlookup has restrictions where the data you're looking up has to be on the right.
Ok now what if you don't have a column value that uniquely identifies the row?
Did you know that the cells can be colored automatically based on their value or a formula?
This is a feature in Excel, but not built into Google Sheets
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.
Did you know that you can publish charts to your site? If you don't have a site, use sites.google.com or you can just share the URL.
Congrats! You can now talk about your latest pivot table conquest at the next cocktail party!
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:
Create multiple choice surveys and have the results automatically transferred to your form.
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
There is just too much noise on the Internet! My mission is simple: help everyone cut through the fluff and just learn the important stuff.
I've been in the IT industry since 2007 and it pains me to see how bad a lot of these technical books are. Just get to the point already, am I right?