Browse Articles Info Technology Articles

23 January 2015 at 10:25

The challenges in auditing SAP

  POSTED BY Hari Iyer

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

  1 comments |   6670 Views

22 January 2015 at 10:45

ERP Programme Assurance

  POSTED BY Hari Iyer

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

  1 comments |   4481 Views

21 January 2015 at 10:42

Vlookup's Advance Function (Advance Excel)

  POSTED BY KumarMukesh

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

  9 comments |   13190 Views

17 January 2015 at 12:38

Excellence in Excel Series - Part IV Macros


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

  13 comments |   6771 Views

13 January 2015 at 10:19

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

  POSTED BY KumarMukesh

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

  15 comments |   6731 Views

12 January 2015 at 10:47

Data Consolidation in Microsoft Excel (Advance Excel)

  POSTED BY KumarMukesh

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

  43 comments |   9617 Views

10 January 2015 at 11:13

Excellence in Excel - Part III


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

  17 comments |   9876 Views

08 January 2015 at 11:05

Linking Tally with Excel Steps (Advance Excel)

  POSTED BY KumarMukesh

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

  73 comments |   10193 Views

06 January 2015 at 10:36

Excellence in Excel Series- Part II


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

  14 comments |   4732 Views

03 January 2015 at 10:59

Scenario Manager in Excel (Revised)

  POSTED BY KumarMukesh

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

  13 comments |   6392 Views

22 December 2014 at 11:02

Scenario Manager in Excel- A step towards Advance Excel

  POSTED BY KumarMukesh

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

  1 comments |   3255 Views

16 December 2014 at 10:59

What is true MIS?

  POSTED BY Tulasi S Sastri

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

  3 comments |   4710 Views

01 December 2014 at 11:12

Data Protection In Microsoft-Office

  POSTED BY KumarMukesh

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

  21 comments |   4324 Views

27 October 2014 at 10:28

IT for CA Students – ‘UN-necessary’ or ‘UTMOST-necessary’

  POSTED BY CA Kunal Agrawal

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

  20 comments |   6894 Views

08 October 2014 at 10:54

COBIT: An IT Framework


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

  5 comments |   5026 Views

23 September 2014 at 13:24

Sumproduct - Advance Excel Formula

  POSTED BY @VaibhavJ

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

  1 comments |   2816 Views

18 September 2014 at 12:24

Automated Prepaid Expenses JV in Excel

  POSTED BY Ramkrishna Mokashi

Hello All,Attached is a file which contains the automated prepaid calculation. No Hassles of working out how much is accrued, how much is pending, etc. Just Update the table in the first sheet. And rest will happen automatically. Of course, you are f

  9 comments |   9188 Views

15 September 2014 at 10:50

Reverse/Backward VLOOKUP - Advance Excel function

  POSTED BY @VaibhavJ

Reverse or Backward Vlookup or lookup. For understanding reverse or backward VLOOKUP lets get clear about forward / direct VLOOKUP function her : So I assume you are clear ab

  6 comments |   12448 Views

12 September 2014 at 10:44

How to make VLookup Foolproof

  POSTED BY Ramkrishna Mokashi

In your day job, you have an excel workbook which is setup to get you the values you need, in the format you need. Probably using basic formulas, including VLookup.Nothing is more annoying and depressing to get your carefully set VLookup formulas get

  30 comments |   11344 Views

11 September 2014 at 10:36

Excel function VLOOKUP

  POSTED BY @VaibhavJ

1st Question now a days which comes while soft skill interview is.......Do you know VLOOKUP & if you dont respond immediately there grows eyebrows of interviewer up with that grinny smile on his/her face; lets bettle it out & be the master of

  16 comments |   12795 Views