See what our students are saying! "I liked the in depth demonstrations on how the program is designed to work." T.R. "I loved the recipes developed for every day data problems in business." Elizabeth B. Power Query Academy - Intermediate to Advanced skillwave.training (Skillwave Training logo)

See why students love our flagship #PowerQuery course! 🥰
We'll help you unlock the true power of your data with Power Query in #Excel and #PowerBI! Say goodbye to hours of manual #DataManipulation and hello to quick #DataInsights and informed decisions. Join us today: skw-t.com/pqa

It's no secret that the #PowerQuery editor locks your #Excel instance while it's open. This means that you can't change or select a different worksheet while using PQ. In this video, I'll give you some alternate methods of interacting with Excel: www.youtube.com/watch?v=bKBe...

#DataAnalysis

A wave of new Dataflow Gen2 capabilities at FabCon Atlanta 2026 | Microsoft Fabric Blog | Microsoft Fabric At FabCon Atlanta 2026, we’re sharing a wave of Dataflow Gen2 announcements designed to help every data team move faster—from self-service analysts to centralized data engineering teams. Dataflow...

A wave of new Dataflow Gen2 capabilities at FabCon Atlanta 2026 by Miguel Llopis #PowerQuery #microsoft #PowerBI blog.fabric.microsoft.com/en-US/blog/a...

It's no secret that the #PowerQuery editor locks your #Excel instance while it's open. This means that you can't change or select a different worksheet while using PQ. In this video, @excelguru.ca will give you some alternate methods of interacting with Excel: www.youtube.com/watch?v=bKBe...

The Gap Between Basic and Advanced Pivot Tables by Chandeep Chhabra #PowerQuery #Data #PowerPivot #excel #PowerBI www.youtube.com/watch?v=1Iy3...

Less GUIDs: Relative Current Workspace & Items By Name by Ben Gribaudo #PowerQuery #PowerBI bengribaudo.com/blog/2026/03...

Me: Opens #PowerBI, starts working in #PowerQuery.

PBI, shortly thereafter: This preview may be up to 2 days old. Refresh.

Me: 🤨

News From the Data Monkey Brought to you by Excelguru and Skillwave Training (Image of a cyborg monkey in a superhero type crouch) March 24, 2026 In This Issue: • New Video to Show Blank Values in Excel PivotTables • From the AKA Sessions • What's New in Power BI • Latest Meet-up Recording and Next Event Information • Upcoming Courses and Conferences • Available Training Options The finalists for this year's Global Excel Awards have been announced and Ken's super proud to be included in 2 categories: o Ken Puls for Training Provider of the Year o Monkey Tools for Best Excel Add-in It's a real honour to be recognized along with these other great trainers and add-ins. A big thank you to Global Excel Summit for once again running these awards, and to everyone who submitted nominations! Public voting is now open until April 30, 2026 - learn more about all of the categories and finalists, and cast your vote here: https://globalexcelsummit.typeform.com/to/thGGWX91

Our latest newsletter is hitting inboxes right now! 📧
If you'd like to stay up-to-date on what's new in #PowerBI and #Excel, content from our experts, and information on courses, events, and promotions, sign up at skw-t.com/news. We'll also send you our free #PowerQuery eBook. 📘

Classic PQ pain! Try wrapping your column references with Text.Lower() or Text.Upper() in your merge/filter steps. Something like Table.AddColumn(t, "Match", each Text.Lower([Column])). That way you normalize before comparing and casing stops breaking everything. #PowerQuery #Excel

Everyone Sucks at Power BI until They Learn This! by Chandeep Chhabra #PowerQuery #excel #PowerBI www.youtube.com/watch?v=wVZ_...

Great starting point! One tip as you go: after cleaning, add a custom column with a "data quality flag" to mark rows that needed fixes. Makes it much easier to audit later and explain your transformations to stakeholders. #PowerQuery #DataAnalytics

Combinas datos de varios ficheros en Power Query y cada uno tiene las columnas con nombres distintos?

No hace falta renombrar a mano. Hay una forma mucho mas limpia de unificarlo todo automaticamente.

https://www.youtube.com/watch?v=3NbIAXOC6EU

#Excel #PowerQuery #Influexcel

At the core of every BI solution is the Data Model. But do you really know how to work with is properly? Dimensional Modeling for the Excel and Power BI Pro Start Learning (Image of a many setting in front of a laptop looking up and to the left thoughtfully with his chin in his hand) (Skillwave Training logo)

Unlock the power of #DimensionalModeling by learning the right way to build solid and scalable Data Models in #Excel and #PowerBI. 💪 This on-demand training brings together #PowerQuery and the #DataModel for powerful #BusinessIntelligence.
➡️Enroll today at skw-t.com/modeling

#DataModeling

Level up your #PowerQuery documentation game by adding Emojis and info icons to your Power Query steps. 😎The Data Monkey and I will show you how in this latest episode of Monkey Shorts! www.youtube.com/watch?v=PazQ...

#Excel #PowerBI #DataAnalyticsTools

En Power Query, cuando te llegan números como texto, usa Number.From en vez de Cambiar Tipo.

Number.From falla solo en la celda con problema.
Cambiar Tipo puede romper toda la columna.

Pequeño detalle, gran diferencia 💡

#Excel #PowerQuery #Influexcel

Turn your food supply data from a mess into a masterpiece. 🥗📈 Master Power Query automation!

📃 scriptdatainsights.blogspot.com/2026/03/exce...
🎞 youtube.com/shorts/5qjzJ...
🛒 scriptdatainsights.gumroad.com/l/march-skil...

Stop cleaning data manually. Let the machine do it. 🤖👇

#Excel #PowerQuery

Level up your #PowerQuery documentation game by adding Emojis and info icons to your Power Query steps. 😎 @excelguru.ca and the Data Monkey will show you how in this latest episode of Monkey Shorts! www.youtube.com/watch?v=PazQ...

#Excel #PowerBI #DataAnalyticsTools

a man is making a funny face with his mouth open ALT: a man is making a funny face with his mouth open

That feeling you get when you reduce an Excel file size from 106MB to 65KB by simply using #PowerQuery

...Coz i #PowerQueryAllTheThings 🔥

Tienes datos repartidos en bloques con cabeceras distintas y necesitas juntarlo todo en una sola tabla? La comunidad lo resolvió con Power Query y con fórmulas puras. Dos enfoques, mismo resultado 👇

influexcel.com/?case=a3f5ba63-d813-4a67-8b76-15646f8c3057

#Excel #PowerQuery #Influexcel

IMPORTCSV IMPORTTEXT - Excel University Explore Excel tips and tutorials at our blog. Sharpen your Excel skills and learn how to get your work done faster!

IMPORTCSV IMPORTTEXT by Jeff Lenning #PowerQuery #excel #PowerBI www.excel-university.com/importcsv-im...

Welcome to the club! Wait until you discover M language in the Advanced Editor. That's when Power Query goes from "wow" to "how did I ever live without this." Pro tip: learn to use List.Generate and Table.Combine early, they'll save you hours. #PowerQuery #Excel

It is pretty common to use the drop down arrows 🔽 when filtering content in #PowerQuery. But do you pay attention to what Power Query actually does when you do this? 🫣
Here, I show how can get burned, as well as how you can take granular control to set up filters:

100%! Power Query is a game changer. The moment you realize you can connect to multiple sources, merge tables, and refresh everything with one click... there's no going back to manual copy-paste. It's like discovering a superpower you always had but never used. #PowerQuery #Excel

Once you get comfortable with the Advanced Editor, try using "let" to chain steps manually. It gives you way more control than the UI, especially for custom columns and conditional logic. The M language is surprisingly powerful once it clicks! #PowerQuery #Excel

It is pretty common to use the drop down arrows 🔽 when filtering content in #PowerQuery. But do you pay attention to what PQ actually does when you do this? 🫣
@excelguru.ca shares how you can get burned, as well as how you can take granular control to set up filters:

I've been having a great week doing some consulting work and leading a #PowerQuery course for a private client. There's nothing better than introducing people to the #DataCleaning and #DataPreparation magic performed by Power Query! 📈🧹

Contact us for private team training: excelguru.ca/contact-us/

¿Ajustas las conexiones de Power Query cada vez que compartes un Excel?

Con la función CELDA + rangos con nombre puedes hacer que las rutas se actualicen solas. Nunca más ajustes manuales 👇

https://youtu.be/fuLnCjmCQUY

#Excel #PowerQuery #Influexcel

Monkey Tools Build better data models, faster Developed by Excelguru (Image of a cyborg monkey with its fist up for a fist bump) Create Query From M Code This Monkey allows you to create and configure a query from M code, without ever leaving the Excel interface! Just launch the Monkey, give the query a name, and past the code into the formula box. Plus, it automatically indents the code so it's easier to read! (Screenshot of the Create Query from M Code dialog with a query name of "Budget" in the Name field and the indented and coloured M code below, along with the other options such as load destination, formatting options, and what action to take if the query exists.) monkeytools.ca

If you want to reuse a query, it can be tedious to open #PowerQuery, then the Advanced Editor, then paste, close, rename, and finally choose load destination. 😫
The “Create Query From M Code” Monkey will create the query for you without ever leaving the #Excel interface! 🙌 See how at mkyt.ca/mquery

The thing where adding a null to a value gives a null is a real weakness in #PowerQuery. How many people have missed this & not realised I wonder? Anyway, easy fix: use the coalesce function, or just put a ?? 0 after each column name that might contain a null.
See www.youtube.com/watch?v=-FQr...

Great pattern! Another trick: if you want to keep the zeros visible but exclude them from Count, use COUNTA on a column where you replaced 0 with null, and keep the original for display. Best of both worlds. Power Query makes this kind of dual-column approach trivial. #PowerQuery #Excel