Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.
Connecting to the Web | Advanced Data Manipulation with Power Query
Excel for Finance
course content

Contenido del Curso

Excel for Finance

Excel for Finance

1. Introduction to Power Query
2. Advanced Data Manipulation with Power Query
3. Power Pivot Handling
4. Dashboard Automation
5. Developing an Interactive Report

bookConnecting to the Web

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.

¿Todo estuvo claro?

¿Cómo podemos mejorarlo?

¡Gracias por tus comentarios!

Sección 2. Capítulo 4
some-alt