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.
🔔 SUBSCRIBE to my channel ➜ goo.gl/wN3c3p
🏫 Excel Training ➜ www.exceltrain...
📚 Excel Books & Tech Gear ➜ www.amazon.com...
⚙️ Tools: Screencasting ➜ techsmith.z6rj...
⚙️ Tools: Microsoft Office ➜ microsoft.msaf...
⚙️ Tools: TubeBuddy ➜ www.tubebuddy....
📝 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!
🎁 If you find these videos useful and want to support my channel go to www.buymeacoff...
#excel
#msexcel
#doughexcel

[@excelisfun]

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

[@DougHExcel]

LOL....Thanks Mike!

[@excelisfun]

@@DougHExcel As soon as I saw it in my e-mail notification, I just smiled and said: I HAVE TO SEE THAT VIDEO!!!

[@_Bee_Easy]

Great video! Thanks!

[@DougHExcel]

Glad you liked it!

[@spuneet156]

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

[@DougHExcel]

Hi demon is watching, thanks for the comment!