Category Archives: Risk

Knowledge Pack: Green Marks in Excel

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!).

  1. Auditors, Risk Managers, Everyone: Did you know? These green marks are WARNINGS!!
  2. Green Marks Part 2: Formulas showing wrong results!
  3. Green Marks Part 3: More error handling
  4. Green Marks Part 4: Inconsistent Formulas
  5. 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!

How Outlook helps you prevent inadvertent leakage of sensitive information

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

Global Alert: CSV import Date Misinterpretation Problem – Part 2

This is a very common and dangerous inaccuracy.
Big operational risk!

CSV import date problem

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 Marks Part 5/5 (Background Error Checking in Excel)

Fourth article in Error Handling (Background Error Checking or Green mark) series. Read these articles first to maintain continuity.
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 and Green Marks Part 4: Inconsistent Formulas

In this article, we cover the remaining three types of errors: Unprotected Formula, Formula refers to empty cells and Data Validation Error.

image

Continue reading Green Marks Part 5/5 (Background Error Checking in Excel)

Green Marks Part 2: Formulas showing wrong results!

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.

image

Continue reading Green Marks Part 2: Formulas showing wrong results!

Copy formulas automatically and accurately (even with blanks)

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!

image

Continue reading Copy formulas automatically and accurately (even with blanks)

Legal: You can be cheated using Track Changes

you can be cheated using track changes

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