Use formulas instead of Power Query for tidy files, with a visible source path and clear parameters that teammates can review ...

One formula filters, dedupes, and ranks your data into a live list. No more manual sort or remove duplicates.

It may be a surprise to learn that you can define names of cells in Microsoft Excel instead of using the letter and number combinations. This makes it friendlier to read and understand. For example, ...

Create robust, backward-compatible Excel workbooks by leveraging the structural power of the ROWS function.

My main program is the Excel Pro Challenge. It is a 15-day step-by-step course that takes you from beginner to confident — ...

We will keep our notes and code on dealing with censored variables in Bayesian models in this repo. My initial idea for this is that we can basically treat each worked out example or section that we ...