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!
Spend 30 minutes and save at least 10 minutes every day. Learn powerful time savers and amazing features which work across Word, Excel and PowerPoint. Have a look.
Post your comments. More videos coming up soon.
Office Usage Best Practices
Word documents stored on OneDrive and SharePoint can be edited by more than one persons simultaneously. This is a very useful and powerful feature. (Read this article for details). Each person can edit in different places. Temporarily the current paragraph is locked for others. When the document is saved, the paragraph is automatically unlocked so that others can work on it.
Continue reading Blocking others from editing parts of the document