New use of Pivot Table – Data Quality Audit
Pivot Table is used for data analysis. But did you know that it can also be used for checking data quality? Estimated reading time 7 min.
Pivot Table is used for data analysis. But did you know that it can also be used for checking data quality? Estimated reading time 7 min.
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
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
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
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
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,
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
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
We will continue with more usage scenarios for Flash Fill.
Yes. You use Pivot Tables everyday. Now it is time to find out the real power and nuances. 5.5 hours video, exercises, samples, Q&A.
Learn Power BI using the concepts you already know in Excel. Fast transition, in-depth coverage and immediately usable.
