Technology & Tools Articles

Scenario Manager in Excel (Revised)

Posted by CA Kumar Mukesh 03 January 2015 25180 Views

Scenario Manager in Excel A Step Towards Advance Excel (Revised)On Scenario Manager, I have already written an article but that was not properly presented and had some confusions. After getting review from some users, where they suggested that if t

Scenario Manager in Excel- A step towards Advance Excel

Posted by CA Kumar Mukesh 22 December 2014 15312 Views

LEARNING SCENARIO MANAGER IN EXCEL "A STEP TOWARDS ADVANCE EXCEL"Scenario Manager is a common top-down analytical approach where numerous inputs are modified at a time, consistent with a common theme, and corresponding outputs are then ana

What is true MIS?

Posted by Tulasi S Sastri 16 December 2014 17235 Views

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

Data Protection In Microsoft-Office

Posted by CA Kumar Mukesh 01 December 2014 16446 Views

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

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

Posted by CA Kunal Agrawal 27 October 2014 23662 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 18172 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 14357 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 35081 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

Reverse/Backward VLOOKUP - Advance Excel function

Posted by @VaibhavJ 15 September 2014 108119 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

How to make VLookup Foolproof

Posted by Ramkrishna Mokashi 12 September 2014 41939 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