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.
Continue reading Knowledge Pack: Data Accuracy in Excel
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!
Continue reading Green Marks Part 3: More error handling
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.
Continue reading Green Marks Part 2: Formulas showing wrong results!
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.
Continue reading Auditors, Risk Managers, Everyone: Did you know? These green marks are WARNINGS!!
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.
Continue reading Bad Data to Good Data: Fill gaps using Power Query
We will continue with more usage scenarios for Flash Fill.
Continue reading Data Clean up using Flash Fill (In-Depth)
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.
Continue reading Miraculous Automatic Data Cleanup in Excel
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?