Learn Connecting to the Web | Advanced Data Manipulation with Power Query

/

Excel for Finance

In this section, we'll practice connecting to websites. We can only retrieve data from web pages that contain tabular data. A key advantage of this approach is that if the data on the webpage is periodically updated, the data in Power Query will automatically update as well.

We'll practice extracting a table from this web resource:

If you need a step-by-step guide, here’s a e-book for you.

Everything was clear?

Thanks for your feedback!

Section 2. Chapter 4

Ask AI

Ask AI

Ask anything or try one of the suggested questions to begin our chat

Suggested prompts:

Ask me questions about this topic

Summarize this chapter

Show real-world examples

Swipe to show menu

In this section, we'll practice connecting to websites. We can only retrieve data from web pages that contain tabular data. A key advantage of this approach is that if the data on the webpage is periodically updated, the data in Power Query will automatically update as well.

We'll practice extracting a table from this web resource:

If you need a step-by-step guide, here’s a e-book for you.

Everything was clear?

Thanks for your feedback!

Section 2. Chapter 4

some-alt