Download Files uploaded by CA Rajesh Prabhu K.

27 KB

Bar graph with helper stacked bars

Bar graph with helper stacked bars

Very helpful for making graphic presentation of a two way table...

Posted on 28 April 2012 (Downloads: 545) Info Technology

78 KB

Chart to show plan and performance overlap each other

This will help you to create a chart with bars overlap each other rather than stacked side by side. Small trick grat visual value...

Posted on 25 April 2012 (Downloads: 858) Info Technology

25 KB

IFRS Leases to find out whether a lease is operational lease

Spreadsheet incorporates a decision tree to find out whether a lease is opeartinal lease or financial lease. If you want to know how the spreadsheet is used please unprtotect the sheet pass word in not used...

Posted on 20 April 2012 (Downloads: 313) Accounts

35 KB

Project plan gantt Chart

Project plan gantt Chart using conditional formatting technique...

Posted on 18 April 2012 (Downloads: 433) Info Technology

82 KB

Provident fund ECR filing text file creation utilty

Notes: This Excel file contains Macro which creates text file which is used for uploading Provident Fund ECR. Enable Macros, Enter data in sheet called' FINALâ€™. Be aware of the data validation Rules mentioned in the 'ref2' sheets. I have incorporated...

Posted on 13 April 2012 (Downloads: 3278) Others

33 KB

Frequency table using frequency function and array formulas

Using frequency function and Array formulas together to constuct a frequency table...

Posted on 12 April 2012 (Downloads: 600) Info Technology

22 KB

How to make use of array formula

Array formula example:Place the curser in the formula bar (as if you are editing the formula in the formula bar) and press control shift enter together ...

Posted on 10 April 2012 (Downloads: 1348) Info Technology

20 KB

Sales Funnel

Sales Funnel Graphic with out using graph in excel (I am not sure whether any inbuilt graph exists for this type of requirement). The Rept function is used here which is very simple) ...

Posted on 24 March 2012 (Downloads: 347) Info Technology

19 KB

Non resident companies taxation of business income and FTS

taxation of business income and FTS...

Posted on 30 June 2010 (Downloads: 137) Income Tax

67 KB

Vlookup with Match formula

Vlookup looks for data matching date in column B( Main sheet) with date row in column A(fxdata sheet) where as Match formula exactyly pix up currency row in "fxdata" matching currency in cloumn D in sheet "Main"...

Posted on 12 June 2010 (Downloads: 4029) Info Technology

40 KB