Technology & Tools Articles

IT for CA Students - 'UN-necessary' or 'UTMOST-necessary'

Posted by CA Kunal Agrawal 27 October 2014 23675 Views

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

COBIT: An IT Framework

Posted by *RENU SINGH * 08 October 2014 18210 Views

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

Sumproduct - Advance Excel Formula

Posted by @VaibhavJ 23 September 2014 14394 Views

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, ...

Automated Prepaid Expenses JV in Excel

Posted by Ramkrishna Mokashi 18 September 2014 35108 Views

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

How to make VLookup Foolproof

Posted by Ramkrishna Mokashi 12 September 2014 42027 Views

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

Reverse/Backward VLOOKUP - Advance Excel function

Posted by @VaibhavJ 15 September 2014 108153 Views

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

Excel function VLOOKUP

Posted by @VaibhavJ 11 September 2014 50245 Views

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

Advance Excel function - Indirect()

Posted by @VaibhavJ 04 September 2014 33035 Views

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

5 advantages of using cloud accounting software

Posted by guru 08 July 2014 11928 Views

Any business can be managed efficiently by using business automation software. There are 2 types of software which a business owner can utilize namely Desktop software and Online software (Cloud software). Traditionally Indian companies have been use