How-To Geek on MSN

How to use Excel's Power Query to tidy up messy spreadsheet data

New columns are always added to the right edge of the dataset. Simply click and drag a column by its header to move it. Also, ...

Excel’s Advanced Filter Features Made Easy : From Criteria Ranges to Copying Results

Learn advanced filtering in Excel with a criteria area, OR and AND logic, and copy results to isolate the right rows fast.