Unclean or Invalid Dates (DMY Format) should be converted to valid data formats.
Converting numbers with trailing minus sign into negative numbers.
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
Excel Means Excellence
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, outlining w
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
A report by Gartner Inc reflected that cloud computing will constitute the bulk of IT spending by 2016. In India alone, it is predicted that the cloud market will reach over $3 billion by next year�an almost five-fold increase fr
Startup India a massive movement to boost digital entrepreneurship in India launched by PM Narendra Modi which will generate large number of employment in the country, it will encourage young entrepreneurs for hassle-free st
Few Years Back� we all wasted a lot time visiting a bank. At times, we even had to take leave from work because our bank did not open before 10 in the morning and by time we stepped out after finishing his account-related work, it would be pas
As we all know E-COMMERCE Is the Latest Trend and without E-wallet services , ECommerce is Incomplete. In this article we will discuss EVERYTHING YOU SHLOULD KNOW ABOUT E-WALLETS.As per Reserve Bank of India (RBI)'s directive these digital wallet
Today e-commerce has become an integral part of everyday life. Accessibility to E-commerce platforms is not a privilege but rather a necessity for most people, particularly in the urban areas. India is witnessing a digital revolution wit
Every professional aspires to be a good manager, stay efficient. To achieve this, one needs a lot of support from our colleagues and assistants. Ever wondered, how technology has been our colleague and assistant or just a tool in managing our work with
Many businesses use SAP application to help them plan their resources and activities. Its flexibility and range makes it a challenge to audit. Hari Iyer offers some advice: SAP is highly configurable and implementations often vary, even within variou
ERP programme assurance key to saving moneyBy Hari IyerThe mantra for every senior management is to ensure that every penny counts in the management of their company. Instead of looking for various cost saving measures, one could increase the return
Lookups in Microsoft Excel, most of us always preferred to go with VLOOKUP as it is regarded as a basic lookup function in Microsoft Excel and also essential for those who willing to work or already worked on
You can also submit your article by sending to firstname.lastname@example.orgSubmit article