Blog • Excel Database
Excel = Spreadsheet + Database
Structuring Excel to behave like a real, functional database.
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.
