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)
Olawande Akinmola is a Business Intelligence Analyst and facilitator skilled in transforming data into actionable insights. With a B.Sc. in Microbiology and certifications in Data and Financial Analysis, she specializes in SQL, Tableau, and Power BI. With three years of experience, she helps businesses make data-driven decisions through clear, strategic insights. As a facilitator at Piston and Fusion, she empowers professionals with data literacy, making complex information accessible and impactful.
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.
22nd Apr – 26th Apr, 2025
As of Thu Mar 27 2025
Tue, Wed, Thu, Fri & Sat
8:30am – 4pm
5 days
Contact Us
22nd Apr – 26th Apr, 2025
As of Thu Mar 27 2025
Tue, Wed, Thu, Fri & Sat
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.