Excel 2007: Financial Analysis

with Curt Frye
please wait ...
Excel 2007: Financial Analysis
Video duration: 0s 2h 18m Intermediate


Numbers and financial data drives today's business world and Excel 2007: Financial Analysis can help decode this information. The proper understanding of these numbers, and the formulas behind them, can be the gateway to corporate and personal success. Microsoft MVP (Most Valuable Professional) Curt Frye teaches basic fluency in corporate finance, enabling users to see the meaning behind essential financial calculations. Curt explains how to review formulas to ensure they have the proper inputs, and shows how to interpret formula output. He also covers how to calculate leverage ratios and amortization and depreciation schedules, as well as forecast future growth. Exercise files accompany this course.

Topics include:
  • Building a financial worksheet with Pivot Tables Reviewing financial statements through common-sized balance sheets Calculating percentage change over time in financial statements Determining profitability ratios and return on investments Studying liquidity and activity ratios through an average collection period Computing the future value of an investment


- [Voiceover] Hi, I'm Curt Frye, and I'd like to welcome you to Excel 2007 Financial Analysis. In this course I'll identify the most essential calculations and formulas that you will need to perform common financial analysis tasks in Excel. We'll begin by looking at the best way to set up your worksheets and to troubleshoot common mistakes. I will show you how to use special tools in Excel such as Pivot Tables and Excel Tables to organize and analyze data. We'll get you comfortable reading financial statements, then look at techniques for comparing data from the financial statements of different companies.

I will show you how to implement several ratio and interest rate calculations, as well as look at several techniques for predicting future performance, and analyzing bond investments. Financial Analysis in Excel requires a basic knowledge of implementing formulas and formatting data in an Excel worksheet. If you're not familiar with these areas you might want to check out Excel 2007 Essential Training before watching this course. As a Microsoft Most Valuable Professional my goal in this course it to help you unlock Excel's ability to support your work as a financial analyst. Now let's get started with Excel 2007 Financial Analysis.

please wait ...