Import Multiple Pages from Web with One Query in Excel

Описание к видео Import Multiple Pages from Web with One Query in Excel

In this video, we import multiple pages of data from a website with one Excel query using Power Query.

We create a table of URL's that can automatically update on a sheet, import data from the web and then turn it into a function with some M code.

We then create a custom column to use this function and feed it the URLs from the table to import as many pages as we want.

Find more great free tutorials at;
https://www.computergaga.com

** Online Excel Courses **

The Ultimate Excel Course – Learn Everything ► https://bit.ly/UltimateExcel
Excel VBA for Beginners ► http://bit.ly/2JvnnRv
Advanced Excel Tricks ► https://bit.ly/3CGCm3M
Excel Formulas Made Easy ► http://bit.ly/2t3netw
Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2viGg3J

Connect with us!

LinkedIn ►   / 18737946  
Instagram ►   / computergaga1  
Twitter ►   / computergaga1  

Комментарии

Информация по комментариям в разработке