----> EXCEL - any excel functions are useful for accountants / auditors ?

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

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/

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

You have to program it by your own. It is easy and very powerful. Learn to enter formula or operationand its done.

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 :)