Skip to content
  • Home
  • Personal Finance
    • Introduction to Financial Planning
    • Money Management
    • Investment Planning
    • Insurance
    • Retirement Planning
    • Tax Planning
    • Loans
  • CFO Insights
    • Corporate Finance
    • Income Tax
    • International Tax
  • Leadership
  • About Us
  • Contact Us

Finance Friend

Practical Finance | Trusted Leadership | Financial Freedom

Excel Tips

How to calculate investment return with XIRR in Excel ?

March 6, 2023August 26, 2021 CA. Kalpesh Karia
How to calculate investment return with XIRR

Objective – How to calculate investment return with XIRR : This article can be useful for Investor, Finance Professional or students . As an investor you may be investing in various class of assets Read more […]

Categories Excel Tips, Investment Planning, Personal Finance Tags Personal Finance Leave a comment

How to insert drop down list in excel

January 12, 2018January 12, 2018 CA. Kalpesh Karia

How to insert drop down list in excel Background: You may have seen drop down in various excel file . You may want to have same drop down list in your excel template. Let me tell you this is a fantastic Read more […]

Categories Excel Tips Tags Data Validation, Excel Formulaes Leave a comment

How to use SUMIF Formula in excel

June 21, 2017 CA. Kalpesh Karia
How to use SUMIF Formula in excel

How to use SUMIF Formula in excel: Want to do sum of key fields having thousands lines in few minutes ? SUMIF is very useful formula in excel. This Post will provide details regarding how to use SUMIF Read more […]

Categories Excel Tips Tags Excel Formulaes Leave a comment

How to remove #N/A error in vlookup

June 17, 2017 CA. Kalpesh Karia
How to remove #N/A error in vlookup

How to remove #N/A error in vlookup . It is very irritating when you may be using vlookup formula in excel and you will get error like #N/A. You may be wondering how to remove #N/A error in vlookup . Read more […]

Categories Excel Tips Tags Excel Formulaes Leave a comment

How to use VLOOKUP function in excel

June 17, 2016July 28, 2015 CA. Kalpesh Karia
Vlookup Image 1

How to use VLOOKUP function in excel Background: If you are new in excel or you are fresher and have just joined industry, you probably listen words like VLOOKUP on daily basis. Excel is an integral Read more […]

Categories Excel Tips Tags Excel Formulaes 1 Comment

Popular Posts

Building a Career in Global Capability Centres (GCCs) in India
What Really Happens Inside a Boardroom?
TDS on payment to Non Resident - Section 195
How many AS, Ind AS and IFRS are there ?
Depreciation Rate Chart as per Income Tax Act

Latest Post

  • What Really Happens Inside a Boardroom?
  • Building a Career in Global Capability Centres (GCCs) in India
  • How to Use Feedback Effectively: A Leadership Perspective on Growth and Governance
  • Valuation Is Not a Formula — It’s a Story Backed by Execution
  • From Gandhi’s Charkha to AI/ML: Balancing Technology, Trust and Cybersecurity

Join Finance Friend

Connect

  • LinkedIn
  • Facebook
  • Home
  • About Us
  • Contact Us
  • Disclaimer
  • Privacy Policy
  • Site Map
© 2026 Finance Friend • Built with GeneratePress

Loading Comments...