Info Technology Articles


Converting numbers with minus sign into negative numbers in Excel

  CA Rishabh Pugalia (ExcelNext)    09 January 2017 at 11:10

Lets see how to achieve this using a hidden trick of Text to Column. Converting numbers with trailing minus sign into negative numbers.



Rediff Money | How to get latest stock price in Microsoft Excel

  CA Kumar Mukesh    23 November 2016 at 11:23

Rediff money - In this post we will learn about how to get stock quotes for specified all symbols using simple Excel Tricks.



Internal Audit new approach-Artificial Intelligence

  CA Avinash Sunchu    03 November 2016 at 10:52

Internal Audit new approach-need of the hour before we get obsolete



SUMIFS - Advance Excel

  CA Kumar Mukesh    18 October 2016 at 12:16

In this article I will try to explain SUMIFS function in 5 different scenario from basic to advance.



Two way lookup in Microsoft Excel - Advance Excel

  CA Kumar Mukesh    29 September 2016 at 10:55

Name Manager + Indirect function of excel can be used in place of INDEX+MATCH



Extracting data in Microsoft Excel - Advance Filter

  CA Kumar Mukesh    30 August 2016 at 11:05

This article is in continuation with my Advance Excel tips and inspired by one of my friend facing problems in extracting relevant data in Microsoft Excel from Huge Raw Data, dumped from ERP software.



Don't create a data governance tug of war between financial pros and IT staff

  Arbuda Dave    11 August 2016 at 11:11

Don't Create a Data Governance Tug of War between Financial Pros and IT Staff



Ageing report from pivot table - Advance Excel

  CA Kumar Mukesh    31 May 2016 at 10:59

We all are finance professionals, some may be in INDUSTRY few in PRACTICE and most of us are student to become future professionals. But whatever stage we are everyone have to face computer screen filled with Microsoft Excel Spreadsheets



IFC - Relevance of Information Technology in Internal Controls

  Rahul Magan    27 May 2016 at 10:27

The purpose of internal controls is to identify, manage and control risks that could prevent the organization from achieving its objectives. The information technology (IT) function designs, develops, implements and maintains much of an organization&



Understanding Security Review Program

  B.COM, ACA, DISA Namrata    22 April 2016 at 10:50

When do we consider that Information system assets are secure ?We consider them secure when the expected losses that will occur over some time are at an acceptable level.From the above it is evident that it is not possible to safeguard all assets and