|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
|Reports generated from business applications often become inputs to new reports.
You end up spending too much time cleaning them up. Here is a new and unimaginably faster way of doing it – using Power Query.
Estimated reading time 15 min
|Grouping in Pivot table is one method of correction spelling mistakes.Here is another option for correcting mistakes using VLOOKUP
Estimated reading time 10 min
Estimated Time Saving many hours!
|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 articles which will help you ensure accuracy of Excel data with minimal effort.
|This is a common requirement and we struggle to get this done.Here is how you can do it very quickly…
Estimated Reading Time 3 min
The query keeps cropping up very often while I work with customers. There are many ways to handle it. I will list down all approaches available as of now along with the pros and cons.
This is a common activity. Go to a browser page, find some tabular data or report and copy-paste it into Excel. Now you waste a lot of time cleaning up the unwanted things which also got pasted.
If you have Excel 2010 or above (Professional Plus or Office 365 edition),
you have a miraculously simple method available now : Power Query…