🔥 Learn Excel in just 2 hours: kevinstratvert.thinkific.com
In this step-by-step tutorial, learn how to import and dynamically connect web data to your spreadsheet in Microsoft Excel. To import data from the web into your workbook, you need to ensure that there is a table of data on the web site that you would like to import. Once you import your data, if the data changes, you can refresh it. You can even configure Excel to refresh in the background, on pre-defined intervals, or every single time you open your spreadsheet. At the end, we also look at how you can use Power Query to transform your data before importing. This way any changes you make are applied anytime you update your data. By the end of this video, you'll have a strong understanding of how to import data from the web into Excel.
👋 Additional resources
- How to use Microsoft Power Query: • How to use Microsoft P...
- Learn the fundamentals of Excel in just 2 hours: kevinstratvert.thinkific.com
⌚ Timestamps
0:00 Introduction
0:46 Find web site with data to import
1:25 Import web data into Excel
3:20 Refresh web data
4:31 Transform data
6:18 Wrap up
📃 Watch related playlists
- Playlist with all my videos on Excel: • ❎ How to use Excel
🚩 Connect with me on social
- LinkedIn: / kevinstratvert
- Twitter: / kevstrat
- Facebook: / kevin-stratvert-101912...
- TikTok: / kevinstratvert
- Instagram: / kevinstratvert
🔔 Subscribe to my KZitem channel
kzitem.info?...
🎬 Want to watch again? Navigate back to my KZitem channel quickly
www.kevinstratvert.com
🛍 Support me with your Amazon purchases: amzn.to/3kCP2yz
⚖ As full disclosure, I use affiliate links above. Purchasing through these links gives me a small commission to support videos on this channel -- the price to you is the same.
#stratvert
Негізгі бет Ғылым және технология How to Import Data from Web to Excel
Пікірлер: 198