Food Security and Agriculture

Training Course on Finance Modelling using Excel

Course Overview

This comprehensive training course is designed to equip participants with essential skills in financial modeling using Microsoft Excel. Financial modeling is a crucial skill for finance professionals, analysts, and decision-makers, enabling them to make informed and strategic business decisions. Throughout the course, participants will gain hands-on experience in building financial models, analyzing data, and creating insightful reports.

Course Duration:

Online Training: 6 days

Classroom Training: 5 days

Course Outline

Module 1: Introduction to Financial Modelling 

  • Financial modelling fundamentals & Steps in model building
  • Concepts of financial modelling

Introduction to Excel  

  • Using the Options dialog box
  • Customizing toolbars and menus
  • Using relative, absolute and mixed cell references in formulas

Module 2: Excel Tools and Techniques 

  • Cell referencing
  • Naming ranges
  • Linking in excel
  • Using shortcuts

Excel Functions and Formulas in Finance

  • The difference between a formula and a function
  • Understanding to most important functions and formulas
  • Finding the function and you need
  • Advanced functions and formulas

Module 3: Applying Scenarios to Financial Model 

  • The Differences between types of analysis
  • Building Drop-Down scenarios
  • Applying sensitivity analysis with data tables
  • Using scenario manager to model loan calculations
  • Charting and Presenting Model Output
  • Deciding which data to display
  • Conveying your message by charting scenarios
  • Deciding which type of chart to use

Module 4: Building Financial Statements Model

  • Entering assumptions
  • Calculating revenue
  • Calculating expenses
  • Building the Income Statement
  • Building the Cash Flow Statement
  • Building the Balance Sheet
  • Building scenarios

Module 5: Integrating Financial Statements Model 

  • Making a reusable budget model template
  • Creating dynamic titles
  • Calculating cash required for budgeted asset purchases
  • Calculating budgeted depreciation
  • Calculating the written-down value of assets for the balance sheet

Note: This outline provides a general structure for a 5-day training program on Mobile Data Collection using ODK. The specific content, activities, and duration of each session may be adjusted based on the target audience, learning objectives, and available time.

Classroom Training Schedule

Start Date End Date Location Cost Apply
Mar 25, 2024 Mar 29, 2024 Nairobi $ 950 Register
Apr 29, 2024 May 03, 2024 Nairobi $ 950 Register
Jun 03, 2024 Jun 07, 2024 Nairobi $ 950 Register
Jul 08, 2024 Jul 13, 2024 Nairobi $ 950 Register
Aug 12, 2024 Aug 16, 2024 Nairobi $ 950 Register
Sep 16, 2024 Sep 20, 2024 Nairobi $ 950 Register
Oct 21, 2024 Oct 25, 2024 Nairobi $ 950 Register
Nov 25, 2024 Nov 29, 2024 Nairobi $ 950 Register

Virtual Training Schedule

Start Date End Date Location Cost Apply
Mar 04, 2024 Mar 09, 2024 Online $ 400 Register
Apr 08, 2024 Apr 13, 2024 Online $ 400 Register
May 13, 2024 May 18, 2024 Online $ 400 Register
Jun 17, 2024 Jun 22, 2024 Online $ 400 Register
Jul 22, 2024 Jul 27, 2024 Online $ 400 Register
Aug 26, 2024 Aug 31, 2024 Online $ 400 Register
Sep 30, 2024 Oct 05, 2024 Online $ 400 Register
Nov 04, 2024 Nov 09, 2024 Online $ 400 Register
Dec 09, 2024 Dec 14, 2024 Online $ 400 Register

Registration Process

Enrolling in our training programs is effortless! Upon submitting your details on the course registration link, a representative will get in touch with the relevant information.

Group Discounts

Boost your team's skills and maximize value with our attractive group discounts. Enroll 3 or more participants and enjoy significant discounts on any of our training programs.

Course Language

This Training course is offered in ENGLISH . Please indicate the language of choice during registration.

Training Approach

Our instructor-led trainings use well guided presentations, practical exercises, and group acivities. Participants are encouraged to bring any data relevant to their job responsibilities. Training manuals and additional reference materials are provided to the participants.

Certification

Upon completion of training, the participant will be issued with a certificate of Completion.

Post Training Support

Our commitment our clients success extends beyond the training program. We offer ongoing 3 months support through Q&A sessions, online forums, and access to our expert instructors.

Tailor-Made Course

We design customized training programs and inhouse workshops to meet specific training needs and organizational goals. Contact us to find out more: training@perk-gafrica.com