Info Technology Articles

Excellence in Excel - Part III

CA ANKUSH AGGARWAL 10 January 2015 at 11:13

How to use VLOOKUP in ExcelOn many request to write an article on VLOOKUP,I tried my best to fulfill the requests. VLOOKUP is a powerful Excel function that allows you to look for a specified value in one column of data in

Linking Tally with Excel Steps (Advance Excel)

CA Kumar Mukesh 08 January 2015 at 11:05

Linking Tally with Microsoft ExcelIf you are using tally and preparing reports from Tally Data, then have you observed, any time, there is additional work load or repetition of work. Means to generate reports from tally you need to first update tall

Excellence in Excel Series- Part II

CA ANKUSH AGGARWAL 06 January 2015 at 10:36

EXCELLENCE IN EXCEL-PART 2-USING SUMIF FUNCIONSUMIF functionIn this function SUMIF, you add the numbers present within a criteria.The SUMIF FunctionThe SUMIF function needs 3 parameters. The range of criteria The crit

Scenario Manager in Excel (Revised)

CA Kumar Mukesh 03 January 2015 at 10:59

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

CA Kumar Mukesh 22 December 2014 at 11:02

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?

Tulasi S Sastri 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

Data Protection In Microsoft-Office

CA Kumar Mukesh 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

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

CA Kunal Agrawal 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

COBIT: An IT Framework

*RENU SINGH * 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

Sumproduct - Advance Excel Formula

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