Technology & Tools Articles

Managing your work efficiently: The Outlook way

Posted by RAVITOSH KUMAR 05 June 2015 17958 Views

Every professional aspires to be a good manager, stay efficient. To achieve this, one needs a lot of support from our colleagues and assistants. Ever wondered, how technology has been our colleague and assistant or just a tool in managing our work with

The challenges in auditing SAP

Posted by Hari Iyer CA, MBA, CISA, FCPA 23 January 2015 35059 Views

Many businesses use SAP application to help them plan their resources and activities. Its flexibility and range makes it a challenge to audit. Hari Iyer offers some advice: SAP is highly configurable and implementations often vary, even within variou

ERP Programme Assurance

Posted by Hari Iyer CA, MBA, CISA, FCPA 22 January 2015 17554 Views

ERP programme assurance key to saving moneyBy Hari IyerThe mantra for every senior management is to ensure that every penny counts in the management of their company. Instead of looking for various cost saving measures, one could increase the return

Vlookup's Advance Function (Advance Excel)

Posted by CA Kumar Mukesh 21 January 2015 57916 Views

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

Posted by CA ANKUSH AGGARWAL 17 January 2015 25469 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 13 January 2015 29636 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 12 January 2015 41367 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 36651 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 08 January 2015 197087 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 20735 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