The January 2017 JofA article “Data Mining Your General Ledger With Excel” presents a step-by-step, formula-based approach to extracting general ledger data and then scrubbing them so that they can be ...
Originally, Excel was not designed to be a real database. Its early database functions were limited in quantity and in quality. And because every record in an Excel database is visible on the screen ...