From the course: Excel: Market Research Strategies

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Organizing sales data

Organizing sales data - Microsoft Excel Tutorial

From the course: Excel: Market Research Strategies

Start my 1-month free trial

Organizing sales data

“

When it comes to doing market research in the real world, anyone dealing with this area needs to be able to take data generated by the business and then clean up that data for use in market research analysis, including things like understanding and estimating a demand curve. Let's look at how that process works. I'm in the 01_03_Begin excel file. Now what we see here is data from a firm related to all the sales they've made over time. This particular company, a fictional firm, to be called Red Tech Third provides a variety of different high-tech products, including drone blueprints. Now what we see is the firm has two major products that we're looking at this particular case. Product 102 and product 101 which are blueprints for two different drones, the Bsquare Blueprint and the All Eyes Drone Blueprint. And we see, as you'd expect from most sales reports, the level of sales on any particular day for a particular product.…

Contents