How to Use Pivot Tables in Google Sheets + How to Use a Dynamic Range to Create a Dynamic Chart
In this video I'll be showing you some of the new changes I've made to my dividend tracking spreadsheet in Google Sheets. Specifically I'll be talking about How to Use Pivot Tables and How to Use a Dynamic Range to Create a Dynamic Chart. I will leave links to the resources I used below. Let me know if you have any questions in the comments.
TIMESTAMPS:
00:00 Intro
00:52 Spreadsheet Updates
03:00 Dynamic Range for a Chart
04:29 Count Function
06:30 Indirect Function
07:10 Example
10:16 Quote
11:30 Outro
Please Like, Subscribe, and Comment if you enjoyed this video and would like to follow along on my Dividend Investing journey in 2020 and beyond. It helps other people see this content and it helps my channel grow. I really appreciate all the support. Thanks!
Resources:
Google sheets indirect function: https://support.google.com/docs/answe...
Dynamic Range info: https://www.benlcollins.com/formula-e...
Watch this video to learn even more about pivot tables: • Dividend Income Update ~ August 2020 | Rob...
Also if you think others would enjoy my channel please share it with others: / frankmularcik
If you're interested, check out Yotta bank. Yotta (at this time) offers a 0.2% interest rate but they also have weekly 'lottery' drawings in which you can win up to $10,000,000. You get 1 'lottery' ticket for every $25 deposited and you will get 100 free tickets if you use my link (I will get 100 as well). Thanks in advance if you use my link!: https://withyotta.page.link/EjzabqX6v...
A little bit about myself: My name is Frank Mularcik and I'm a first year student studying computer engineering. I found a passion for investing when I turned 18 so I created this YouTube channel to document my journey of investing, tracking those investments, and learning more and more about computer science along the way.
Feel free to reach out or ask any questions in the comments, through email, or on Twitter or Instagram as listed below.
Follow me on Instagram: / frankmularcik
Follow me on Twitter: / frankmularcik
Disclaimer: I am not a financial advisor; this video is for entertainment and educational purposes only. Please do your own research before making any investment decisions.
Music credit to Mixaund: https://mixaund.bandcamp.com/
