Home > Articles > Info Technology

Please Wait ..

to your account


Remember Me

Forgot your password?

Sign-up now

Join CAclubindia.com and Share your Knowledge. Registered members get a chance to interact at Forum, Ask Query, Comment etc.

Browse Articles Info Technology Articles

Displaying 1 - 10 of 41 in 5 pages

What is true MIS?

By Tulasi S Sastri On 16 December 2014 at 10:59

MIS is understood as Management Information Systems by many. However, it is also misunderstood by many, when it comes to what its true meaning is. I have come to think on these lines after seeing varied types of reports in different organizations, be...

Continue Reading

2 comments | 3532 hits

Data Protection In Microsoft-Office

By KumarMukesh (Work in Progress) On 01 December 2014 at 11:12

Data protection are urgent need of hour, to maintain its Confidentiality, Integrity and availability (CIA) but only few of us aware about its impotence.As we aware that Microsoft Office has monopoly in Office automation System, therefore we need to ...

Continue Reading

21 comments | 3815 hits

IT for CA Students – ‘UN-necessary’ or ‘UTMOST-necessary’

By CA Kunal Agrawal On 27 October 2014 at 10:28

Information technology for CA Students UN-necessary or UTMOST-necessaryHello Friends !!!Information Technology..not again, we are not interested in this. Are you thinking like that. If so, then dont ...

19 comments | 6298 hits

COBIT: An IT Framework

By *RENU SINGH * On 08 October 2014 at 10:54

Introduction :- CONTROL OBJECTIVE FOR INFORMATION AND RELATED TECHNOLOGY (COBIT) Cobit is a comprehensive IT framework from ISACA which was launched in 1996. It provides guidelines for auditing of information system for auditors. COBIT has revised t...

Continue Reading

5 comments | 4602 hits

Sumproduct - Advance Excel Formula

By @VaibhavJ On 23 September 2014 at 13:24

SUMPRODUCT –an advance excel formula The SUMPRODUCT function multiplies the corresponding items in the arrays and returns the sum of the results. SYNTAX The syntax for the Microsoft Excel SUMPRODUCT function is: SUMPRODUCT( array1, array2, ... ...

Continue Reading

1 comments | 1995 hits

Automated Prepaid Expenses JV in Excel

By Ramkrishna Mokashi On 18 September 2014 at 12:24

Hello All,Attached is a file which contains the automated prepaid calculation. No Hassles of working out how much is accrued, how much is pending, etc. Just Update the table in the first sheet. And rest will happen automatically. Of course, you are f...

Continue Reading

9 comments | 8547 hits

Reverse/Backward VLOOKUP - Advance Excel function

By @VaibhavJ On 15 September 2014 at 10:50

Reverse or Backward Vlookup or lookup. For understanding reverse or backward VLOOKUP lets get clear about forward / direct VLOOKUP function her : http://www.caclubindia.com/articles/excel-function-vlookup-21678.asp So I assume you are clear ab...

Continue Reading

5 comments | 6853 hits

How to make VLookup Foolproof

By Ramkrishna Mokashi On 12 September 2014 at 10:44

In your day job, you have an excel workbook which is setup to get you the values you need, in the format you need. Probably using basic formulas, including VLookup.Nothing is more annoying and depressing to get your carefully set VLookup formulas get...

Continue Reading

30 comments | 10550 hits

Excel function VLOOKUP

By @VaibhavJ On 11 September 2014 at 10:36

1st Question now a days which comes while soft skill interview is.......Do you know VLOOKUP & if you dont respond immediately there grows eyebrows of interviewer up with that grinny smile on his/her face; lets bettle it out & be the master of...

Continue Reading

16 comments | 12032 hits

Advance Excel function - Indirect()

By @VaibhavJ On 04 September 2014 at 11:23

To understand benefit of indirect function do as I say. Put 100 in cell A1, now in Cell D1 put formula =INDIRECT("A1") & in cell D2 put formula =A1. Result is same in both case then why to put confusing formula in cell D2? Now select ...

Continue Reading

17 comments | 7912 hits

Quick Links


Browse by Category

back to the top