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
Curriculum
- 10 Sections
- 46 Lessons
- 10
- Module 1: Introduction to Financial Modeling3
- Module 2: Getting Acquainted with Excel4
- Module 3: Planning and Designing a Financial Model7
- 3.1Identifying the problem that your financial model needs to solve
- 3.2Designing how the problem’s answer will look
- 3.3Gathering data to put in your model
- 3.4Documenting the limitations of your model
- 3.5Structuring your model: What goes where
- 3.6Defining inputs, calculations, and output blocks
- 3.7Determining your audience
- Module 4: Excel Tools and Techniques4
- Module 5: Excel Functions and Formulas in Finance4
- Module 6: Applying Scenarios to Financial Model4
- Module 7: Charting and Presenting Model Output3
- Module 8: Building Financial Statements Model7
- Module 9: Building a Discounted Cash Flow Valuation5
- Module 10: Integrating Financial Statements Model5
Courses You May Like
Islamic Corporate Finance and Project Financing
Islamic Corporate Finance and Project Financing is an advanced course designed to equip learners with the knowledge and skills necessary to understand...
Interpreting Financial Statements
The "Interpreting Financial Statements" course is designed to empower individuals with the knowledge and skills necessary to decipher financial statements, enabling informed...
Internal Control: Compliance, Operational and Financial
The course on Internal Control: Compliance, Operational, and Financial provides an in-depth exploration of the critical role that internal controls play in...
Payroll: Preparation, Analysis and Management
The "Payroll: Preparation, Analysis, and Management" course is designed to equip participants with the knowledge and skills necessary to manage payroll processes...