Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.
Connecting to the Google Sheets | Introduction to Power Query
Excel for Finance
course content

Conteúdo do 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 Google Sheets

We need a special table that contains dates in various formats so that we can standardize them into a single format that’s convenient for data analysis across all tables.

Cope this link:

But if you encounter any issues, you can download an Excel Workbook that contains the same information as the Google Sheets, following the instructions from the previous chapter.

This table includes dates in five different formats, such as a numeric format, the common dd.mm.yyyy format, which is familiar to us and convenient for data analysis, the month represented as both a number and text, and the year.

formats. 📅

If you want to revisit the information covered in the video, here's an 👉e-book with step-by-step explanations for you.

How to connect to Google Sheets in Power Query?

How to connect to Google Sheets in Power Query?

Selecione a resposta correta

Tudo estava claro?

Como podemos melhorá-lo?

Obrigado pelo seu feedback!

Seção 1. Capítulo 5
some-alt