MUO on MSN

I stopped consolidating sheets by hand because Excel’s INDIRECT function does all the work for me

With the INDIRECT function, you can reference and consolidate key data points across sheets. It's a straightforward process ...

How to remove duplicates in Microsoft Excel to clean up data in individual or multiple columns

You can remove duplicates in Excel in a few steps. Duplicates can create problems when you're dealing with data.

How to merge and unmerge cells in Microsoft Excel in 4 ways, to clean up your data and formatting

You can merge cells in Excel by using a simple drop-down menu, which will let you merge cells in a variety of ways. Here's ...