Microsoft Excel 2010 can convert a worksheet to a data table to help you quickly analyze your related data in formatted rows and columns. When you need to expand the table layout, apply the Home tab ...

Columns organize data in Excel, and are often used as categories with headers to sort cells. You can simply right-click on an existing column to add another column immediately before it. To add ...

Generate a list of unique entries in an Excel column Your email has been sent When you need to get rid of duplicates in a column, Excel's advanced filtering options will do the trick. This quick ...

Sorts are a simple task in Microsoft Excel if all you need is an ascending or descending sort. Excel is smart enough that it can interpret the data range. Not all sorts are so easy. Fortunately, Excel ...

In Microsoft Excel, you can convert your data into many types of charts. However, frustratingly, there's no option for a ...

An icon in the shape of a lightning bolt. Impact Link Excel is a great program with hundreds of helpful functions. Unfortunately, one function it's lacking is a simple way to merge two or more columns ...

It's time to dump the pie charts and move to donuts or even waterfalls to show off your data in ways people can better grasp. Have you noticed that people groan when you pop open a spreadsheet to ...

Data is rarely properly formatted and structured when you import it. Try these eight tips for fast data cleanup in Microsoft Excel. Data comes in from an increasing number of sources these days. For ...