Lynda.com - Financial Analysis Analyzing the Bottom Line with Excel-ELOHiM
Genre: TUTORiAL | Size: 208MB
Learn how to analyze the bottom line (or profitability) of your company and identify areas of under- or overperformance with Excel. Rudolph Rosenberg, author of the Financial Analysis series, shows how to use the data your company generates every day to break down your gross margin and operating expenses. He introduces the tools and techniques you can use in Excel to prepare and analyze that data, including PivotTables and the invaluable SUMIF function. Plus, you'll learn to identify and analyze sales and marketing spending, staff expenditures, and productivity separately, so you can get a really clear picture of your data from multiple angles.
Want to learn more about financial analysis? Check out Financial Analysis: Introduction to Business Performance Analysis and Financial Analysis: Analyzing the Top Line with Excel.
* Finding data points
* Prepping data
* Calculating standard cost and gross margins
* Analyzing overall gross margin performance
* Analyzing individual and overall expenses