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.
Save Time. Automate Your Payroll.
A full day of manual payroll work, replaced by a one-click import, a rules-driven control panel, and automated driver reports.