Start Your Career with a Foundational Course
This Junior Financial Analyst course provides participants with the foundational Excel skills and financial knowledge needed to understand financial statements, set up basic financial models, perform simple forecasting, and support financial analysis tasks. It is designed to equip individuals for entry-level analyst roles where understanding and building basic financial models in Excel is required.
Career Switch: Give yourself a new start with Financial Analysis. This course is your gateway to a high-demand, future-proof career across various industries including corporate finance, investment, and accounting.
Upgrade Your Skills: Enhance your professionalism with in-demand skills like Excel modeling, financial statement analysis, basic forecasting, and understanding key financial ratios.
Improved Earning Potential: Junior Financial Analysts in Nigeria earn competitive monthly salaries, depending on the industry, technical skills, and level of hands-on experience.
By the end of the Junior Financial Analyst course, participants will be able to:
Module 1: Financial Modeling & Excel Fundamentals Setup
Purpose and Types of Financial Models
Core Excel Best Practices for Modeling: Formatting, Structure, Clarity
Essential Excel Functions: SUM, AVERAGE, IF, SUMIF/SUMIFS, Basic Arithmetic
Key Data Tools: Sorting, Filtering, Basic Data Validation
Understanding the 3 Core Financial Statements: Income Statement (IS), Balance Sheet (BS), Cash Flow Statement (CF)
Basic Linkages Between Financial Statements
Module 2: Setting Up Historical Financial Statements in Excel
Inputting and Structuring Historical IS and BS Data
Calculating Key Historical Ratios: Growth Rates, Basic Margins (Gross, Operating)
Ensuring the Historical Balance Sheet Balances
Setting up Basic Error Checks (e.g., BS Check)
Module 3: Setting Up Basic Forecasting Schedules
Understanding Forecasting Drivers and Assumptions
Building Simple Supporting Schedules:
Basic Revenue Forecast (e.g., simple growth rate)
Basic Fixed Asset Schedule (Straight-line depreciation)
Simple Debt Schedule (Basic interest calculation)
Using Lookup Functions (VLOOKUP, INDEX/MATCH) to pull data
Module 4: Building a Basic Forecasted Income Statement & Balance Sheet
Projecting IS Line Items: Linking to Schedules, Historical Trends, Simple Drivers
Projecting BS Items: Linking to Schedules, IS (Net Income to Equity), Working Capital basics
Ensuring the Forecasted Balance Sheet Balances (The "Plug" - often Cash or Debt)
Module 5: Setting Up a Basic Cash Flow Statement
Structure of the Cash Flow Statement: Operating, Investing, Financing Activities
Building a Simple CF Statement (Indirect Method):
Starting with Net Income
Adjusting for Non-Cash Items (Depreciation)
Incorporating Changes in Working Capital (from BS changes)
Reflecting Investing & Financing Activities (from schedules/BS changes)
Reconciling Beginning and Ending Cash Balances
Module 6: Introduction to Model Review & Formatting
Applying Consistent Formatting: Number formats, Colors, Fonts
Importance of Clear Assumptions Sections
Implementing Basic Checks and Balances within the model
Basic Model Documentation Principles
Participants enrolling for this programme will be required to have no prior financial modeling experience, but a basic understanding of accounting principles (debits/credits, core financial statements) is highly recommended.
Proficiency in basic Excel operations (navigation, simple formulas) is essential, and access to a computer with Microsoft Excel installed.
Requirements:
Prospective applicants who do not meet the programme requirement but want to join the programme should talk to a Career Advisor.
Acquire essential financial modeling skills, including building 3-statement models, basic forecasting, and financial statement analysis, through a hands-on learning approach using Excel.
Improve your job prospects for entry-level roles such as Junior Financial Analyst, Finance Assistant, or Reporting Analyst with targeted training and career development support.
Gain valuable real-world experience and verifiable references by participating in an internship of up to four months on actual financial analysis projects across various industries.
Establish a solid foundation for career progression and the pursuit of more advanced financial certifications like the CFA (Chartered Financial Analyst) or FMVA
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 Financial Modeling & Forecasting Course as Classroom in Lagos and Virtual Online Class in other states in Nigeria. See dates for classroom and virtual online class.
Junior Financial Analyst Course Schedule for Lagos, Abuja, & Online
16th Jun – 20th Jun, 2025
As of Mon Jun 16 2025
Mon – Fri
8:30am – 4pm
5 days
Contact Us
Piston and Fusion offer the Junior Financial Analyst Course as Classroom in Lagos and Virtual Online Class in other states in Nigeria. See 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)
Talk to the Career Advisor and join the next schedule.
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.