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
