Financial Modelling
& Valuation

The most desired skill in today's corporate world.

Premium Courses

Lifetime Access

1:1 Live Doubt Solving

Personal Mentorship

Certificate

9 hours

Curriculum

✔8 sections ✔ 59 lectures ✔ 9h 23m total length

  • Introduction and Overview of Excel
  • Basic Operations and Data Entry
  • Introduction to formatting
  • Introduction to Excel Formulas
  • Excel Functions
  • Cut copy, Paste Special
  • Format Cells

  • Excel best practices
  • Tips & tricks part 2
  • Select Special & Dynamic Names
  • Named Range & Hyperlink
  • Custom Format No.
  • Macros
  • Freeze Panes & More
  • Conditional formatting

  • SUM, SUMIF and SUMIFS
  • Count, Average
  • Text Modif, MaxMin
  • VLookUP
  • INDEX, MATCH and their combination - the perfect substitute for VLOOKUP
  • Choose and Goal Seek
  • Rank and Iferror

  • Net Present Value
  • Internal Rate of Return
  • Loan and Interest Rate
  • Date Functions

  • Intro Pivot Tables
  • Modify
  • GETPIVOTDATA
  • Slicers

  • P&L
  • Compile Data
  • Mapping, P&L

  • Forcasting P&L Part 1
  • Forcasting P&L Part 2
  • Forcasting BS Part 1
  • Forcasting BS Part 2
  • Filling P&L
  • Filling BS
  • UFCF
  • Net Cash Flow
  • Completing Cashflow and BS
  • Enterprise Value

  • Intro
  • Revenue Modelling 1
  • Revenue Modelling 2
  • Other Items of P&L
  • Other Items of the BS
  • PP&E Schedule
  • Content Assets Schedule
  • Data Schedule
  • Profit & Loss Part 1
  • Profit & Loss Part 2
  • Balance Sheet and Cash Flow Part 1
  • Balance Sheet and Cash Flow Part 2
  • WACC
  • DCF & Outro

Combo Offers By Tutedude

Customized pack

Get any 4 courses at 1499Rs.

Explore now

All access pack

Get all 20 courses at 4499Rs

Explore now

Course Advantage

Master Excel from basics to advanced

Create Financial Models of any company.

Learn skills required to become investment banker or analyst

Make your fundamental analysis of stock market strong

About this Course

Read more

Want to learn Excel while being applied practically?
Or you might be someone who looks to make a career in finance(highest paid field)
Or you just maybe one pursuing MBA
Whatever it be, Excel and Financial Modelling are all around skills, the skills which will help you in whatever career field you are. And here I am with this course to make you excel in this skill(pun intended :) In this course we will be first learning Excel and then move to how to evaluate any company financially. At the end there is an extensive case study on Netflix(most of our's favorite company) through which you will learn how to apply all the things we learnt before that and also gain confidence to evaluate any company on your own after that. If you are excited about this, why wait? See you inside the course
All the best!

Have Some Query ?

Tutedude provides you the professional curated content by Indian instructors along with live doubt solving and personal one to one mentorship which you won't find anywhere else.

You will have lifetime access to the courses and can watch the lectures anytime you want. So it is totally flexible and provides you the comfort of learning anytime anywhere. Also as the technologies progress we keep on updating our courses so you get the access to them too.

Your doubts will be solved on a live chat, as soon as you get a doubt just ping your mentor through the chat option and within 5-10 minutes you will be connected to him to solve your doubts.

Tutedude doesn't believe in the idea of teaching 100 students in 1 class where the student sometimes feels hesitant to ask some doubts and where the other student feels that this student is wasting his time by asking silly doubts. Moreover in this busy world it becomes difficult to attend the classes on a specific schedule. So we combined the benefits and provide you interactive video lectures and live one on one doubt solving to learn at your own pace and comfort.

Tutedude









Already have an account?

Otp confirm

Enter the 5 digit otp sent to your mobile number.

Forgot Password

Enter Your registered Email your account is associated with and we will send you otp to your email

Tutedude

OR





Forgot password?

New user?Register