131 Google Sheet Tutorials

If you find Vlookup a difficult formula to understand, this formula combination might be better. It's also much more flexible than Vlookup. Index/Match is the best. It's one of my favorite formula combinations.

Reviewing an existing sheet called "mortgage calculator for Google sheets" I point out the really nice "back to dashboard" button. This seems like a minor point but ends up improving the user interface, and user experience. Users tend to get lost in sheets with tabs, and providing another path to a sheet you know your users will want to go to, is great. At the end of the video I point out that you probably want to provide more outputs than inputs. Meaning that if someone puts in a few numbers, they get out of it a few years of statistics, or calculations in this case. Calculators are cool, but generators are even better. Calculators have a tendency to have more inputs than outputs. You're trying to get to one magical result. But a spreadsheet can be so much more powerful and show many more outputs if you do those calculations,. Especially here for a mortgage, you can show a range of calculations in addition to a single calculation.

One common feature that users often request is the ability to add star ratings to their spreadsheets. While this feature is not built into Google Sheets, it is possible to create a star rating system using emojis and data validation.

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

She has a cell, this D one, in which it says, for instance, another array or a row or column in this case, a column, a on sheet one where we're on and she's referencing that from another cell.

Calculate Return on Ad Spend with a formula combination. Bonus: create a more elegant solution in Apps Script using JsDoc syntax to create an autocomplete native function. We use the formula combination of Concatenate / Round to create the ratio, but in Apps Script we do it a whole lot better.

Add one more feature to our Photo search inside of Google Sheets.

This is one of the most popular asked first "automations". How to move a row of data based on a single criteria in a column. Great for sales teams and maintaining a CRM.

Get ready to shake things up, formula fanatics! Learn how to add a dark mode button to your Google Sheets with this dead simple trick. Using conditional formatting and a custom formula, you can turn on dark mode with just one click. Don't miss out on this cool feature! Made this really quick dark mode click button. And I wanted to show you how I did it because it's dead simple, super simple. It's literally just using conditional formatting

We're gonna create another virtual mall, and in this one we're gonna make it for newsletters

While the desktop version of Google Sheets does not have a dark mode, doesn't mean we can't make it ourselves. Create dark mode in one click. You'll learn to make a dark mode toggle.

While this advice and all well and good, try out Sheet Styles, a free Google Sheets Add-on that enables you to do this less contrast style in one click. https://sheet-styles.bettersheets.co/

I'm gonna show you how to make a character counter and then account characters. And then I'm also gonna show you how to make a limit. It's really simple. It's one formula and some conditional formatting

How to turn many columns into one column.

I would not think that I would enjoy sales tax calculators, no one enjoys sales tax calculators, but when it's in a Google sheet, it's really exciting.

Get down to basics of spreadsheets.