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