Reading and Updating an Excel Database
Excel is not a database. . . until it is. Self-Referencing Queries – SRQs – allow Excel to easily execute the four standard database functions: Create Read Update, and Delete C
Making an Excel Database
Power Query is one of the most powerful tools inside Excel today. You’ve probably used Power Query to import sales, customer, or payroll data into Excel. If you need to import da
Encoding and Decoding Data with LET
I completed a large project for a real estate company. Together, we created a valuation model for a 1,000+ location commercial property portfolio. Naturally, the workbook contained
Lambda – For Flexible Formulas
Lambda is integral to our work at The New Excel because of the flexibility it adds. Lambda opens the door to a full, multiline programming environment – that supports documentati
The UX is Everything
When creating an Excel spreadsheet, the primary focus should be the user experience. A good spreadsheet: Guides the user through the process of using it. Allows the user to focus o
Excel Should Be Easy
Excel should be easy . . . to use. Maybe not to program, but Excel should be dead easy to use. And it is, if it’s programmed well. Let’s look at a basic, but practical, example
The Excel Paradox – What It Means for You
Excel is the most democratizing productivity application in the world. It empowers users at every level to manage their businesses and accomplish tasks efficiently. Excel is an ins
Why Lambda is Central to the New Excel
At The New Excel, we consider Lambda so essential to the new way of approaching Excel that we’ve integrated it into our logo! But what is a lambda? And why is it so important
