Learn to automate and grow your business with spreadsheets
In this lesson I am going to teach you how to create drop-down lists in Google Sheets. Creating a drop-down list is done by something that is called “Data Validation”. Drop-down lists are extremely useful, and they assure that only valid data is entered into the cells. Drop-downs also make […]
In this lesson, I am going to go over a very simple tutorial of building a Google Sheets dashboard. This will be a great lesson to begin with, if you want to create a dashboard from start to finish for the first time. This is the simplified version of the […]
Are you looking for a way to pull cryptocurrency prices into your Google spreadsheet automatically with a formula? In this lesson I am going to show you three different methods to pull crypto prices into Google Sheets. These methods do NOT require add-ons. With the first method we will use […]
Did you know that you can pull data from websites into your Google spreadsheet, automatically? There is an incredibly useful function in Google Sheets called IMPORTXML, which you can use to retrieve data from web pages, where that data is pulled into a Google spreadsheet on an automated basis. This […]
Today I am going to teach you how to build a dashboard, by going over the major steps that are required for building a dashboard in Google Sheets. The video / article will help you gain a fundamental understanding for how dashboards are built, and will also serve as an […]
Are you a teacher who is looking for Google Sheets templates to make your job easier? On this page you will find several templates that will not only make you more organized and efficient… but you will also find templates that will help your students learn in an enjoyable way. […]
Welcome to the Google Sheets formula tutorial! Today I am going to help you take your Google Sheets skills to the next level, by teaching you the basics of how to use formulas in Google Sheets, as well as by teaching you how to use the 23 best Google Sheets […]
If you need to make a copy of a Google Sheets file, there are two very easy ways to do this. In this lesson I will go over both methods for creating an exact copy of a Google Sheets file, whether you want to make the copy in Google Drive, […]
Managing your spreadsheet tabs is an essential task for using Google Sheets in a professional setting. In this lesson I am going to show you how to insert new tabs, delete tabs, rename tabs, and organize tabs in Google Sheets. Adding and deleting tabs is of course needed often, but […]
Do you have tabs in your Google spreadsheet that you want to hide so that they no longer show at the bottom, but are still available to view / unhide later? Or perhaps you have hidden tabs and you want to know how to unhide them again. In this lesson […]
Coloring tabs in Google Sheets is something that a lot of people know you can do, but a lot of people don’t take advantage of this useful feature. Coloring your tabs in a spreadsheet workbook is just another part of formatting your sheets to make them look professional, and easy […]
Do you have a tab in your Google Sheets file that you want to duplicate? There is a very easy way to make an exact copy of a tab in Google Sheets! (Duplicating tabs makes it easy to create backups of your tabs, and also allows you to create alternate […]