Tag Archives: Operational Risk

Excel risk Mitigation

This article is for CFOs, CEOs and other members of Senior Leadership Team. It requires just 10 minutes to read. But it will reduce your personal as well as organizational Operational Risk significantly.  Notice the green mark  below.
This is the biggest Excel risk.

Excel Risk - Demo

If you see even a single green mark, you should send the file back.
Ask the sender to handle all the green marks and send the revised file to you.
Of course, they may not know what you are talking about.
Ask them to read these 5 articles: Knowledge Pack: Green Marks in Excel

The rule is, Excel sheet with Green Marks should not be sent to anybody. It is the sender’s responsibility to remove all errors – not the recipient’s.

Continue reading Excel risk Mitigation

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 4: Inconsistent Formulas

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

In this article, we will cover two more potential errors related to Inconsistent Formulas.

How to handle inconsistent formulas in Excel - Dr. Nitin Paranjape

Continue reading Green Marks Part 4: Inconsistent Formulas

Green Marks Part 3: More error handling

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!

Green marks in Excel - more error handling by Dr. Nitin Paranjape

Continue reading Green Marks Part 3: More error handling

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!

Auditors, Risk Managers, Everyone: Did you know? These green marks are WARNINGS!!

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.

green marks in Excel by Dr. Nitin Paranjape

Continue reading Auditors, Risk Managers, Everyone: Did you know? These green marks are WARNINGS!!