Use of MS Excel by CAs

how to use the financial functions of excel more effectively

use of excel as an audit tool,pivot tables,

linking of sheets, coloumns &  rows using excel formule

more emphasis should be given to ms-excel as an audit tool.

VLOOKUP FUNCTION

RUNNING MACROS

Check in shared files, one file is thr on excel sheet..that will help u lot..

If not mail me at apurvajain.2005 @ gmail.com

i will send u the same..

Use of Macros to reduce the repetitive work, linking trail balance, profit and loss and balance sheet and capital budgeting.

Elite Members,

Greetings!

Even if you've used Excel for years, you still probably don't take advantage of all of its power, flexibility and scope of functions. You need insider information to master this potent tool's advanced formulas and functions - and that help is here!