Use the Excel Stocks Data Type Feature for Portfolio Analysis

In Office 365, you'll get the data type option for Stocks. This gives you the ability to dynamically link stock data into Excel. Think of it as using Excel to get a link to free stock quotes! You can can the ticker symbol, closing price, 52 week high or low or P/E (to name a few). It's a versatile feature and even better when you use it with the Table feature so you could put together a portfolio of stocks to track. If you've got Office 365 and like to check the stock market with Excel, this video will introduce you to the feature.

📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support!

#excel
#msexcel
#doughexcel

[excelisfun]

With a Thumb Nail like that you should get 1 m views ; )

[spuneet]

Don't have 2019 in office sir, but useful tips