Info Technology Files





xls File
38 KB

Convert dr / cr to values in tally exported file

After exporting file from tally in to excel all Dr /Cr values are shown as positive number only, so when we try to add or subtract number we get undesired result. I have crreaed macro taht will convert Cr value as negative keeping format intact. Do po...

Posted on 01 July 2014  (Downloads: 773) Info Technology


pptx File
213 KB

Auditing IT General Controls in ERP Environment

How to conduct ITGC review - Useful IT audit technique...

Posted on 14 June 2014  (Downloads: 638) Info Technology


zip File
31 KB

Balance Sheet Dashboard

4 BS shown in 1 Excel Sheet...

Posted on 23 May 2014  (Downloads: 2798) Info Technology


docx File
14 KB

MS Word Shortcuts

A to Z Shortcut key of MS Office...

Posted on 23 May 2014  (Downloads: 1428) Info Technology


xls File
56 KB

Import data from all sheet to one

To Import/consoildate/combine all sheets data to one sheet yo can use attached excel sheet....

Posted on 19 May 2014  (Downloads: 3092) Info Technology


xls File
121 KB

Challan 281

Excel tool to prepare challan 281. ...

Posted on 09 May 2014  (Downloads: 604) Info Technology


pdf File
631 KB

Information Technology

Compiliation of 1 & 2 Marks Questions & Answers for May 14-IPCC...

Posted on 05 May 2014  (Downloads: 759) Info Technology


docx File
216 KB

All about Cloud Computing

A most emerging technology of which all students should have knowledge....

Posted on 28 April 2014  (Downloads: 1146) Info Technology


zip File
14 KB

Income Tax calculator excel add-ins

Hi Download attached excel file & install / add it as add-ins to your excel. You can calculate Income tax for Individual using following user defined function. Syntex is itax( Income , Age) Select any cell in excel and type =itax(income, age) Ref...

Posted on 28 April 2014  (Downloads: 1311) Info Technology


pdf File
891 KB

Procedure for verification of Tax Audit Report before filing

By using Microsoft Access. Process explained with snapshots for Microsoft Office 2007, 2010 and 2013....

Posted on 27 March 2014  (Downloads: 1074) Info Technology


xlsx File
25 KB

Excel FIFO formula

Excel formula for stock/ investment valuation and gain/loss calculation on FIFO basis...

Posted on 22 March 2014  (Downloads: 7834) Info Technology


doc File
35 KB

Excel Shortcut Keys

EXCEL SHORTCUT KEYS Read more at: http://www.caclubindia.com/share_files/files_upload_form.asp...

Posted on 21 March 2014  (Downloads: 1761) Info Technology


xls File
151 KB

SAP Transaction Codes

SAP T Codes in excel file - All Modules...

Posted on 19 March 2014  (Downloads: 2314) Info Technology


pdf File
1024 KB

Complete Excel Guide

Excel Tips & Tricks for Beginners & Professionals. Simple & Easy to learn. Very Useful for CA Students......

Posted on 04 March 2014  (Downloads: 5088) Info Technology


xlsx File
16 KB

Excel Formula_2nd Part

How to use formula of COUNT, COUNTA, COUNTBLANK, COUNTIF AND COUNTIFS...

Posted on 03 March 2014  (Downloads: 2299) Info Technology


xlsx File
13 KB

Excel Formula_1st Part

How to use formula of Large,Small,Max,Min, MINA...

Posted on 25 February 2014  (Downloads: 2547) Info Technology


xlsx File
389 KB

Excel shortcuts

Complete excel shortcuts...

Posted on 21 February 2014  (Downloads: 2405) Info Technology


pdf File
531 KB

Information System Control and Audit (ISCA)

Short Summary of ISCA (CA Final) Subject for May 2014...

Posted on 15 February 2014  (Downloads: 1672) Info Technology


pdf File
46 KB

Excel Shortcut

excel_shortcut...

Posted on 01 February 2014  (Downloads: 4496) Info Technology


pdf File
488 KB

Monitoring cells with a Watch Window

Monitoring cells with a Watch Window...

Posted on 01 February 2014  (Downloads: 368) Info Technology