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 Raw data can contain many columns ...
https://efficiency365.com/2016/08/10/data-audit-using-pivot-tables/
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 range, it will return ...
https://efficiency365.com/2016/05/03/how-to-use-formulatext-function-in-excel/
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 where yo...
https://efficiency365.com/2016/04/04/data-validation-using-formula/
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 this article an...
https://efficiency365.com/2015/08/10/how-to-succeed-in-office-politics-using-excel/
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 wrong data for your ...
https://efficiency365.com/2015/07/25/knowledge-pack-green-marks-in-excel/
MOST IMPORTANT BENEFIT of Excel Tables. Spend 10 minutes. Read it. The risk Formulas refer to data. Similarly Validation lists, Pivot Tables, Named Ranges also refer to data ranges. If a referenc...
https://efficiency365.com/2015/06/06/excel-tables-11-auto-update-all-formulas-and-references/
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 has left the org...
https://efficiency365.com/2015/03/14/excel-impact-analysis-trace-dependents/
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 worried about shar...
https://efficiency365.com/2015/03/06/shared-onenote-worried-about-who-has-edited-what/
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 time 10 min Recap Excel opens...
https://efficiency365.com/2014/12/13/csv-import-problems-solved-with-power-query/
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 15 min...
https://efficiency365.com/2014/12/12/global-alert-csv-import-date-misinterpretation-problem-part-2/