Excel Import Data from the Web - Great Time Saving Feature
Excel allows you to pull data on a webpage into Excel. This is a great time-saving feature. Getting data from a webpage is done in Excel on the Data Tab using Get and Transform Data group, From Web command. When you pull data from the web, you can pick the table on the webpage you want to use since many webpages have multiple tables on them.
You can also use PowerQuery to correct any web data that has the wrong data type or data you don't need. A connection to the webpage is made, and when the data changes on the webpage, the data can be automatically updated in Excel. That is AWESOME!
Chapters:
0:00 Intro
0:35 Webpage to pull from
1:13 Data From Web in Excel
3:18 Cross-tabular data
4:05 Closing remarks
Blog post https://chrismenardtraining.com/post/...
#chrismenardtraining #msexcel #microsoftexcel #chrismenard #exceltraining
And make sure you subscribe to my channel!
- EQUIPMENT USED --------------------------------
○ My camera – https://amzn.to/3vdgF5E
○ Microphone - https://amzn.to/3gphDXh
○ Camera tripod – https://amzn.to/3veN6Rg
○ Studio lights - https://amzn.to/3vaxyy5
○ Dual monitor mount stand - https://amzn.to/3vbZSjJ
○ Web camera – https://amzn.to/2Tg75Sn
○ Shock mount - https://amzn.to/3g96FGj
○ Boom Arm - https://amzn.to/3g8cNi6
- SOFTWARE USED --------------------------------
○ Screen recording – Camtasia – https://chrismenardtraining.com/camtasia
○ Screenshots – Snagit – https://chrismenardtraining.com/snagit
○ YouTube keyword search – TubeBuddy – https://www.tubebuddy.com/chrismenard
DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!