Excel Tips Archives - Finance Friend

How to calculate investment return with XIRR in Excel ?

March 6, 2023August 26, 2021 CA. Kalpesh Karia

https://financefriend.in/ Karia CA. Kalpesh

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 […]

How to insert drop down list in excel

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

https://financefriend.in/ Karia CA. Kalpesh

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 […]

How to use SUMIF Formula in excel

June 21, 2017 CA. Kalpesh Karia

https://financefriend.in/ Karia CA. Kalpesh

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 […]

How to remove #N/A error in vlookup

June 17, 2017 CA. Kalpesh Karia

https://financefriend.in/ Karia CA. Kalpesh

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 […]

How to use VLOOKUP function in excel

June 17, 2016July 28, 2015 CA. Kalpesh Karia

https://financefriend.in/ Karia CA. Kalpesh

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 […]