Check out my video on understanding the fundamentals of Excel, here: kzfaq.info/get/bejne/nMmSdZOf0KrNm2w.html Here is the Udemy course that I often go back to, each time I need help with Excel: bit.ly/3lm1FQ9

The energy in each of the videos is so admirable....positive vibes

Just want to thank you for being there... for existing, for teaching, for spreading knowledge, for educating

Excel : ankur sir's first love 😁😁😘😘😘

Absolute gem here Ankur!, saving & investing right is crucial - but sometime to drive yourself, motivate oneself - need to spend extravagntly - gives you a kick to be earning more!! so yea go for that higher segment car, 5 star over 4 star - once in a while

The 5 Formulas that are discussed in this video are : 1. Return Percentage = (Return Value/Invested Value) - 1 5:14 2. Compounded Annual Growth Rate CAGR = (Current Value of investment - Original invested value) ^ (1/(current year of investment - 1))-1 9:24 3. Portfolio Valuation = Sum(Absolute Return range of cells) / Sum(invested amount range of cells) 12:18 // over the years 4. EMI Calculator = PMT(ROR/12, duration, loan amount) 15:42 5. SIP Future Value = FV (Growth Rate/12, number of months invested, SIP Value, Initial Investment) 17:04 Hope this helps Cheers

I really love you Ankur, I knew these formulas used occasionally but the way you putting and delivering the information to make people financially literate, for helping out people those who don't know is really appreciated.

Insightful.. thanks for sharing

Wow... Last one was awesome😍

Superb Content...I am really thankful to You and Sardarji Share Market Wale on KZfaq...You both have the best analysis, learning and recommendations.

Sir, Thanks a lot for explaining in detail 🙏

Thank you Ankur sir. Very informative video. When you calculate FV (future value), can you tell us how to add inflation when getting actual value? Thanks 😊

Very informative video..please make whether to buy plot or flat using excel sheets

aaj din me issi topic ke bare me soch rha tha and tada tada here is ankur for you 🙂

It's very nice concept because they can easily understand the how to calculate the absolute return?....nice video....thanks a lot of sir jee....

🏵️Hey Ankur sir, Please make a video about how to pitch your ideas to investors🏵️

We need more this type of money management related videos.

Greay Information Ankur. Just a tip, In PMT, instead of dividing the 10% directly by 12, to get an even accurate answer what we can do is: =((1+10%)^(1/12))-1 Using the above formula, you can get the most accurate monthly return in any case. Although the difference might be small but remember in longer period compounding does a tremendous job in changing the numbers. So in calculation of long term investments, this formula can be helpful.

धन्यवाद सर एक्सेल का महत्व सरल शब्दो में समझाया ,

Hey Ankur, I really like the information you put out to educate people about finance. There is just one thing I want to let you know, maybe you know it already but, you suggest people to watch your video at 1.5x speed, and as far as I know when people watch a video at any speed higher than 1x, it has a negative impact on the channel and future recommendations as a person spends only 1.75% time of the total length of the video. Hence, if a viewer watches a video at less than 1x speed, it has a very good impact on the channel and recommendations. Therefore, I just suggest that you don't ask people to watch the video at 1.5x speed. This will help your channel reach a larger audience and have a greater impact. :)

It's just fantastic...thanks sir❤️

thanks Sir, for this much valued information.

This is what I was looking for the last one month. Ankur your are a saviour 🙏🙏

I will certainly check video on basic excel. I am curious and excited.

Sir aap se kafi kuch sikhne ko milta h .thanku so much

This very helpful, thank you for this video.

Amazing presentation skills. You must make a course on presentation skills and I'll be the first one to purchase it

aaj kal aap ke videos kuch jyada hi majedaar ho rahe hain

This guy just make good videos and never drops a like on any comment

FV is useful for me. Thanks for sharing !

It's Compounded AVERAGE Growth Rate Mr. Warikoo. Our esteemed educated Bihar Minister who spoke on Crypto told so.

Sir please make a video how to investment shariah.🙂

Thank you sir , ye video bahoot zaroori thi 🔥🔥🔥

Amazing tutorial. 👍

When ankur sir says zaroori, it is very zaroori

I really love the you explain and teach everything it would be great if you launch your excel course because the way you explain everything is amazing.

Thank you so much for this Video!! Really needed this!!! Thanks a lot!!!!

One more formula that one should know is inflation adjusted return Inflation-adjusted return = (1 + Stock Return) / (1 + Inflation) - 1 = (1.233 / 1.03) - 1 = 19.7 percent

गुरु देव आप इसी तरह हमे excel excel खेलवाते रहिएगा 🙏

Sir, make full tutorial on Excel.(with all Excel formula)❤️

thanks for this video

Hello everyone, I'm having a doubt. The growth rate that Warikoo is entering in Future Value whether it is just return on every year or CAGR? I appreciate your help!

Everyone should learn Excel..

pls inflation formula bhi bataiye FV formula ke sath

I feel like trading on stock but the rise of cryptocurrency now is wonderful 😊 and I feel like trading on cryptocurrency but I need a professional guideline 😢

Thank you soo much Ankur Sir

One video on Trading for beginners or College students (for earning or bring someone for it)

Very useful formulas 👌🏼👌🏼👍🏻👍🏻

Thank you .. was planning to get these soon...

Thank you sir

Ankur ji Shukriya 🙏🏻

Thanks a lot Mr Warikoo

My favourite youtuber 👍👍👍

U r the best... Thank you so much

Very useful information!!🙏

Thanks ankit

In future value calculation how to adjust the matured value keeping in consideration the inflation rates?

I am going to open a savings account soon! Yay

*I will forever be in-depted to you 😇 you've changed my life I'll continue to preach about your name for the world to hear *you've saved me from a huge financial debt with just little investment. Thanks Mia Frank*

THANK YOU. 👍😊

That eye look when its excel excel

Awesome 👍

Fantastic learning

Make video on how to write and publish book (process of writing, publishing including budget, cost )

I am also big lover of Excel

Sir ji namaskar I really like your video

thank you so much sir 🗽

Bahut mazaa aa gya ye video dekh kr

This is exactly what I was thinking about and what a lucky coincidence! You just dropped a video!! Thank you for the quality content Ankur and the book is kickass.🔥🔥🔥

The 0:42 sound was too funny 😂🤣🤣

I BADLY NEEDED THIS VIDEO

Warikoo Sir please start teaching excel from basic to advanced.

Could have considered showing xirr calculator

Hey ankur this video very informative nice one.. 👍👍👍

the udemy link for excel course is not redirecting to the course. its redirecting to udemy home page for me can someone address the course name in the comment.

U are great hero of our life , we can't be 1% of u , God bless u

Hi Warikoo, love it the way you explained it...A lots of love to you.Thank you

Please make a video about XIRR and IRR applicable for SIP where CAGR is not applicable.

Wish you would have included xirr formula which is more relevant for tracking return...

Thank you so much Ankur for this Just a quick question for you if I am investigating 10K every month and after 1 year I am increasing my Investment amount by 10% So how do I calculate my Future value?

Hello Ankur , can you please make a video on how NRI can invest in small case and how much tax they have to pay . There is very little information on net about NRI investment in small case .

👍 very useful vedio

Very useful formula.🙏🏻 i have a one query. Don’t know why but when i check sip investment returns in mutual fund site it’s showing different amount. Sir Can you tell me what’s the reason?

Finally Excel 🔥🔥😇😇

Awesome

this is really helpful, appreciate the explanation :)

What a video...amazing

Thank you🙏

Hello Ankur, i must say this video is really very helpful... Thanks for that... Could you please make a video on XIRR (for SIP) then it will be great 😊😊

Sir, recently govt have suspended the overseas investment and due to that my overseas mutual funds has paused the sips temporarily. Can you put a video on that and explaining how long this suspend gonna be and how its gonna impact us? Where to invest that sip money until the suspension get revoked

future value ki inflation ke baad kitni value hogi aaj ke hisab se please uska formula bhi bta dijiye sir

$76,000 just in two weeks Mrs Christine Norine Martin you are so amazing.

Amazing video

Good info sir

Over power 🔥🔥

1:18 Love

Awesome video 🤩🤩

Kindly make a video on "how to calculate overall portfolio XIRR for direct stocks investing "

Ankur sir kindly make video on the term TURNOVER for a business

Great content thanks 💖☺️