Financial Analysis and Modelling using Excel Course

Introduction

This course is designed for existing users of Excel or similar spreadsheet programs needing to vastly increase their modelling & analytical skills especially in the disciplinary areas of Finance, Accounting, Management & Procurement. It is designed to improve the Excel modelling & analytical skills of finance professionals for the forecast, analysis & presentation of business & financial information

Duration

10 Days

Who should attend?

This certificate course is for analysts, financial officers, and portfolio managers seeking a deeper understanding of Valuation, and the skills and knowledge to confidently make financial decisions.

Course Objective:

• Creating professional charts in Microsoft Excel
• Working with large amounts of data
• Understanding Accounting and Bookkeeping principles
• Building a company’s financial statements
• Performing Financial Statement Analysis
• Understanding importance of timing in terms of revenue and cost recognition
• Calculating Liquidity, Solvency, Profitability, and Growth ratios
• Assessing project feasibility
• Calculating a complete loan schedule
• Understanding the difference between variable and fixed interest rates
• Performing industry analysis
• Understanding drives a company’s value
• Analyzing a business

Course content

Click to view course content and out training schedule