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

Course Content

Excel for Finance

Excel for Finance

1. Introduction to Power Query
Course IntroductionUnderstanding Power Query in ExcelGet DataConnecting to the Excel WorkbookConnecting to the Google Sheets
2. Advanced Data Manipulation with Power Query
Seamless CSV IntegrationConnecting to a FolderConnecting DatabaseConnecting to the WebError Handling in Power Query
3. Power Pivot Handling
Loading Data to the Data ModelCreating RelationshipsCalculating MeasuresAdditional DAX Calculations
4. Dashboard Automation
Getting Started with the DashboardDashboard DevelopmentIntegrating KPIsIntegrating Slicers
5. Developing an Interactive Report
Dropdown ListExcel FormulasFinalizing ReportPower BI Overview

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

Everything was clear?

How can we improve it?

Thanks for your feedback!

SectionΒ 2. ChapterΒ 3

Ask AI

expand

Ask AI

ChatGPT

Ask anything or try one of the suggested questions to begin our chat

course content

Course Content

Excel for Finance

Excel for Finance

1. Introduction to Power Query
Course IntroductionUnderstanding Power Query in ExcelGet DataConnecting to the Excel WorkbookConnecting to the Google Sheets
2. Advanced Data Manipulation with Power Query
Seamless CSV IntegrationConnecting to a FolderConnecting DatabaseConnecting to the WebError Handling in Power Query
3. Power Pivot Handling
Loading Data to the Data ModelCreating RelationshipsCalculating MeasuresAdditional DAX Calculations
4. Dashboard Automation
Getting Started with the DashboardDashboard DevelopmentIntegrating KPIsIntegrating Slicers
5. Developing an Interactive Report
Dropdown ListExcel FormulasFinalizing ReportPower BI Overview

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

Everything was clear?

How can we improve it?

Thanks for your feedback!

SectionΒ 2. ChapterΒ 3
some-alt