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

Connecting 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.

question mark

How to connect to Google Sheets in Power Query?

正しい答えを遞んでください

すべお明確でしたか

どのように改善できたすか

フィヌドバックありがずうございたす

セクション 1. 章 5

AIに質問する

expand

AIに質問する

ChatGPT

䜕でも質問するか、提案された質問の1぀を詊しおチャットを始めおください

some-alt