Some time ago, I remember seeing a post about a suite of tools for helping excel power users improve thier usage of excel. As far as I remember, it was one developer creating some pretty cool stuff.
activedata for excel free download
Download File
https://xiuty.com/2xwf9i
ActiveData for Excel is a low cost tool packed with power, used by External and Internal auditors to analyze financial data in excel. This blog is QuickBooks/Excel centric, so I will use some examples of analysis that I have done with this tool from my QuickBooks data file.
This basically includes all invoice line items with all available fields into excel. Next Step is to run a few of the Data Analysis/Audit tools from ActiveData Excel Addin, for the first example, I ran the Summarize / Pivot tool, which creates a Pivot Table style report.
f5d0e4f075