close x



Browse Articles Info Technology Articles


16 June 2015 at 10:28

An overview on e-commerce transactions

  POSTED BY CA Pankaj Kr Agrawal

Today e-commerce has become an integral part of everyday life. Accessibility to E-commerce platforms is not a privilege but rather a necessity for most people, particularly in the urban areas. India is witnessing a digital revolution wit

  4 comments |   3529 Views


05 June 2015 at 10:45

Managing your work efficiently: The Outlook way

  POSTED BY RAVITOSH KUMAR

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

  9 comments |   4846 Views


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 |   7105 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 |   4694 Views


21 January 2015 at 10:42

Vlookup's Advance Function (Advance Excel)

  POSTED BY CA 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 |   13712 Views


17 January 2015 at 12:38

Excellence in Excel Series - Part IV Macros

  POSTED BY CA ANKUSH AGGARWAL

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 |   7055 Views


13 January 2015 at 10:19

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

  POSTED BY CA 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 |   7112 Views


12 January 2015 at 10:47

Data Consolidation in Microsoft Excel (Advance Excel)

  POSTED BY CA 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 |   10093 Views


10 January 2015 at 11:13

Excellence in Excel - Part III

  POSTED BY CA ANKUSH AGGARWAL

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 |   10126 Views


08 January 2015 at 11:05

Linking Tally with Excel Steps (Advance Excel)

  POSTED BY CA 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

  74 comments |   11133 Views


06 January 2015 at 10:36

Excellence in Excel Series- Part II

  POSTED BY CA ANKUSH AGGARWAL

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 |   5029 Views


03 January 2015 at 10:59

Scenario Manager in Excel (Revised)

  POSTED BY CA 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 |   6654 Views


22 December 2014 at 11:02

Scenario Manager in Excel- A step towards Advance Excel

  POSTED BY CA 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 |   3436 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 |   4865 Views


01 December 2014 at 11:12

Data Protection In Microsoft-Office

  POSTED BY CA 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 |   4458 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 |   7092 Views


08 October 2014 at 10:54

COBIT: An IT Framework

  POSTED BY *RENU SINGH *

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 |   5147 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 |   3051 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 |   9477 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 : http://www.caclubindia.com/articles/excel-function-vlookup-21678.asp So I assume you are clear ab

  6 comments |   15313 Views









Share on :