Easy Office
LCI Learning

Download Files uploaded by CA Rajesh Prabhu K.





xls File
27 KB

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


xls File
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: 857) Info Technology


xls File
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: 311) Accounts


xls File
35 KB

Project plan gantt Chart

Project plan gantt Chart using conditional formatting technique...

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


xls File
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: 3277) Others


xls File
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


xls File
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


xls File
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


xls File
19 KB

xls File
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: 4027) Info Technology


xls File
40 KB

Teach Alphabet

Enable macros; keep speaker on; To repeat type Ctrl A...

Posted on 27 April 2009  (Downloads: 195) Others