Viewers: in countries Watching now:
Learn how to analyze the top line (or revenue) of your company and identify areas of under- or overperformance with Excel. Author Rudolph Rosenberg explores essential financial concepts that are necessary to understanding your company's revenue data. Then he introduces the tools and techniques you can use in Excel, including PivotTables and the invaluable SUMIF function, to prepare and analyze the data you have available. Plus, learn how to analyze your customer base, determine revenue per product, and identify upsell opportunities. Rudolph will also show how to make sure you're treating your data fairly, by considering the impact of seasonality, recurrent vs. one-off business, and interdependencies.
Want to learn more about financial analysis? Check out Financial Analysis: Introduction to Business Performance Analysis and Financial Analysis: Analyzing the Bottom 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 Top Line with Excel. In this course, we'll look at a very practical technique to analyze the top line, or revenue, 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 revenue 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 top line with Excel
There are currently no FAQs about Financial Analysis: Analyzing the Top 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.