Using Excel Query

Share this content

One can go "FAR" in today's world of financial reporting if one can get Fast, Accurate & Reliable data to manage. Microsoft query is a means to create a report made from elements of multiple databases. This exercise will show how to write a query in Excel. The example will link two Microsoft Access tables , and use a pivot table using a calculated field to reconcile the difference. For your convenience, this tutorial is available for download.


Please login or register to join the discussion.

There are currently no replies, be the first to post a reply.