Tutorial: Import data from Exchequer into Excel, Part 2. By David Carter
In his second tutorial of this two-part series, David Carter shows how to use AutoFilter and pivot tables to analyse data extracted from the Exchequer accounting system.
In part one we exported transaction data such as sales and purchase invoices from Exchequer into Excel. We used Excel’s Import External Data command for this rather than File-Open. This has two key benefits.