The ability to move columns in Excel is a great benefit when dealing with long strands of data in Excel. You can easily move a column into another column, regardless of whether or not the other column ...

Manually organizing data in Microsoft Excel is a real pain. That's why we don't recommend doing it. One simple task, learning how to alphabetize in Excel, is not necessarily as intuitive as we would ...

One of the most underused lookup and reference functions in Microsoft Excel is the DROP function. This powerful yet simple ...

Using a filter, you can cut down the amount of data shown on your sheet based on the values for either a certain selection, such as a certain column, or for the whole document. You can also reorder ...

I use these functions to summarize data with formulas instead of dialog boxes. That makes it easier to see exactly what's ...

Microsoft Excel's built-in sorting features make it a handy application for small businesses looking to organize a list of events. Say you have a series of upcoming meetings or want to keep track of ...

If you need to sort, filter, and manipulate your Excel 2007 data but you don't know how to take advantage of Filters, I have just the thing for you. Watch this two-minute long Business Hacks exclusive ...

It's often useful to freeze header rows in place in Microsoft Excel to remember what type of data is in various columns as you scroll or search through a lengthy spreadsheet. You can also make sure ...

How to quickly make Excel subtotals stand out from the data Your email has been sent Microsoft Excel’s Subtotal feature is a great tool, but you can make the ...