Financial Analysis Tools in Excel

Audit Excel offers a two day practical financial analysis and modelling course at various centres around the country. Anyone who has to budget, forecast, compare financial statements, make financial projections, and do financial analysis will benefit from attending the course.

Some of the topics covered in the financial analysis and modelling course are briefly listed below:

• Working with various time periods.
• Handling aspects such as sales prices and inflation rates.
• Doing income statement forecasting with aspects such as depreciation, variable costs, sales margins, and volumes taken into consideration.
• Analysing the balancing sheet with fixed assets, debt schedules, and more.
• Reviewing the cash flow.
• Doing valuations.
• Setting up sensitivity scenarios.
• Changing reporting periods.

Learn about tools in Excel 2003 and 2007 through our advanced courses. You can attend the advanced courses, purchase some of the courses right here or learn about a few of the tools through our free section including tools such as IRR and NPV.

Understanding the various functionalities offered by Excel for the purpose of financial analysis is extremely important for auditors, book keepers, financial advisers, bank managers, and company owners alike. We make it as easy as possible through online courses, CD-Rom based instruction, and advanced hands-on two day courses. Employers that want to establish whether their personnel have the required skills in the usage of Microsoft Excel will want to take advantage of our Excel Aptitude test. This test makes it possible to assess the financial analysis skills of employees using Excel. Contact us today to book a course, learn more about the aptitude test or to obtain a quote for in-house training.