Category Archives: Power Query

Miracle: Instant Report Clean Up using Power Query

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.

Report clean up using Power Query

Estimated reading time 15 min
Estimated time saving huge!

 

Continue reading Miracle: Instant Report Clean Up using Power Query

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

stop copy pasting from browser - by Dr. Nitin Paranjape

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