Basic Financial Modelling with Microsoft Excel

Microsoft Excel is the tool of choice for most accountants and financial professionals, and possessing advanced Excel skills can make a real difference to your career prospects. However, many bookkeepers and financial officers lack the fundamental Excel skills required to carry out daily tasks efficiently and accurately. These abilities include the use of logical tests and ‘IF’ statements, lookups and pivot tables.

Course Overview

This course has been designed and developed by an accountant and focuses on the Excel skills used daily in the industry. Some of these basic skills include summing with criteria and using logical tests. However, some are advanced, like the use of dynamic arrays. Each of our topics represents a necessary ability for the job and familiarity with some of the newer features of Excel 365 can put you ahead of the curve. This training program will enable participants to acquire the practical knowledge required to build reliable financial models that can be applied to corporate planning and evaluation. Participants will learn best practice design concepts for designing adaptable models using a variety of financial modelling in Excel techniques and functions that are used when creating a complete financial model from scratch.

What you’ll learn
  • Prepare effective financial models utilizing powerful Excel functions.
  • Use core financial modelling techniques,
  • Create Scenario Analysis and Dash Boards
  • Understand and apply Forecasting concepts and be able to track forecasting errors
  • Forecast investments, and calculate valuations of projects and companies in an effective manner
  • Develop comprehensive financial models to support investments decision
Requirements

Candidates must;

  • Be proficient in English Language.
  • Have access to either a computer or smartphone with internet connectivity.
  • Be equipped with quality webcam and headphones.
Duration & Fees
  • Regular – 10 Weeks – ₦170,000
  • Fast-Track – 8 Weeks – ₦255,000
Program Dates
  • August – October, 2024
  • October – December, 2024
  • February – April, 2025
  • May – July, 2025