Excel 2007: Financial Analysis

NB: There are Video Tutorials supporting this eBook. Link to video training is inclusive.

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) Cortés Farey teaches basic fluency in corporate finance, enabling users to see the meaning behind essential financial calculations. Cortés 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;
• And many more...

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

The skills acquired from this version are mostly applicable to newer versions of Excel.

If you think that Microsoft Excel is only for business purposes, you are wrong. Many use it for various personal needs at home too. Some of the features that you should understand about Microsoft Excel to unlock the potentiality of this application are working with spreadsheets, cell formatting, various menus and toolbars, entering of data and editing the same, navigating between various spreadsheets, formula calculation, inserting various functions like date/time, mathematical functions, using of various charts that are available, inserting, editing and deleting comments on cells, etc.

Computer Based Training (CBT) is a way to master MS Excel. This is where you take your own time to master the application. With the help of CBT, you get realistic, interactive and complete training. You get to learn right from what a beginner should learn to advanced level. Once the training is over, you would have mastered Microsoft Excel. You get to see simulations of Microsoft Excel application software. Some CBT also offer review quiz questions to gauge your understanding. CBT generally offer interactive, complete and comprehensive training. As it offers practice questions, you will be able to understand better and gain confidence in using the application. According to me, this is one of the best ways to learn Microsoft Excel.

The concept of spreadsheeting has been around for hundreds of years. The process can be described as the ability to arrange numbers, characters and other objects into rows and columns. It is most common that spreadsheets only contain numbers and text. The software version of spreadsheeting basically takes the manual processes described above and puts them into an electronic format. Whilst the accounting industry which most commonly uses spreadsheets they can be used in any situation.

Dettagli