Join Rudolph Rosenberg for an in-depth discussion in this video Using the exercise files, part of Financial Analysis: Analyzing the Bottom Line with Excel.
If you are a premium member of the lynda.com online training library, you have access to the exercises used throughout this title. The exercise files are organized into folders by chapter, and into further folders by each video. For each video, where we'll be using Microsoft Excel. You'll be presented with a starting file that matches what the file looks like at the beginning of the video. In a finished file, that you can compare to your work, which shows what the file looks like at the end of the video.
If you are a monthly member, or annual member of lynda.com, you don't have access to the exercise files, but you can follow along from scratch using your own spreadsheet information. Now, let's get started.
Also check out the companion course, Financial Analysis: Analyzing the Top 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.
- Finding data points
- Prepping data
- Calculating standard cost and gross margins
- Analyzing overall gross margin performance
- Analyzing individual and overall expenses