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
FormulaText function in Excel was introduced in version 2013. It requires just one parameter – the cell from which you want to display the formula. Even if you select a
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
Simple. Find glaring mistakes in spreadsheets created by other people. Obviously you have an upper hand now! Of course, you need to know how to find mistakes in spreadsheets. Read
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
MOST IMPORTANT BENEFIT of Excel Tables. Spend 10 minutes. Read it.
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
Shared OneNote notebook is a very effective method of working in a team and keeping everyone informed – without sending a single mail. However, I have noticed that people are
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