Learn how Excel functions can act as data using LAMBDA, LET, and BYROW, so you reuse logic and cut formula edits.

Have you ever found yourself staring at a massive spreadsheet, wondering how to extract just the right information without getting lost in a sea of data? Whether you’re a seasoned Excel user or just ...

A while ago I found myself wondering – as I often do about this kind of thing – about what the undocumented third parameter of the Excel.Workbook() M function (called delayTypes) actually does. I ...

How to combine data ranges with Microsoft Power Query in Excel Your email has been sent Microsoft Power Query showed up in Excel 2016, though earlier versions can ...

Query parameters are, in my opinion, one of the most important features added to Power BI recently. The official blog post describing how to use them is great (read it if you haven’t done so already) ...

How to combine values from a column into a single cell using Microsoft Excel’s Power Query Your email has been sent The article How to concatenate values in a single Excel column to a single row shows ...