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
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
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
