79% OFF online library of tutorials for mastering Google Sheets

One time purchase $149

This course is not available for free users. Please purchase a subscription to enroll in this course and view its contents.

Data Analysis

36 Tutorials

3 hours and 39 minutes

These videos deal with formulas and functions you may encounter a lot. Or ones you may never have seen before. You’re a gold rusher, heading for the hills. You got your pickaxe and bucket. With these fantastic functions you can make sure to get the right gold, at the right time. 

36Tutorials

Free tutorial for finding Minimum and Maximum data points.

1

Use arrayformula to deal with Google form entries on a sheet. Even as they keep getting added.

2

Search through and filter data to get what you want, when you want it.

4

Part two. Count domains of emails you get. List of emails and get which domains are there!
I'm gonna talk about how to take a list of emails and figure out which domains count the domains. Few reasons we might do this is maybe we have a newsletter like I do, and we wanna find out which companies it's of like a business newsletter which companies subscribe to us more than others.
I download it from MailChimp and then I try to figure out which companies are subscribed to me most. And I do, I have to figure out the domain and count the domain. And we're gonna do that all in Google Sheets.
Checking data? This script changes bg color of entire row as you move your cell selection.
I figured out that 20% of my videos are getting 80% of the watch time on my YouTube channel, and I actually used a Google sheet to figure this out.
Create easy to use math iterators with the ROW() formula. It tells you the row your cell is on, but why do you need that? you can iterate math equations! It's neat!
One weird way to learn more about what Google Sheets can do. https://bettersheets.co/formulas

12

Fid out how to get the frequency of ProductIds, or Names, or Emails. or how many times they appear in a sheet/column/row.

13

Find out which words in your sheet are the most common. Highest count of each individual word.
In Excel you actually have these options of sorting by year, by month, by date. But let's do it in Google Sheets.
Get floor prices into your spreadsheet with URLFETCHAPP. Accessing OpenSea's API directly from google sheets. Get any data you want. from Market Cap to One Hour Volume
Demystifying the SumIF Formula. Add up your values based on a condition, even if that condition is a date.
Dates are numbers so you can filter them with greater than and less than.

19

Great for counting writing sessions, or tweets you're writing.
Every word can be capitalized with this formula.

22

how to create an auto-updating sales chart that displays the trailing 12 months of data in Google Sheets. The tutorial uses a sample dataset to demonstrate how to build a dynamic chart that updates automatically as new data is added.
Learn how to use CountBlank() and more counting formulas.

24

Create little graphs with SPARKLINE() super easy!
Combining GoogleTranslate() and DetectLanguage() to figure out what a language is without having to know the two letter codes. And adding a dropdown range to make it easier to find the language you want to translate to. What a great way to solve the frustrating world of International language!
Count your words inside a sheet. Great for ad writing, novel writing, or if you need to meet minimums.
We're going through the switch formula because in the past if I've ever had to change, say a day of the week or a month on the calendar to a number, or I have to change that number to the month or text, it's really hard.
What happens very often is we want to figure out an average averages, help us tell the story of a large set of data, but averages also can lie.

29

Member Ben asks how to add 1 month to a date.
So in this video we're going to compare two tabs and differences. Basically, someone asked actually on AppSumo, someone asked how do I compare two sheets to know what the differences are? This is the answer.
Today we're gonna talk about errors in Google Sheets and how you can fix them. #N/A, #ERROR, #REF!, #NAME?, #DIV/0
Create a way to grade the quality of a domain based on many different votes and inputs and qualities. Like measuring the length and ranking the results.
Get crypto prices into a Google Sheet.

34

We're going to create some magic here. Some if magic, sprinkle a little magic on your sheets, you can use these formulas in existing sheets.