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!).
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… read on to find out.
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!
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.