Power Query

From Data To Analysis with Power Query and CUBEVALUE Function

In this project: We combine multiple text files from a folder. Each file contains thousands of records. We clean and Transform the data in Power Query and create an M function. We send the data to the...

Power Query and Data Validation are Much Stronger Together

  In this tutorial  I am bringing multiple files from a Folder, I combine the Files together, clean and transform the data and create calculations in Power Query to return a nice report to Excel....

Splitting Text at the Second Uppercase letter… Functions, Power Query and More

If you have a string of text, like a full name without spaces, and you want to split it into 2 columns: one for the first name and another one for the last name, you look for a pattern, like the chang...

Create a Retirement Report using Functions, Advanced Filter, Dynamic Arrays or Power Query

Retirement Report using Functions, Dynamic Arrays and Power Query To get the best out of Excel, you need to combine the different functionalities together in achieving your goal. In this project, We h...

SUBSCRIBE To Our Emailing List And Receive 3 FREE Gifts...Now

Receive 3 Instant Free Gifts  When Subscribing to our newsletter here below
Two Books( Excel Pivot Tables - Dynamic Charts) and The Magical Shortcuts Quick Reference Card Showing 78  easy to remember Shortcuts.
SUBSCRIBE NOW
close-link