Skip to content

Finance Friend

Complete Guide to Finance and Taxation

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

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

Categories

  • Accounts
  • Automation
  • Corporate Law
  • Excel Tips
  • Finance
  • Income Tax
  • Insurance
  • International Tax
  • Introduction to Financial Planning
  • Investment Planning
  • Leadership
  • Loans
  • Money Management
  • Partnership
  • Personal Finance
  • Retirement Planning
  • Tax Planning
  • Time Management

Popular Tags

AS Budget Calculator Capital Gains Charts Corporate Finance Credit Card Data Validation Deductions Depreciation Rates Downloads Excel Formulaes Exemption Financial Planning House Property IFRS Income Tax Rates Income Tax Return Ind AS Leadership Letter of Credit LLP Mutual Fund Notifications Personal Finance Post Office Schemes Press Release SAP Startup TCS TDS TDS Rates

Popular Posts

  • How many AS, Ind AS and IFRS are there ?
  • How many people in India are investing in mutual fund?
  • Due Date Chart of all statutory payments for F Y 2013-14
  • How to Set Financial Goals ?
  • Tax Treatment of Gratuity as per Income Tax Act,1961
  • Depreciation Rate Chart as per Income Tax Act
  • How can we Automate Collection Posting in SAP ?

Recent Comments

  • peolsolutions on How can we Automate Collection Posting in SAP ?
  • Investment Strategies For Beginners: 10 Top Strategies on What is the simplest investment strategy?
  • kelvin on How to Set Financial Goals ?
  • What is an NRO Account ? - Finance Friend on Whether PAN is mandatory for Non Resident Payment?
  • What is Sovereign Gold Bond and how it works? - Finance Friend on How to do Investment Planning ?

Recent Posts

  • 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
  • Resilience: The Key to Thriving in Work, Life, and Leadership
  • From Back Office to Backbone: The Rise of Global Capability Centers

RSS RSS

  • How to Use Feedback Effectively: A Leadership Perspective on Growth and Governance

Archives

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

Loading Comments...