Excel Software.
If i have invested 5000 on 13.11.2005 for 03 years so what will be the interest saperately for every year ( quaterly compounded ). Some thing I want like as below.
Int for 13.11.2005 to 31.04.2006 say A plus principal say B = C
Int for 01.04.2006 to 31.04.2007 say D plus C
thus A,B,C and D should reflect in diffrent column or raws.
Thus by entering amount, value date, rate of interest, and the two dates for which interesr is required i.e. 01.04.2006 to 31.03.2007 like this. but all should come in one sequence.
I hope that any one will definetly help me in this matter.
Thanking you.
From India, Ahmadabad
3If i have invested 5000 on 13.11.2005 for 03 years so what will be the interest saperately for every year ( quaterly compounded ). Some thing I want like as below.
Int for 13.11.2005 to 31.04.2006 say A plus principal say B = C
Int for 01.04.2006 to 31.04.2007 say D plus C
thus A,B,C and D should reflect in diffrent column or raws.
Thus by entering amount, value date, rate of interest, and the two dates for which interesr is required i.e. 01.04.2006 to 31.03.2007 like this. but all should come in one sequence.
I hope that any one will definetly help me in this matter.
Thanking you.
From India, Ahmadabad
Hi,
Please find attached an excel sheet which will explain about calculating COMPOUND INTEREST in two different ways. Hope this may help you.
If you require an excel file just as quoted by you, try to create a format on your own (the best method to learn excel) - I will help you to insert relevant formulas so that you will get exactly what you want.
Regards,
RAJA C S N,
Director
GLOBALedge TRAINING ACADEMY
e-mail:
From India, Madras
Please find attached an excel sheet which will explain about calculating COMPOUND INTEREST in two different ways. Hope this may help you.
If you require an excel file just as quoted by you, try to create a format on your own (the best method to learn excel) - I will help you to insert relevant formulas so that you will get exactly what you want.
Regards,
RAJA C S N,
Director
GLOBALedge TRAINING ACADEMY
e-mail:
From India, Madras
Hi Satish,
While you open the file, you will be prompted with two options. One is to provide a password and the other is to open the file in READ ONLY mode. In this mode, you can open the file, see the contents and work on it. However you can't save the changes done by you.
I normally provide my tutorial files in READ ONLY mode so that the contents will not be deleted even by mistake.
Please give a try.
Regards,
RAJA C S N
GLOBALedge TRAINING ACADEMY
From India, Madras
While you open the file, you will be prompted with two options. One is to provide a password and the other is to open the file in READ ONLY mode. In this mode, you can open the file, see the contents and work on it. However you can't save the changes done by you.
I normally provide my tutorial files in READ ONLY mode so that the contents will not be deleted even by mistake.
Please give a try.
Regards,
RAJA C S N
GLOBALedge TRAINING ACADEMY
From India, Madras
Hello Friends,
Here i got various excel tips and thanx to all u friends,but actualy I am a new comer and want to know that while I am insert new row to my excel work sheet formula doesn't work for that perticular row.any one can suggest me or plz help me out.
plz mail me as quick as possible.
From India, Thana
Here i got various excel tips and thanx to all u friends,but actualy I am a new comer and want to know that while I am insert new row to my excel work sheet formula doesn't work for that perticular row.any one can suggest me or plz help me out.
plz mail me as quick as possible.
From India, Thana
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.
152120-very-use ful-hr-manageme nt-software-bui lt-excel-psa-hr -manager-mainta in-payrrol-exce l-soft.zip
Advanced Excel 2003.pdf
Competancy--exc el---mts___smts _289.xls