Excel 2016 Web Query for Windows

preview_player
Показать описание
This brief demonstration explains how to use Excel 2016 to get information from the web. Excel 2016 contains new features and performs web queries a bit differently from Excel 2013 and older versions. You can use get the same functionality by using the Power Query plugin for Excel 2013 and 2010.

Рекомендации по теме
Комментарии
Автор

This video is still current for Fall 2019. When you attempt to get data from the web, extra login methods are available as ways to authenticate as a user against the web content you are trying to access. The default method requires that the data be stored in an HTML <TABLE> element, which is getting less and less common.

blackinktraining