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 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
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 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
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 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
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 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-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 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
Live class on PF & ESI Enrollment & Returns Filing(with recording)