a Sift Media publication

Free Downloads
Check out our library of free whitepapers available for immediate download

AccountingWEB US blogs

Using Excel Query

Back to blog homepage for: Captain Excel

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.

AttachmentSize
excel-query_081009.xls486 KB

Create your free account

  • Access all articles in full
  • View multimedia
  • Receive email bulletins
  • Private messaging
Register now

Login

Forgotten your password?