Technology & Tools Articles

Converting invalid date formats to valid ones in excel

Posted by CA Rishabh Pugalia (ExcelNext) 26 April 2021 23468 Views

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

Converting numbers with minus sign into negative numbers in Excel

Posted by CA Rishabh Pugalia (ExcelNext) 26 April 2021 15975 Views

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

Posted by CA Kumar Mukesh 25 March 2020 57303 Views

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

Posted by CA Avinash Sunchu 03 November 2016 9882 Views

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

SUMIFS - Advance Excel

Posted by CA Kumar Mukesh 16 April 2017 7114 Views

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

Posted by CA Kumar Mukesh 28 March 2017 20989 Views

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

Extracting data in Microsoft Excel - Advance Filter

Posted by CA Kumar Mukesh 26 April 2021 25628 Views

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

Posted by Arbuda Dave 07 February 2017 5044 Views

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

Ageing report from pivot table - Advance Excel

Posted by CA Kumar Mukesh 26 April 2021 68236 Views

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

Posted by Rahul Magan 27 May 2016 6054 Views

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&