Join Rudolph Rosenberg for an in-depth discussion in this video Isolating recurrent vs. one-off business, part of Financial Analysis: Analyzing the Top Line with Excel.
…To find out how to determine what you should call day to day business and…what you should call exceptional business, we will be looking at order level detail.…To do so, let's start with our pivot table with no filter applied to it whatsoever.…And let's select the invoice number and…drag it down into the rows section of the pivot table.…You can see here now that, all our invoices have appeared,…with the relevant revenue that has been generated through them.…And what we want to do here is sort our invoices by ascending order.…So to do so, we'll right click on the invoices and select Sort.…And more sort options.…And here we'll select Ascending and change invoice number to sum of discounted price.…
And then we'll click OK.…Now all our orders have been organized from the smallest to the largest.…The next thing we want to do is calculate what each of…those orders represent as part of the total revenue.…And to do so, we'll click here next to the first one, and select Equal and…B4, which is the revenue of the first invoice.…
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