Learn to automate and grow your business with spreadsheets
Did you know that you can pull stock prices, and other stock data in Google Sheets, by using a formula? In this lesson I am going to teach you all the different ways to use the GOOGLEFINANCE function, to pull real-time stock data, as well as historical stock data. I'll […]
Do you have text that you need to indent in your Google spreadsheet? There are several ways that you can indent in Google Sheets, and in this lesson I am going to show you all of them. I'll teach you how to automatically add space before the text in a […]
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 […]
Click here to go back to the main dashboards course page. Download the raw data: Revenue Report CSV View the completed dashboard After downloading the raw data that is linked above, scroll down and begin the video (or return to YouTube) to start building the dashboard. In this lesson, I […]
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 […]