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 - In this post we will learn about how to get stock quotes for specified all symbols using simple Excel Tricks.
Internal Audit new approach-need of the hour before we get obsolete
In this article I will try to explain SUMIFS function in 5 different scenario from basic to advance.
Name Manager + Indirect function of excel can be used in place of INDEX+MATCH
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
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
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&
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
Certification Course on GSTR-3B Reconciliation with GSTR-2B through Chat GPT