The Financial Modeling & Forecasting course is suitable for individuals who aspire to develop their financial modelling and Excel skills. The excel course will cover beginners to advanced tools and functions. The financial modelling module will cover income statements, statements of financial position and cash flow projections. The course will adopt a hands-on approach, and real-life cases will be used to develop models and taught concepts. It is the perfect option for stepping up your career and overall efficiency in Financial Modeling & Forecasting. Skilled financial modellers are in high demand, and are well paid as there is little to no competition in the industry. Hence, enrolling for this Financial Modeling & Forecasting course is an opportunity to increase your earning potential.
Introduction to Financial Modeling & Advanced Excel Functions
What are Financial Models
Types of Financial Models
What is a financial model used for?
Best & Bad Practices in Financial Modelling
Advanced Excel Functions for Building Flexible Financial Models
SUM, SUMIF, SUMIFS, VLOOKUP
INDEX & MATCH, PMT
IF Statement
Data Validation & Duplicates
Income Statement & Statement of Financial Position
Review of Source Data
Introduction to Income Statement
Building the Income Statement output sheet
Populating the Income Statement
Introduction to Statement of Financial Position
Populate the Statement of Financial Position
Forecast Layouts & Calculations
Adding a Forecast Period to the Income Statement
Calculating Historical Percentage Ratios Income Statement
Building a flexible model with Scenario Manager (VLOOKUP) Income Statement
Adding a forecast period for the Statement of Financial Position
Forecasting DSO, DPO, DIO, Other Assets & Other Liabilities
Building Forecasting Schedules & Cash Flow Statements
Building a Fixed Asset Roll Forward
Building the Financial liabilities schedule Sheet
Building the equity schedule Sheet
Building the cash flow sheet
Participants enrolling for this programme will be required to have a minimum of 3 years’ professional experience. Participants who meet the programme requirement should pay the course fee and complete the enrollment form 2 weeks before the programme kick off date.
Requirements:
Prospective applicants who do not meet the programme requirement but want to join the programme should talk to a Career Advisor.
The Financial Modeling & Forecasting Using Excel training approach employs hands-on learning, which imparts the skills required for specific job roles.
The Financial Modeling & Forecasting Using Excel course provides up to 4 months of internship while working on real work projects, which adds expertise and verifiable work references in the resident country.
The Financial Modeling & Forecasting Using Excel course assists participants in securing a job through the development of a professional profile and job prospecting.
Finance Consultant at Alphafortress LLC and Chief Accountant at Refitok Limited • Nigeria
M.Sc. in Accounting; B.Sc. in Accounting; HND in Estate Management; AATWA; ACA (ICAN); FCTI (CITN)
Azeez Owoeye is a highly skilled accounting and finance professional holding an M.Sc. in Accounting, along with AATWA, ACA (ICAN), and FCTI (CITN) certifications. His expertise encompasses a wide range of financial functions, from bookkeeping and financial reporting to tax planning, data analysis (Excel and Power BI), and consulting. Proficient in various accounting software like SAGE, Peachtree, and Tally, Azeez has a proven track record of successful projects, including accounting system conversions, tax filing for various entities, and consulting for the Lagos State Internal Revenue Service. Currently a Finance Consultant at Alphafortress LLC and Chief Accountant at Refitok Limited, Azeez brings a wealth of practical experience and technical expertise to his roles.
Head of Internal Audit and Risk Management at Academy Press PLC • Nigeria
ICAN; ACA; AAT
Chimezie Godstime Onyema is a highly skilled finance professional with ACA and AAT certifications from ICAN, specializing in risk management, internal audit, performance management, and taxation. Known for his innovative and critical thinking, he effectively analyzes complex financial situations and develops strategic solutions. Currently the Head of Internal Audit and Risk Management at Academy Press PLC, and previously Head of Internal Audit and Assurance at Nigeria Law Publications, Chimezie has a proven track record of ensuring organizational financial integrity and operational efficiency. His broad expertise and leadership experience make him a valuable asset to any organization.
Trainer at Piston and Fusion Business Academy • Nigeria
B.Sc. in Microbiology; certifications in Data Analysis, Financial Analysis, and Financial Modelling (DAFM)
Temitope Durojaye is a project management expert, seasoned leader, and passionate mentor with a Master's in Facilities Management and Bachelor's degrees in Electrical Electronics. His expertise includes project management tools and techniques, monitoring and evaluation, risk management, schedule management, and leadership. With extensive experience in the telecommunications industry, including leadership roles at Ericsson Nigeria, Temitope combines practical industry insights with a passion for education. As a sought-after trainer, he effectively bridges theory and practice, equipping learners with the skills needed to excel in project management.
Piston and Fusion offer the Course as Classroom in Lagos and Virtual Online Class in other states in Nigeria. See dates and fees for classroom and virtual online class.
17th Mar – 21st Mar, 2025
As of Fri Feb 21 2025
Mon – Fri
8:30am – 4pm
5 days
Contact Us
17th Mar – 21st Mar, 2025
As of Fri Feb 21 2025
Mon – Fri
8:30am – 4pm
5 days
Contact Us
Piston and Fusion offer the Course as Classroom in Lagos and Virtual Online Class in other states in Nigeria. See dates and fees for classroom and virtual online class.
Virtual Only
-
-
-
-
-
-
Virtual Only
3 Months
-
-
-
CV & LinkedIn Profile Development
Exam Application (Only for Certification courses)
Classroom & Virtual
Print & PDF
-
Teabreak & Lunch
Souvenir
Notepad & Pen
-
-
Classroom & Virtual
Print & PDF
Print & PDF
3 Months
Tea Break & Lunch
Souvenir
Notepad & Pen
CV & LinkedIn Profile Development
Exam Application (Only for Certification courses)
This programme is designed for executives tasked with igniting innovation within their organisations, or who seek to create innovative solutions to a major challenge.
Are you a corporate client looking to upskill your team?
To register multiple employees for our courses, please fill out this form to request a proposal.
We’ll provide you with a detailed quote, outlining the costs and benefits of your chosen courses. Once approved, we’ll generate an invoice for payment.
Let’s elevate your team's skills together!
https://www.pistonandfusion.org/enrol-now?type=corporate&course=financial-modeling-and-forecasting-using-excelWe help you decide if this course is a good match for your career. We can also help you plan and develop a career path.
We help you decide if this course is a good match for your career. We can also help you plan and develop a career path.