Uploaded January 2024 | Updated November 2026, 3 days ago
Welcome back to #DatatoDecisions!
In continuation with our series on converting raw data from the U.S. Bureau of Labor Statistics into an #interactive #report in Excel, today we’ll focus on the primary step:
How to extract data from the website?
0:27 This video shows how to use #PowerQuery in #Excel to extract data from a website
1:28 How to transform this raw data using #PowerQuery
2:34 How to use Merge in #PowerQuery to only extract data that is needed (clean up the data)
With easy-to-follow steps learn how to connect to the web and extract data into Excel in this video.
Intro to this series: youtu.be/zEgpnV_1i_E
For tutorials that address common Excel problems, visit indzara.com/datatodecisions
#InteractiveDashboard #exceldashboards #excelmadeeasy #powerquery #DatatoDecisions
Welcome back to #DatatoDecisions!
In continuation with our series on converting raw data from the U.S. Bureau of Labor Statistics into an #interactive #report in Excel, today we’ll focus on the primary step:
How to extract data from the website?
0:27 This video shows how to use #PowerQuery in #Excel to extract data from a website
1:28 How to transform this raw data using #PowerQuery
2:34 How to use Merge in #PowerQuery to only extract data that is needed (clean up the data)
With easy-to-follow steps learn how to connect to the web and extract data into Excel in this video.
Intro to this series: youtu.be/zEgpnV_1i_E
For tutorials that address common Excel problems, visit indzara.com/datatodecisions
#InteractiveDashboard #exceldashboards #excelmadeeasy #powerquery #DatatoDecisions










