65 Google Sheet Tutorials

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

Yes, using conditional formatting we can do this.

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.

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

• Bullet points and numbering help to organize information in a logical and easy-to-follow way
• They make it easier to scan and find important information quickly
• They can help to emphasize key points and make them stand out from the rest of the data 
• They make your spreadsheet look more visually appealing and professional

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.

Built a useful tool to filter Google Sheet formulas based on keywords.

Want to create sleek, stunning PDFs from your Google Sheets? Look no further! Learn how to easily export your sheets to PDF format and impress your audience. Create a PDF from your Google Sheet.

Create awesome progress bars with sparkline formula. You can make progress bar colors can change based on the input.

This feature is really handy for designers who want to create notes around designs and mockups to showcase to clients. As a photographer, I can also use this to create a searchable sheet with keywords for my photos. You can even use screenshots instead of Unsplash photos like I'm using here. Basically, all you have to do is insert the images into cells and use V lookup to search for them using the ID numbers. You can use this to mock up a newsletter, test out different thumbnails as a YouTuber, or create a landing page or workflow for your business. It's really easy to change the photos by just changing the ID number.

We want to know, based on today's date, what is the start of the month and what's the date at the end of the month.

When you can't get the url of a hyperlinked cell, do this instead.

Create relational databases with index/match. Discover the secret to efficient data management with primary keys! Learn how to sort, filter, and create tables based on unique identifiers in this expert video. Say goodbye to complicated spreadsheets and hello to easy data management.

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!

Google Sheets uses a scripting language called Google Apps Script, which is based on JavaScript. If you know how to code in JavaScript, you'll find Google Apps Script very familiar. To get started, open a new Google Sheet and go to the "Extensions" menu, then click "Apps Script".

Unknown Range Name means we've typed in a formula the wrong format of a sheet name. I show you how to fix that and some other errors that might pop up.

Learn the importance of camel case. Camel Case is a simple technique that involves capitalizing the first letter of each word in a text string, except for the first word. This creates a consistent and easily readable format for text that may be used in formulas, labels, or other applications.