How-To Geek on MSN

This hidden Excel tool can quickly clean up your data automatically

Use Power Query's M language to quickly fix names, remove hidden characters, extract numbers, and merge columns.
TechRepublic

How to create and populate a table in Microsoft Excel’s Power Query

You can enter data into a Microsoft Excel sheet or run a bit of M code in Microsoft Excel Power Query when you need to create a table. Updating data in a Microsoft Excel workbook is common, but you ...
How-To Geek on MSN

I finally automated Excel timestamps, and it fixed my biggest data trust problem

Excel's Power Query lets you build report-level and table-level timestamps that update on refresh.
TechRepublic

How to combine values from a column into a single cell using Microsoft Excel’s Power Query

How to combine values from a column into a single cell using Microsoft Excel’s Power Query Your email has been sent The article How to concatenate values in a single Excel column to a single row shows ...