Analyzing Sales Data with Vlookup, Sumif, Concatenate, Drop Down, and named Range

QuickBooks gives us some great reporting options, but in some cases when we really want to take the analysis a step further it makes more sense to export a report into excel and then format it so we can write some formulas to give us meaningful analysis.

Here's The Original Web Cast:
http://nerdenterprises.adobeconnect.com/p16666050/

Here is the link directly to the post:
http://nerdenterprises.com/blog/2010/05/analyzing-sales-from-quickbooks-to-ex...

Category:

Howto & Style

Tags:

• vlookup
• sumif
• drop down
• named range
• concatenate
• analyze sales