HOW TO USE POWER QUERY FROM OTHER WEB SOURCE Power Query 101
Step 1: Connect to a Wikipedia page. Excel 2016: Click the Data tab, and then New Query, From Other Sources, From Web. ...
Step 2: Shape the data. ...
Step 3: Clean the data. ...
Step 4: Filter values in a column. ...
Step 5: Name a query. ...
Step 6: Load the query to a worksheet. ...
Step 7: Discover what happens behind the scenes.
LINK:
=============================

0 Comments