Excel 2007: Financial Analysis

- [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.