ViewTube

Automate Excel consolidation with Power Query (without VBA) Tired of manually consolidating your Excel tabs? 😩 In this video ...

Hello, In this video, you will learn how to extract data from a source using Power Query. This will allow you to replace ...

Power Query Excel: Automatically consolidate multiple workbooks In this Excel video, I'll show you how to consolidate ...

Learn 3 methods for removing all blank rows and columns from a table of data. This dynamic method works regardless of the ...

Missed another dinner? Let's Fix That. Subscribe to my free weekly newsletter now and get my free guide: 15 5-Minute Finance ...

Download the free demo file and follow along here ...

In this video I will show you step by step how to use a mapping table to rename you columns dynamically in Power Query ...

... + Power BI to automate the parts of your job that waste the most time: -Cleaning messy data -Prepping datasets in Power Query ...

In this video, I'm sharing 12 of the best Power BI tricks of 2025 that will help you improve Power Query, write smarter DAX, and ...

Stop choosing between Power Query and Python. Most Excel users are unaware that there's a direct link between the two. This ...

In this step-by-step tutorial, you'll discover how to create flexible data groupings without complex formulas or manual effort. Perfect ...

Do you want to learn Power BI? Check out our amazing course at https://accessanalytic.thinkific.com/ Microsoft Docs Official link: ...

Split Column into Rows Like a Pro - Power Query Challenge 104 In this Power Query challenge, we'll transform a messy column ...

Working out a person's age from a date of birth or calculating full years of service from an employee start date or finding out how ...

Are you frustrated trying to fix messy date formats in Excel one by one? Stop wasting hours on manual data cleaning! In this ...

Download: 1) Excel File: https://excelisfun.net/files/EMT1917-1919.xlsx 2) Zipped Data Folder: ...

Welcome to the third episode in my Power BI Beginner Series! In this video, I'll show you exactly how Power Query works, how to ...

Power Query functions are very picky about inputs. If a function expects a list, you must give it a list. If it expects a nested list, ...

The arrival of Microsoft Copilot AI in Excel is a game changer. But can it truly replace the power of Power Query for data ...

If you've ever had a Power Query break because column names changed, you're not alone. Hard-coding column references ...