These marks indicate some potential error. Outdated formulas, numbers stored as text and so on. If you ignore these errors, you are at a significant risk of viewing and using wrong data for your decision making. Here is a set of articles which explain exactly how to utilize these green marks to your advantage. These are your best friend.
Never interpret anything in any Excel file unless you are sure that all the green marks are handled (all potential errors are corrected!).
- Auditors, Risk Managers, Everyone: Did you know? These green marks are WARNINGS!!
- Green Marks Part 2: Formulas showing wrong results!
- Green Marks Part 3: More error handling
- Green Marks Part 4: Inconsistent Formulas
- Green Marks Part 5/5 (Background Error Checking in Excel)
Share this critical information with your boss, colleagues, subordinates and loved ones. Everyone needs to know this!
You may not have even realized this. But there is a very high chance that you have leaked out confidential information before – not once, but many times. How does this happen? and How does Outlook help you protect yourself and prevent inadvertent leakage… read on to find out.
Continue reading How Outlook helps you prevent inadvertent leakage of sensitive information
This is a very common and dangerous inaccuracy.
Big operational risk!
Check all your dates imports after reading this article.
Share it with your colleagues as well.
Estimated reading time 15 min
Continue reading Global Alert: CSV import Date Misinterpretation Problem – Part 2
Green mark in top left corner of Excel cells is an indication that something is wrong with the data you see. Read this article first to understand the concept: Auditors, Risk Managers, Everyone: Did you know? These green marks are WARNINGS!!
In this article, we will discuss the most important and potentially dangerous error which is commonly ignored. Read on and share it with as many people as you can.
Continue reading Green Marks Part 2: Formulas showing wrong results!
Imagine that you have 50,000 rows of data. You want to add a new calculated column. Adding the formula is easy. But copying it to 50,000 rows is nothing but frustration.
Three methods are typically used: All of them are inefficient!
Copy and Paste, Drag and Double Click. Drag is lengthy – so is Copy Paste. Double Click is DANGEROUS because it stops if the column on the left has a blank cell. And usually we have lots of blank cells – at least we have to assume so!
Of course, there is a solution – a magical solution!
Continue reading Copy formulas automatically and accurately (even with blanks)
No. I am NOT talking about removing the track changes metadata here. That is easily done using Inspect Document. The problem is that Track Changes can be misused to cheat you. It is extremely easy to cheat and difficult to detect it. Read on to find out the solution.
Continue reading Legal: You can be cheated using Track Changes