Auditing Data using Pivot tables
I wrote an article about Data Audit using Pivot long back. Now, I have converted it to a comprehensive video. Have a look: How to perform Data Audit using Pivot
I wrote an article about Data Audit using Pivot long back. Now, I have converted it to a comprehensive video. Have a look: How to perform Data Audit using Pivot
This is the continuation of the earlier article about Validations. Data Validation using Formula is not very well understood. Hence this article. Try it out and you will immediately know
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
Like column names, table names can also be used in formulas. Read the previous article to understand the context.
Most probably, you have been missing this Auto-copy feature for the last 8 years. Take 3 minutes to find out how it can simplify your life and increase accuracy.
The Need: Trace Dependents Excel workbooks are complex. Multiple persons share and handle the same file. We keep mailing them to each other. Often the person who created the file
In the previous article we saw the problem with importing CSV files. Here is how the new Power Query can be used to clean the data while importing. Estimated reading
This is a very common and dangerous inaccuracy. Big operational risk! Check all your dates imports after reading this article. Share it with your colleagues as well. Estimated reading time
Yes. You read it correctly. Everyone does it. But still.It is very dangerous. DO NOT do it. Read on to find out why. Estimated reading time 7 min