Financial Modeling in Excel – Volume 1

Financial Modeling in Excel isn’t JUST about Excel and Finance. It’s about modeling too. Excel is just a platform for modeling.

Financial Modeling in Excel

If you’re not completely satisfied, let us know within 30 days for a full refund. We want you to be 100% satisfied.

30 Days Money Back Guarantee

Full 30 Day Money Back Guarantee No Questions Asked

100% Secure Checkout

Verified & Secure Checkout. Pay Via Credit Card or PayPal

Free Lessons

learn excel online for free

We’ve helped these COMPANIES

with exact strategies and techniques used in this course

Professionals at gulf are using advanced excel tutorials to become faster & better at workProfessionals at bajaj finserv are using advanced excel tutorials to become faster & better at workProfessionals at bosch are using advanced excel tutorials to become faster & better at workProfessionals at Pxf housing are using advanced excel tutorials to become faster & better at workProfessionals at icici bank are using advanced excel tutorials to become faster & better at workProfessionals at kpmg are using advanced excel tutorials to become faster & better at work

Professionals at microsave are using advanced excel tutorials to become faster & better at workProfessionals at polyplastics are using advanced excel tutorials to become faster & better at workProfessionals at shairu gems are using advanced excel tutorials to become faster & better at workProfessionals at snapdeal are using advanced excel tutorials to become faster & better at workProfessionals at tata power are using advanced excel tutorials to become faster & better at workProfessionals at verizon are using advanced excel tutorials to become faster & better at work

 

Why should you learn it?


The teams at a premier Investment Bank or Private Equity are divided to focus on diverse sectors such as Real Estate, Financial Institutions Groups (FIG), Technology, Media & Telecommunications (TMT), Debt Capital Markets etc. Every analyst uses Financial Models in some form or the other.

The professionals who specialize in Project FinanceDebt re-structuringLease FinanceFinancial Feasibility studies, Business Modeling etc. use financial models in their work. All these are highly coveted professional assignments.

For beginners or entry level analysts, just explaining these in the interview would earn them brownie points. Explaining these in the context of FAST® Modeling Standard would drastically increase your chances of selection.

How is this course different than the rest?


  • It will teach you those concepts which no one else teaches. E.g. Timings Flags, Circularity Switch, Waterfall structure, BASE Analysis etc.
  • I will share my experience of J.P. Morgan. I have conducted Financial Modeling session for Pricewaterhouse Coopers&Deloitte – two of the prestigious Big Four firms.
  • I will incorporate the concepts of FAST® Standard – the globally accepted best modeling practices
  • The knowledge I share will help you compete in Modeloff – World Championship on Financial Modeling. Simply clearing Level 1 can add weight to your Resume.

Learner testimonials

  • The courses are really helpful whether regarding saving time, improving your presentation skills or getting to learn new features. The videos give you the feeling of one to one attention. Moreover, their constant attachment by emailing new tricks is highly appreciating. #thankyouteamyoda

    Arundhati
    Arundhati Raychaudhuri
    Article Assistant at P.Mukherjee & Co
  • I would like to tell you that I am very impressed with your courses so far – I particularly like the short videos that allow me to get to a topic quickly and then move on (your competitors mostly offer 20-30 min videos which is a bit much to keep one’s attention span). The other gem in your training are the shortcuts, I found no other course with the same insights.

    Peter
    Peter Klugsberger
    ex-McKinsey & Co. served various senior roles (CEO, COO) in various companies
  • This will save so much time I am quite a heavy user of PowerPoint but have never formally learned how to use it properly This course has shown me how incredibly time consuming my ways of using it are.

    LEN SMITH
    Len Smith
    (Business Owner at The Writers’ Guru)

Curriculum

Flags - Timing & Operation - 13 mins

  • True vs False
  • Timing Flag – Basics
  • Timing Flag – Advanced Demo
  • Timing Flag – Advanced Practice – Proj Completion Dt
  • Timing Flag – Advanced Practice 2 – Timeline
  • Timing Flag – Advanced Practice 3 – Start Flag
  • Timing Flag – Advanced Practice 4 – Operation Flag
  • Timing Flag – Advanced Practice 5 – Operation Days
  • Timing Flag – Advanced Practice 6 – Operation Yr No
  • Timing Flag – Advanced Practice 7 – Final
  • Recurring Events Flag – Fixed Interval
  • Recurring Events Flag – Customised Interval

Waterfall Structure - Funding - 19 mins

  • What is a Waterfall Structure
  • Funding Waterfall Structure – Demo with logics
  • Funding Waterfall Structure – Equity
  • Funding Waterfall Structure – Debt
  • Funding Waterfall Structure – Grant

Iteration & Circularity Switch - 15 mins

  • What is a Circular Reference
  • What is iteration in context of Circular Reference
  • Circularity Switch or Circuit Breaker – Example 1
  • Circularity Switch or Circuit Breaker – Example 2

Start Learning Today

Office Training Bundle Package

Office Training Bundle

Unlimited Learning to all Courses
$690
  • 1800+ Course Lessons
  • Lifetime Support
  • LinkedIn-verifiable Certificate
  • Exclusive Webinars
  • 1200+ Office Productivity Tricks
Join now

Frequently Ask Questions

What do you get in the course?

  • An accelerated, Practical approached Financial Modeling Tutorials to teach you Skill needed to compete in competitive work environment
  • All Financial Modeling tutorials case studies related to videos
  • Access to all video tutorials 24 x 7 – learn Financial modeling online from anywhere
  • A 30-day money-back guarantee (we want you to be 100% satisfied with our Course)
  • How do I enroll for the training online?

    You can enroll for this excel training online by just a click on Enroll Now button Payments can be made using any of the following options and receipts of the same will be issued to the candidate automatically via email.

  • Visa/Master Card credit card
  • Through PayPal
  • What if I’m unhappy with my online excel course? Do I get a refund?

    We have created these videos after spending a lot of time in research and recording. We would never want you to be unhappy! If you are unsatisfied with your purchase, contact us in the first 30 days and we will give you a full refund. To know more please read our Refund Policy. If you just want to get to know the flavor of the course, you click on any one of the tutorials.

    How much time required to complete Training?

    This is a fast-paced, lean training program of about 70 mins with videos Tutorials. Watch the preview of videos get a flavor the program’s uniqueness and relevance. The online course may not be your first preference. But I promise this – After watching 3 videos, this course will give a tough fight to your usual classroom Training.