Start learning with our library of video tutorials taught by experts. Get started
Viewed by members. in countries. members currently watching.
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.
(Music playing.) 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 the common mistakes. I'll 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'll 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 is 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.
There are currently no FAQs about Excel 2007: Financial Analysis.
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.