Excel – Testing Equivalences

I spend my working life implementing Maconomy, BizView, and other ERP and data analysis systems, and I often have to clean and prepare data sets for importing to database tables. This nearly always involves constructing a clean data set in an Excel sheet – often from more than one source – and for this work there are a number of methods I use time and again. Continue reading “Excel – Testing Equivalences”