Lists and Arrays: Excel Just Got Bigger. So Did the Job.
Excel cells can now hold lists and arrays. That opens up new possibilities, and makes it matter more than ever who designs your spreadsheet.
Reading and Updating an Excel Database
Excel is not a database . . . until it is. A closer look at reading and updating records, and the Power Query code behind them.
Making an Excel Database
A self-referencing Power Query turns Excel into a working database. Create, read, update, and delete records without ever leaving Excel.
Encoding and Decoding Data with LET
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.
Lambda – For Flexible Formulas
One custom LAMBDA brought structure and flexibility to a multi-leg scheduling workflow.
The UX is Everything
A good spreadsheet guides its user and protects its data. Build it for the novice, and the expert benefits too.
Excel Should Be Easy
Excel should be easy . . . to use. A simple scheduling tool walks through the three questions behind every well-built spreadsheet.
The Excel Paradox – What It Means for You
Excel is the most democratizing tool in business. It's also a platform whose real power takes a professional to unlock. Both are true.
Save Time. Automate Your Payroll.
A full day of manual payroll work, replaced by a one-click import, a rules-driven control panel, and automated driver reports.
Why Lambda is Central to the New Excel
What is a LAMBDA function, and why does it matter? LAMBDA encapsulates your unique logic, turning your workbook from a static document into a self-contained application.