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

Connecting Database

メニュヌを衚瀺するにはスワむプしおください

In this quick chapter, we're going to practice connecting to an Access Database. 🌟

Here's an e-book with step-by-step explanations for you.

Access Database Overview

Download the 'Sales 2024' database which includes two tables: 'Sales 2024' details sales data from 30 bakeries for the first half of 2024 and 'Sales 2023'.

Excel Workbook for macOS:

This file will be invaluable for our future calculations and statistics.

Note

If you don't have access rights to the database, Power Query won't be able to connect to the source.

すべお明確でしたか

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

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

セクション 2. 章 3

AIに質問する

expand

AIに質問する

ChatGPT

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

some-alt