Tutorial: Import data from TAS Books into Excel - Part 2. by David Carter
In the first of this two part series David Carter showed how to get nominal transactions out of TAS Books and into Excel via Excel’s Data – Import External Data command. In this second tutorial he shows how to use an Excel pivot table to analyse the data and (if you want it) to provide job costing analysis
In part one we exported nominal transaction data from TAS into Excel. We used Excel’s Import External data command for this rather than File-Open. This has two key benefits.