Join Rudolph Rosenberg for an in-depth discussion in this video Preparing the data, part of Financial Analysis: Analyzing the Top Line with Excel.
- View Offline
…Now that we know where to find the data and…what exactly we're looking for, it is time to prepare it for analysis.…To do that, I would first like to show you from a high…level standpoint how this will work.…First, we will extract a data point from all the invoices issued during the time…frame we want to analyze.…For example, if we want to analyze the year 2013 then we need to…take all the invoices with an invoice date between the 1st of January 2013 and…the 31st of December 2013 included.…
Then we will take down the data and put it in a database format in Microsoft Excel.…Then, we will be using two techniques available in…Microsoft Excel to consolidate the data to make it usable.…Those techniques are pivot tables and sumifs.…And last, we will start analyzing the data to get valuable insights from it.…We have previously seen where to get the data we need.…Now we need to put it in a database format.…The reason we need to do this is that, as you have probably already seen, the data,…at this point, is just a very long collection of pieces of…
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