Introduction to the course
4.9
rating4000+
students1 time
paymentAnyone
can do (IT/NonIT)Simple English
Language9 hrs
content durationLifetime
course accessSelf-paced
recorded lecturesBy getting 100% of your fees back on course completion
↓
Upskill↓
100% Refund4.9
rating4000+
students1 time
paymentAnyone
can do (IT/NonIT)Simple English
Language9 hrs
content durationLifetime
course accessSelf-paced
recorded lecturesA limited time opportunity for rewarding our learners to upskill for free.
Effective Fee
into your favourite courses
Learn with 1:1 live doubt solvingwith shared curated assignments in
months time from the date of enrollment
when you fulfil the previous criteria
Enrollment Fee is refunded
>
swipe upAsk your doubts when you want, and get it solved within 5-10 minutes
With robust Mentor Support, experience seamless learning with personal mentorship
100% Free Learning
On the courses enrolled within the 100% Refund offer through which you earn your enrollment fee back as rewardStructured Course
Learn from our structured pre recorded courses made by experts to meet industry needsInstant Mentor Support
Personal mentors to guide and help you throughout your journey as a friend through chat, calls & screen sharingProjects & Certifications
Build major projects which makes your resume stand apart alongwith course completion certificationsInternship Opportunities
Get remote internship opportunities after the completion of the course along with dedicated assignmentsLifetime Course Access
Get liftetime course access on each course that you enroll, and enjoy the benefit of mentoring wheneve you want4.9
rating59
lectures9h 23m
total durationLifetime
accessIntroduction to the course
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
Index Match Match
Rank and Iferror
Choose and Goal Seek
Intro to Data Tables
Pivot Tables
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
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
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!
Why should I opt for Tutedude?
What is the validity of the courses and when can I watch them?
Will my course validity expire after I receive the 100% Refund amount ?
How will I know that 100% Refund offer has been applied ?
How will receive my 100% Refund amount ?
How can I access my Mentors?
Why don't you provide live classes and why should I prefer recorded lectures?