We take accuracy of Excel data for granted.
Often the raw data as well as results of formulas can be wrong, outdated or misleading.
Here is a collection of 13 data accuracy articles which will help you ensure the integrity of your Excel data with minimal effort.
Continue reading Knowledge Pack: Data Accuracy in Excel
This is a continuation of the series on error handling – green marks. We will see how to handle Excel formula errors and two Text related (non-formula) errors in this article.
Please read these two articles before reading this article to maintain continuity.
Auditors, Risk Managers, Everyone: Did you know? These green marks are WARNINGS!!Green Marks Part 2: Formulas showing wrong results!
Continue reading Green Marks Part 3: More error handling
I am sure we see these everyday across almost all Excel files. But do you know the meaning and significance of these green marks?
These are WARNINGS – it is Excel’s way of telling you NOT to trust what you see. Billions of people are ignoring these green marks for over a decade. If you are one of them, please read this article and share it with everyone who matters to you.
Continue reading Auditors, Risk Managers, Everyone: Did you know? These green marks are WARNINGS!!