❎ How to use Excel

Currently Playing: How to Import Data from Web to Excel

🔥 Learn Excel in just 2 hours: https://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: https://youtu.be/0aeZX1l4JT4 - Learn the fundamentals of Excel in just 2 hours: https://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: https://youtube.com/playlist?list=PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY 🚩 Connect with me on social - LinkedIn: https://www.linkedin.com/in/kevinstratvert/ - Twitter: https://twitter.com/kevstrat - Facebook: https://www.facebook.com/Kevin-Stratvert-101912218227818 - TikTok: https://www.tiktok.com/@kevinstratvert - Instagram: https://www.instagram.com/kevinstratvert/ 🔔 Subscribe to my YouTube channel https://www.youtube.com/user/kevlers?sub_confirmation=1 🎬 Want to watch again? Navigate back to my YouTube channel quickly http://www.kevinstratvert.com 🛍 Support me with your Amazon purchases: https://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