-
Intro
-
- Volg deze cursus om toegang te krijgen tot bronnen
-
- Volg deze cursus om toegang te krijgen tot bronnen
-
-
Interface
-
Functions & Formulas
-
- Volg deze cursus om toegang te krijgen tot bronnen
-
Charts
-
Pivot tables & pivot charts
-
Data Tools
-
Nested formulas
-
Automation
-
- Volg deze cursus om toegang te krijgen tot bronnen
-
Excel Books - Theorie
-
Quizzes
-
- Volg deze cursus om toegang te krijgen tot bronnen
-
- Volg deze cursus om toegang te krijgen tot bronnen
-
- Volg deze cursus om toegang te krijgen tot bronnen
-
- Volg deze cursus om toegang te krijgen tot bronnen
-
-
Webbronnen
-
- Volg deze cursus om toegang te krijgen tot bronnen
-
- Volg deze cursus om toegang te krijgen tot bronnen
-
- Volg deze cursus om toegang te krijgen tot bronnen
-
-
Extra's
-
Diversen
-
- Volg deze cursus om toegang te krijgen tot bronnen
-
- Volg deze cursus om toegang te krijgen tot bronnen
Get Latest Stock Data in Excel & Create Your Own Stock Portfolio
Easily pull live stock data in Excel with Stock data types.
With Excel's stock data feature you can get live stock information. Stock data types allows users to quickly pull stock information into Excel from various exchanges.
In this tutorial I'll show you how you can pull data related to stocks, bonds, currency, and even crypto-currency such as Bitcoin into your spreadsheet. This way you can easily calculate your portfolio value directly from within Excel. You'll learn to build your very own stock portfolio in Excel. We'll use Excel tables together with conditional formatting.
With stock data types you can retrieve stock prices, stock volume, 52 week high, 52 week low, shares and a lot more. If the stock data type is showing you an incorrect stock or the wrong exchange, you can easily change it. I'll show you how to in the video.
Note: Excel Stock Data Types are available in Excel for Microsoft 365 and in Excel for the web.
Time Stamps
00:00 How To Use Stock Data Types in Excel
04:27 How To Setup a Stock Portfolio in Excel
09:54 Use Conditional Formatting for Stock Portfolio
12:30 How To Setup Language for Stock Data Type
Download the file from here (scroll to the bottom of the article): https://www.xelplus.com/excel-stock-data/
More Excel 365 tutorials: https://www.youtube.com/playlist?list=PLmHVyfmcRKyyPFY31LldHWcJdLzGUPTSP
★ My Online Excel Courses ► https://www.xelplus.com/courses/
✉ Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/
EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/
Get Microsoft 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593
GEAR
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Main Camera: https://amzn.to/3a5ldBs
Backup Camera: https://amzn.to/2FLiFho
Main Lens: https://amzn.to/39apgeD
Zoom Lens: https://amzn.to/3bd5pN7
Audio Recorder: https://amzn.to/2Uo5rLm
Microphone: https://amzn.to/2xYy9em
Lights: http://amzn.to/2eJKg1U
More resources on my Amazon page: https://www.amazon.com/shop/leilagharani
Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
Twitter: https://twitter.com/leilagharani
LinkedIn: https://at.linkedin.com/in/leilagharani
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#MsExcel #excel #stockdata
Er zijn momenteel geen reacties.
Deel deze inhoud
Koppeling delen
Deel op sociale media
Delen via email
Alsjeblieft in te loggen om dit te delen Video via e-mail.