Have just been test-driving Easy Data Transform, and it has been great at self-service data preparation. It's quite easy to learn and use with its diagram-based approach. I have had great success in transforming a few CSV files, de-duplication using "Unique" transform while concatenating one of the fields, doing multiple replacements including regex on a column, stacking the resulting tables, and exporting automatically based on changes to source datasets.
It has quite a few features not found in Excel's own grid-based Power Query transformations. It's not as powerful as the enterprise Alteryx Designer, but a lot simpler. The UI could use some visual design improvements to make it more appealing! All in all, it's an underappreciated great piece of software!