----> EXCEL - any excel functions are useful for accountants / auditors ?
2007-12-24 05:35:56 · 5 answers · asked by -----> Need Help 1 in Business & Finance ➔ Careers & Employment ➔ Financial Services
Microsoft Excel provides a series of functions destined to perform various types of financially related operations.
The Present Value which is the current value of an investment or a loan,The Future Value is the value the loan or investment will have when the loan is paid off or when the investment is over,The Number Of Periods which is the number of payments that make up a full cycle of a loan or an investment,Calculating the Future Value of an investment, Calculating the Monthly Payments of a Loan,The Amount Paid As Interest During a Period,Evaluating the Amount Paid As Principal, Evaluating the Amount Paid As Principal are a few examples of excel functions which are useful for accountants / auditors
2007-12-28 04:42:25 · answer #1 · answered by V.T.Venkataram 7 · 0⤊ 0⤋
Hi
Click the Question mark on the standard Excel toolbar. In the search box put
Financial Functions
Each function has an explanation of how it works along with examples to use.
Pay attention to the requirement that the Analysis Tool Pack needs to be installed and checked in Tools > Add-ins.
-Jim Gordon
Microsoft Mac MVP
MVPs are independent and do not work for Microsoft
http://mvp.support.microsoft.com/
2007-12-26 11:21:15 · answer #2 · answered by jimgmacmvp 7 · 0⤊ 0⤋
r u good with pivot tables ? vlookup ? sumif ? formula auditing ? etc.. these are essential for accountants / auditors.. If you are looking for some serious learning take a look at this website www.excelgoodies.com , they teach you all online.. its an instructor led training that happens online..
Good Luck :)
2007-12-24 14:34:22 · answer #3 · answered by Anonymous · 0⤊ 0⤋
You can use a product called prism
it connects to your excel in 3 steps and you can start analyzing your excel file/s in no time (i think its in BETA now so it should be free)
it can be found in
http://www.sisense.com
hope it helps
2007-12-26 03:08:36 · answer #4 · answered by adi a 1 · 0⤊ 0⤋
You have to program it by your own. It is easy and very powerful. Learn to enter formula or operationand its done.
2007-12-25 06:40:44 · answer #5 · answered by jhong 2 · 0⤊ 0⤋