Finance & Analytics
Financial Modelling & Advanced Excel
Practical finance and Excel course covering advanced formulas, financial functions, forecasting, financial statements, valuation basics and business financial models.
Enquire Now →
WHO CAN JOIN
Eligibility
Commerce students, B.Com/M.Com graduates, MBA Finance students, accountants, finance professionals, business owners and learners interested in finance and Excel.
CAREER VALUE
Course Benefits
Advanced Excel Skills, Financial Analysis, Budgeting & Forecasting, Financial Functions, Business Modelling, Financial Statement Analysis, Practical Finance Projects and Certificate.
WHAT YOU WILL LEARN
Course Syllabus
Module 01
Advanced Excel
Module 02
Logical & Lookup Functions
Module 03
INDEX & MATCH
Module 04
XLOOKUP
Module 05
Financial Functions
Module 06
PMT
Module 07
IPMT
Module 08
PPMT
Module 09
PV
Module 10
FV
Module 11
NPV
Module 12
IRR
Module 13
Data Analysis
Module 14
Pivot Tables
Module 15
What-If Analysis
Module 16
Goal Seek
Module 17
Scenario Manager
Module 18
Data Tables
Module 19
Financial Statement Analysis
Module 20
Profit & Loss Statement
Module 21
Balance Sheet
Module 22
Cash Flow Statement
Module 23
Budgeting
Module 24
Forecasting
Module 25
Ratio Analysis
Module 26
Revenue & Expense Models
Module 27
Loan & EMI Models
Module 28
Investment Analysis
Module 29
Dashboard Reporting
Module 30
Financial Modelling Fundamentals and Practical Business Projects.
START YOUR LEARNING JOURNEY
Talk to MCTI →
Ready to learn Financial Modelling & Advanced Excel?
Enquire today for latest batch details, fees and available offers.