Info Technology Articles

Vlookup's Advance Function (Advance Excel)

CA Kumar Mukesh 21 January 2015 at 10:42

Lookups in Microsoft Excel, most of us always preferred to go with VLOOKUP as it is regarded as a basic lookup function in Microsoft Excel and also essential for those who willing to work or already worked on

Excellence in Excel Series - Part IV Macros

CA ANKUSH AGGARWAL 17 January 2015 at 12:38

EXCELLENCE IN EXCEL SERIES PART IV-MACROS Hey Friends,I am back with another article on most easy and yet unpopular excel function-macros.Many of us as soons as hear the word Macros ,Only one thing comes into mind-Difficult.But friends

Data Consolidation in Microsoft Excel Part-2 (Advance Excel)

CA Kumar Mukesh 13 January 2015 at 10:19

Before you like to proceed with this article I like to request to you please go through with my previous article on this Microsoft Excel Function, if you still have not read click here &qu

Data Consolidation in Microsoft Excel (Advance Excel)

CA Kumar Mukesh 12 January 2015 at 10:47

DATA CONSOLIDATION IN MICROSOFT EXCELWe all are finance professionals or students of respective professional institute. In which ever field we are workings, no one can afford to be untouchable with Microsoft Excel. In most of cases, more than half o

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