Course Content
Excel for Finance
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.
Thanks for your feedback!