Freeze Rows in Google Sheets. Freeze Columns in Google Sheets.In this Google Sheets tutorial, I show how to freeze rows and freeze columns. It's pretty straightforward, but good to know! The full google sheets Tip & Tricks playlist is here.
0 Comments
How to Convert Currency in Google SheetsIn this Google Sheets Tutorial, I show how currency conversion works. You can convert between many currencies, such as USD, CAD, BGP, etc. Just make sure you convert the right way! Here is a link to all of the Google Sheets Tutorials.
Google Sheets ArithmeticIn 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 SheetsIn 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 SheetsIn 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.
|
Alpine DividendsI'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.
Categories
All
|
RSS Feed
Disclaimer: I am not a financial professional or advisor. Nothing on this website or the associated social media accounts constitutes financial advice. I'm just documenting my own investing journey and don't suggest that you do the same. Investing is risky, so make your own decisions or hire a qualified professional make them for you.
© COPYRIGHT 2021. ALL RIGHTS RESERVED.