Archive for March, 2010

Download The $2 Paper on Social Media – From Action Plan To Strategy

March 19, 2010 Leave a comment

Social Media – From Action Plan To Strategy

What is My strategy / what do I want?

What can I offer people?

What am I looking for from people?

What are my topics of interest?

Then where do I find the people who meet the criteria set forth above (ie the people who want what I am offering, and the people who are offering what I want)?

This is what you will read and even watch some videos about in this $2 Paper on Social Media – From Action Plan To Strategy

Add this to your cart here I can take you on a brief journey with a year’s worth of my learning all for only $2.

Categories: Uncategorized

Analyzing Sales from QuickBooks To Excel

March 14, 2010 Leave a comment

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.

So the first step is to run a Sales by item detail report in QuickBooks. One of the first things you may notice is that QuickBooks does not total the quantities of the units sold. When I am analyzing sales data for a client that becomes a really important piece of information. How many did I sell and what was the average price? So I can compare with what I am selling it for now. I might very quickly find that I want to lower the price. So knowing how to do this stuff in excel can really help you make intelligent decisions about your business.

Once you export the report in QuickBooks you want to trim it down to just the raw data. Then it becomes fairly easy to write the formulas and create a drop box allowing you to choose a product and instantly get the information you want about that product and it’s sales.

In this video we show you how to write a concatenate formula, a sumif, and vlookup. We also show you how to define a named range and use that range to populate a drop-down inside of a cell.


Click to Download or watch

File Download:

Video Tutorial:

Categories: Data, Formulas, Sumif, vlookup