Financial Modelling using Excel
This is a 20-hour course designed for students and working professionals who are interested in equipping themselves with the basic knowledge of financial modeling using excel and its applications. The main objective of this certificate course is to enable the participants to learn the techniques of Financial Modeling in Excel and their application in Financial Analysis and management.
BOOK YOUR FREE DEMO CLASS
KEY HIGHLIGHTS OF THE COURSE
- 20+ Hours of Live Training
- Practical & Action Oriented Program
- Industry Ready Curriculum
- Assignments & Case Studies
- Placement Assistance
- Lifetime Access to Community Support & LMS
- Small Batch Size
- One to One Interaction & Mentoring
LEARNING OUTCOME
Each session will be case study based interactive learning. Exercises will be given to participants to carry out self-based learning. The participants will be able to learn the
- Advance tools of MS-EXCEL
- Application of MS-Excel tools in developing the financial models
CURRICULUM/SYLLABUS
- INTRODUCTION TO MS-EXCEL
- SCENARIO ANALYSIS
- PIVOT TABLE
- GOAL SEEK
- INTRODUCTION TO MACRO
- COST OF CAPITAL
- CAPITAL STRUCTURE
- DIVIDEND POLICY
- RATIOS USED IN
- LONG- AND SHORT-TERM RISK RETURN ANALYSIS
- MAKING AND ANALYZING PROJECTED FINANCIAL STATEMENTS
- EQUITY AND INDUSTRY ANALYSIS
- SENSITIVITY ANALYSIS
- LONG TERM PROJECTIONS AND SCENARIO ANALYSIS
- UNDERSTANDING STEPS IN PREPARING A FINANCIAL MODEL
- FINANCIAL ENGINEERING SCENARIOS IN A MODEL
- WALKING THROUGH A PRE-BUILT EXHAUSTIVE FINANCIAL MODEL
- SETTING UP TEMPLATES (DASHBOARD, FINANCIAL S, ASSUMPTIONS AND CALC, W/C, DEPRECIATION, DEBT, TAX)
- FINANCIAL STATEMENT ANALYSIS MODEL
- COST OF CAPITAL MODEL
- STOCK VALUATION MODELS
- INTRODUCTION TO ADVANCE MODELING TECHNIQUE
PEDAGOGY
This is a practical course, and the basic approach is to learn by doing. The student needs to bring their laptop with Microsoft excel 2007 or above installed on the machine. The training will be imparted through interactive sessions with extensive use of real-world Excel models.
Book a Demo Class For Free!
Unlock the power of Excel for Finance - Enroll now and master financial modeling for smarter decision-making!
FREQUENTLY ASKED QUESTIONS
What is the Qualification/Pre-Requisite to Enroll into this course
While prior knowledge of Excel is helpful, this course caters to both beginners and intermediate users, providing step-by-step guidance to build your skills from the ground up.
What is the Duration of the Course?
This is a 20 Hour program covered in around 6 weeks.
Will I get personalized feedback on my financial models?
Yes, the instructor will provide personalised feedback on your course assignments and the final project to help you improve your financial modeling skills.
Who should do this course?
This course is ideal for finance professionals, analysts, investment bankers, financial consultants, accounting professionals, entrepreneurs, business students, and anyone seeking to strengthen their financial modeling skills using Microsoft Excel for data-driven decision-making.
Do I get any Certificate?
upon successful completion of the program and passing the final project evaluation, you will receive a certificate of completion to showcase your skills.
Do you give Placement Assistance?
While the course focuses on equipping you with essential job-ready skills, we also provide general career guidance and tips on navigating the job market.
Can I access the course materials after the course ends?
You get Lifetime Access to our LMS(Learning Management System), where you can find all the course videos and study materials. In online program, you also get the recordings of the live classes.
What is the Course Fees?
There are few variations in terms of course fees and it changes time to time. Please call us on: +91-8917645698 to know the details
