Join Rudolph Rosenberg for an in-depth discussion in this video Determining revenue per product, part of Financial Analysis: Analyzing the Top Line with Excel.
…So let's do that reality check and…look at the revenue that we'll have been generating from each of our products.…To do so, let's first create a pivot table.…So we'll go into the insert menu and click on pivot table.…As we've seen in the past the information is automatically selected and…we'll just check that we have the new worksheet selected and click OK.…On our pivot table now, we want to select the product that we can find…in the product name field and drag it down into the rows section of the pivot table.…Now we want to take the discounted price and put it into the values section.…
Again the format is not looking great as it is,…so let's go into sum and value field settings.…Then, let's check that Sum is selected, which is fine.…And then, Number Format.…And now into the Numbers Section, and click on Use 1000 Separator.…And click OK.…Then, click OK again.…Now that the formating is done, we know that we have here the revenue again for…both years, 2013 and 2014.…So.…As we've seen in the previous videos, we're going to first separate the two…
Also check out the companion course, Financial Analysis: Analyzing the Bottom Line with Excel.
Lynda.com is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.
The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
- Preparing your revenue information
- Comparing past performance
- Analyzing customer data
- Analyzing product information
- Identifying exceptional revenue