Power Query in Excel [case: Cash Flow]
Master Excel + Power Query + SQL in one place 👉 https://url.joviano.com/vycm1
[Access also through bio]
You will be able to practice the power of Power Query directly in your Excel, creating Cash Flow scenarios.
You will see that Power Query is not just a leftover from Power BI, and that combined with Excel, it opens up an unimaginable horizon.
This lesson is complementary to this post on my BLOG 👉 https://url.joviano.com/aq6he
All the LINKS mentioned in the lesson are in this POST.
_
🎬 SCRIPT
00:00 Presentation
00:10 Introduction
00:30 Power Query in Excel
01:20 CASE Presentation: Cash Flow with Power Query
02:00 Cash Flow Databases and Parameters
03:02 Bonus Content 1: Free Power Query Course
03:27 Bonus Content 2: How to Download and Install Power Query
03:40 Loading Excel Data into Power Query
04:43 How to View and Load All Excel Tables into Power Query [Excel.CurrentWorkBook]
07:07 Invert Sign [Negative Value] with Power Query
07:30 Transforming Multiple Columns into Rows with Power Query
07:56 Changing Column Names in Power Query
08:19 Joining Multiple Queries [Tables] into One with Power Query [Add Queries | Union | Union] Table.Combine]
08:50 Creating a custom column in Power Query specifying the source of the added table
10:26 Loading a Power Query table into a PivotTable in Excel
11:18 Changing parameters and recalculating [Update] the Cash Flow Scenario AUTOMATICALLY with Power Query
12:25 Calculating and inserting taxes and commissions in the Cash Flow Scenario
12:35 Creating variables with the parameter values [Drill Down in Power Query]
13:18 Viewing the Query Dependencies in Power Query [where the information came from and where it went]
13:45 Creating a table with tax calculation
14:53 Creating a table with commission calculation
15:15 Viewing the Query Dependencies in Power Query [after new tables were created and added]
16:35 Changing tax percentages and recalculating the cash flow scenario with Power Query
17:16 The advantage of using Power Query in Excel
18:02 How to create an AUTOMATED BUSINESS BUDGET, with scenarios in minutes
18:36 Final Considerations