Google Sheets Arithmetic
In this Google Sheets Tutorial, I run through how to add, subtract, multiply, divide, sum, average, max, min, and count. These are useful and basic formulas that you need to have a good grasp for really getting the most out of Google Sheets.
Lock Cells and Drag Formulas in Google Sheets
In this Google Sheets tutorial I quickly run through how to lock one cell in place while dragging a formula. This is a useful thing to know if you want to multiply many numbers all by the same number that exists in another cell in the spreadsheet. This works the same way in Google Sheets and Microsoft Excel.
Display Stock Name Automatically in Google Sheets
In this video I show how to display the name of stocks automatically in Google Sheets. I also show how to display the stock price, and currency while we're at it too. This is an essential feature to know about if you plan to build your own dividend stock portfolio tracker with Google Sheets. The Google Finance function makes Google Sheets my preferred spreadsheet for tracking stocks.
In this tutorial I show how to display a live stock price in Google Sheets. I also show what to do incase a stock is listed on more than one market, and how to show the price in each market.
I'm documenting the growth of a Canadian dividend investing portfolio and make videos about dividend investing, Canadian stocks, Wealthsimple Trade, Google Sheets, personal finance, and passive income.