585Google Sheet Tutorials

• 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

How to create a video checklist. Create a sheet with check boxes that you check off to mark the videos as seen. Great for those creating lead magnets or checklist digital products. Enables you to create a video course without having to download/upload any videos. Your users can keep track of their progress and get all the benefit of your knowledge.

Introducing OnlySheets, the paywall for Google Sheets.

extending Google Sheets in a really fun way. We're gonna be sending emails. I have had literally two people in the past week and a half ask me for this and I answered their question very specifically, but I wanna generally reach out to everyone here, give everyone the opportunity to learn this.

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

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

Created a simple tweet starter sheet. Tweet directly from this Google Sheet. Free for Members.

Figure out who won a game of tic tac toe. inside a Google Sheet. Great for teachers and educators.

Your question is, you have these events and dates and statuses. And you want to turn them green actually you wanna turn them any, some color, the whole entire row based on if in this D column the status is closed.

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.

to make better Dashboards consider merging cells.

we're gonna go through what does it take to make a vertical progress bar.

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

There was a stories craze. Every app/platform/business was adding 24 hour lasting videos to their users accounts. Now you can do that with Google sheets.

Make a dropdown menu inside Google Sheets you can add to anything and it makes it available in the dropdown.

Learn the best fonts to use in Google Sheets.

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

Let's make a progress bar in Google Sheets.

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.