Financial Analysis and Modelling using Excel Course

Finance, Training

Start date

01/03/2021

End date

12/03/2021

Overview

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 the link to view course content https://upskilldevelopment.com/financial-analysis-and-modelling-using-excel-course

What you will learn

Learning 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