The Best Excel Video Course to
learn Excel for Stock Valuation


Excel for Finance



Excel for Finance Video Course Details

11 Mini Lessons | ~ 1Hr


Video Content [02:41]
How to get most out of this course?
What Will I learn in this Course?
How’s this course different from others?
Who is the creator of the course & what has he done before?
What is the Style of Presentation?
Video Content [04:43]
Overview of Excel
Rows, Columns, Tables in Excel
Various formats in Excel
Excel Formulaes
Excel Functions
Sorting in Excel
Create a drop down list using Data Validation
Freeze Panes : Fix the top row for better analysis

Please Subscribe to see the video!
Video Content [05:33]
SUM, SUMIF and SUMIFS
COUNT, COUNTIF, COUNTIFS
AVERAGE, AVERAGEIF
Text edit : LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE
Finding MIN and MAX value
ROUND function
IFERROR to catch errors

Please Subscribe to see the video!
Video Content [03:31]

VLookup : Finding a value in the leftmost column of a table
HLookup : Finding a value in the top row of a table
INDEX + Match as substitute of Vlookup

Please Subscribe to see the video!
Video Content [02:59]

What are pivot tables?
How to create a pivot table?
How to add different variables in the pivot table?
How to summarize data in various types in a pivot table?

Please Subscribe to see the video!
Video Content [02:17]

Future and Present Values in Excel
IRR Functions to calculate rate of return on investment

Please Subscribe to see the video!
Video Content [03:27]

What do you mean by Valuation?
Which are the various Valuation methods?
Discounted CashFlow Model?
Dividend Discount Model
Ratio based valuation Methods?

Please Subscribe to see the video!
Video Content [05:43]

What's DCF Valuation?
What's required to calculate DCF?
What's the formula for DCF?
Example DCF Calculation for Infosys
Limitations of DCF Valuation

Please Subscribe to see the video!
Video Content [2:48]

How to insert a chart in excel?
Editing Excel Charts
Excel Chart formatting
Different types of charts in excel
Bar chart, Column Chart, Pie Chart
Treemap Chart

Please Subscribe to see the video!
Video Content [01:57]
Importance of Macros in Excel?
How to create a Macro?

Please Subscribe to see the video!
Video Content [01:23]

Final Checklist to learn Excel for Financial Analysis

Please Subscribe to see the video!


You may also like the below Video Courses


By THE FOUNDER - Rohit Katiyar


- 14+ Years of Experience as an Investor in Indian Stock Markets & 4+ years in Cryptocurrency
- Worked as a Full time Derivatives Trader during the Great Financial Crisis of 2008-09
- Made a Return of 14%+ CAGR in Equity Markets after experiencing both Bull & Bear markets
- MBA from IIM-C and past experience in Investment banks such as Credit Suisse/BNY Mellon
- Big follower of Warren Buffett & SEBI Registered Research Analyst
Founder, Smart-Investing.in

Testimonials

Frequently Asked Questions


This Video Course is an Addon and is separate from subscription of our website.

With this purchase, you will get full access to this particular Video course for one year.

We accept almost all payment methods such as UPI, Netbanking, Debit Card, Credit Card and Wallets.

We use the extremely secure payment gateway provided by Razorpay and hence all your information is always protected.

We provide email support to all our premium customers.
Any queries can be emailed to support@smart-investing.in.
Our support team will provide a response within 2 business days.

NO. We STRICTLY don't provide stock recommendations/tips.

Our mission is Financial Literacy for all retail investors in India.

With this focused goal, we have created this simple to understand platform to enable you take intelligent decisions on your own.

Imagine that you want to analyze financial statements of 1000+ companies and the amount of time it would take for you to do it manually for 100+ data points.

Also imagine the amount of time you would need to invest to read 50+ books on investing and learn the practical ideas to analyze any stock.

Last but not the least, imagine you trying to find intrinsic value of 1000+ stocks using mathematical models that you would need to learn.

The above are just sample problems that we solve for you. You can use the free trial of 20 searches per month to experience the benefits and how simple we make it for you to understand various parameters before taking an investment decision.

This video course is suitable for Investors at all stages of investing.
Be it Beginner, Intermediate or Expert.
Since it's so simple to understand, even students can use it for learning purposes.

Sure. Just shoot us an email at support@smart-investing.in and we will help you with your questions to help you take a decision. Please allow us 2 business days to provide a response.

Razorpay