Viewers: in countries Watching now:
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.
This course qualifies for 1.5 Category A professional development units (PDUs) through lynda.com, PMI Registered Education Provider #4101.
Hi. I'm Rudolph Rosenberg, and welcome to Financial Analysis: Analyzing the Bottom Line with Excel. In this course, we'll look at a very practical technique to analyze the profitability of a company, and learn how to identify the sources of under or over performance. To do so, we will be talking about financial concepts necessary to the understanding of gross margin and operating expenses performance.
And learning techniques using Microsoft Excel to gather, prepare and analyze data that every company has access to. Now, let's get started with Financial Analysis: Analyzing the Bottom Line with Excel.
There are currently no FAQs about Financial Analysis: Analyzing the Bottom Line with Excel.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.