Dave Bruns
Working full time on Exceljet
📋 Biography
I founded Exceljet in 2012 and have been working on the website for more than 10 years. The goal of Exceljet is to help ordinary people use Excel faster and more effectively. Exceljet now has several thousand pages and includes about 450 short videos. Excel is a complicated beast and I am especially interested in ways to reduce this complexity. I try hard to find the best solution to a given problem and then describe the approach in a way that is clear and concise. I assume people are busy and need to get on with things. Using Excel to solve a hard problem can feel like magic, and I want to help more people to have that experience.
✨ High-Impact Contributions 5
Article showing how to replace Excel's undocumented and buggy DATEDIF function with reliable alternatives using modern formulas with LAMBDA and LET.
Comprehensive article explaining how arrays work in Excel, covering array formulas, dynamic arrays, spilling, the implicit intersection operator, and practical examples.
Excel doesn't provide a built-in function to convert numbers to words, but you can create your own using the LAMBDA function. In this article, I demo you how to build a custom NumberToWords function that converts numbers like 1234 into "One thousand two hundred thirty four", up to trillions. Very detailed example with optional currency formatting for USD, EUR, GBP, and JPY.
Article showing how to model the 4% retirement withdrawal rule in Excel using formulas, with scenarios for different withdrawal rates, inflation, and portfolio returns. This article builds a complete Excel model with three different approaches, from classic row-by-row formulas to modern dynamic arrays to a single formula that generates the entire 30-year schedule. These models are fully functional, so you can play with the inputs and see how things work yourself.
Article covering Excel's new native checkbox feature including how to insert checkboxes, link them to formulas, use them in conditional formatting, and differences from legacy form controls.