Miracle: Instant “Report Clean Up” using Power Query

image 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
Estimated time saving huge!

Continue reading

DO NOT copy paste data from browser. Use Power Query.

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

image

Continue reading