Technology & Tools Articles

Excellence in Excel Series - Part IV Macros

Posted by CA ANKUSH AGGARWAL 17 January 2015 25523 Views

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)

Posted by CA Kumar Mukesh 05 July 2016 29698 Views

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)

Posted by CA Kumar Mukesh 05 July 2016 41415 Views

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

Posted by CA ANKUSH AGGARWAL 10 January 2015 36694 Views

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)

Posted by CA Kumar Mukesh 30 November 2020 197209 Views

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

Posted by CA ANKUSH AGGARWAL 06 January 2015 20806 Views

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)

Posted by CA Kumar Mukesh 03 January 2015 25231 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 15339 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 17276 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 16481 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