Inside the workbook

What makes The New Excel new?

Explore the structures, Lambdas, and functions that bring my approach to Excel to life.

How many values fit in a cell? Until now, one. A curtain pricing tool shows the hoops that required, and how lists and arrays remove them.

Excel cells can now hold lists and arrays. That opens up new possibilities, and makes it matter more than ever who designs your spreadsheet.

Excel is not a database . . . until it is. A closer look at reading and updating records, and the Power Query code behind them.

A self-referencing Power Query turns Excel into a working database. Create, read, update, and delete records without ever leaving Excel.

How do you get several values out of one formula? LET encodes them together, so a real estate valuation model can decode and reuse them anywhere.

One custom LAMBDA brought structure and flexibility to a multi-leg scheduling workflow.

Want this kind of thinking applied to your business?