Info Technology Articles

Why you should look at AI positively and not fear from it

Rupesh Maheshwari 24 January 2017 at 11:01

�The price of doing the same old thing is far higher than the price of change.� - Bill ClintonThe world around us is rapidly changing and it is chan

Converting invalid date formats to valid ones in excel

CA Rishabh Pugalia (ExcelNext) 10 January 2017 at 10:43

Unclean or Invalid Dates (DMY Format) should be converted to valid data formats.

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