Tag Archives: Data quality

Knowledge Pack: Data Accuracy in Excel

We take accuracy of Excel data for granted.

Often the raw data as well as results of formulas can be wrong, outdated or misleading.

Here is a collection of 13 data accuracy articles which will help you ensure the integrity  of  your Excel data with minimal effort.

Excel data accuracy knowledge pack

Continue reading Knowledge Pack: Data Accuracy in Excel

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

Bad Data to Good Data: Fill gaps using Power Query

This is a continuation of a series on how to convert badly formatted data into an easy to analyze – tabular format. In this article, we are talking about data which has gaps and how to fill gaps efficiently. This is a new approach available using Power Query – it is fast and effective. Have a look and save hours of your precious time.

fill gaps in data using Power Query

Continue reading Bad Data to Good Data: Fill gaps using Power Query

Miraculous Automatic Data Cleanup in Excel

This is the continuation of data cleanup series. In this article we discuss a newly introduced feature “Flash Fill” which is almost miraculous and difficult to believe. When I demonstrate this feature during my seminars, most people suspect that I am playing some kind of trick!

It opens up a new way of handling data cleaning tasks which would have either been very time consuming or impossible using existing methods.

Data Cleanup

Continue reading Miraculous Automatic Data Cleanup in Excel

Good Data vs. Bad Data: How to identify?

This article shows you simple and immediately usable methods of understanding whether the data you have is good or bad.

This article has intentionally been kept short and to the point so that it is practically usable as a set of best practices.

A more detailed version of this article is being written by an expert in the field, which will be also be published as a guest post soon.
Continue reading Good Data vs. Bad Data: How to identify?