Financial Modelling in Excel for Beginners 24 hours

Learn models to make data-driven financial decisions FAST. Learn practical techniques and skills that will help you accomplish more in less time – with impressive results!

This course includes
✅ Learn New, Hidden, Unexplored Features
✅ Build a model from scratch
✅ Clear your subject doubts face to face with experts
✅ 24 hours of course content
✅ LIVE session with an experienced instructor
✅ No Pre-recorded videos
✅ Real work examples
✅ Access to the entire session recording
✅ Hands-on experience
✅ Limited Batch Size
✅ Digital certificate

coding isometric 11
coding icon 4

Overview

Duration: 24 Hours

📅 Starting from 7th Nov 2020
🕒 Every Saturday & Sunday, 10 am – 1 pm IST
📍   Live on Zoom (NO PRE-RECORDED)

Demo Session:
Duration: 1 Hour 
Date: 1st Nov 2020
Time: 11 am to 12 pm IST


Investment:
MRP : ₹ 16,999 + GST
Our 10th Anniversary Offer Price
₹ 9,999 + GST (Limited seats only)

coding icon 12

Register Now

You are just a step away to enroll for Financial Modelling in Excel for Beginners Course

coding iconArtboard 19 copy 9

Who Should Join

Who can take this course:
Students, Graduates, Executives with 1 to 3 years of experience, Employees looking for shift their role to finance, Anyone interested to learn Finance.

Proficiency Level:
Beginner & Intermediate

coding iconArtboard 19 copy 9

Course Content

Basic Excel for Financial Modelling:

  • Use of Excel Functions relevant for Financial Modelling
  • Sensitivity Analysis – Data Table and Scenario building
  • Lookup, Match, Index functions 

Financial Statement Analysis (Based on CFA Level I Syllabus):

  • Financial Statements Introduction
  • Financial Reporting Mechanics
  • Understanding Income Statement, Balance Sheet & Cash Flow Statement 

Financial Modelling

  1. Preparing 3 Statement Models
  • Prepare Revenue Sheet, Cost Statement
  • Prepare an Income Statement, Balance sheet, Cash Flow Statement 
  1. Project Evaluation/Project Finance
  • Stage of project – construction & development phase
  • Preparing projections of Costs & Funding during investment phase
  • Decision making based on Capital Budgeting tools
coding iconArtboard 19 copy 9

Benefits to participants

  • Excel For Financial Modelling – You will learn excel functions relevant for financial modelling
  • Financial Statement Analysis – You will gain understanding of Financial Statements
  • Preparing Financial Statements – You will prepare 3 statement Financial Model
  • Capital Budgeting Tools – Gain knowledge of Capital Budgeting tools such as NPV, IRR etc
  • Business Evaluation and Decision Making – Build a Financial Model from scratch to evaluate a Project/Business
  • Sensitivity Analysis – Build various scenarios and evaluate the Project/Business
coding iconArtboard 19 copy 9

Notes

  • For any questions, please feel free to email us at excel@excelinexcel.in or call us at +91 76670-97350.
Sandeep Kothari

Sandeep Kothari

Instructor

Sandeep is a Practicing Chartered Accountant based out of Chennai and a trainer for professional courses such as CFA and Financial Modeling. He has over 11 years of corporate experience and four years of teaching experience. He possesses rich and varied industry experience working in equity research, credit research, and financial reporting with leading corporates. He completed BCom from Loyola College in 2005, Chartered Accountant from ICAI in 2007, Diploma in IFRS from ACCA in 2010 and CFA from ICFA – US in 2014.

Click Here to Watch #EiEFreshTalk on Modeling a Franchise Business Opportunity By CA. Sandeep Kothari

coding icon 2

Enhance your Excel knowledge

From Excel, DAX, Power Query M Functions to Shortcuts. From thought-provoking Articles, Bios about Top-notch Excel Personalities to Exciting Puzzles, we have almost everything covered for you.

coding icon 8

#StayHome #LearnExcel

150+ hours of video content to watch & learn MS Excel covering Basic to Advanced by CA. Deepak Kumar, Excel Expert with 15 years of experience.

Stay ahead of all!

Stay updated with free webinars, Latest updates, Tips / Tricks & lots more...

Need Help? Chat with us