The TOCOL and TOROW functions are just two ways to rearrange data in Microsoft Excel. For example, you can flip the rows and ...

Microsoft Excel 2007 introduced means of sorting and filtering your data by the color of your cells and their text contents. When you use color to highlight important information, such as cost data ...

Often, in the course of putting together a lengthy set of data in Microsoft Excel, users will want to rearrange their cells or add a new one to an established row (in addition to making graphs, which ...

Filtering in Excel allows you to organize your data in multiple ways. 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 ...

Learn the secrets of Excel structured tables to save time, eliminate errors, and create smarter, more dynamic spreadsheets.

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 ...

One typical application for Excel is to find information in a list of data. The simplest way to do this is filtering the data so that Excel does the work of finding the pertinent information for you ...