Excel has several advanced sorting options, but most of us never venture beyond the ordinary alphabetic and numeric sorts. If you need more than a simple sort, check out Excel’s advanced sorting ...

Microsoft Excel 2007 is one of the main components of Microsoft Office 2007. It is a popular tool used by small businesses to create spreadsheets for tracking important data such as sales and customer ...

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

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

I have a simple spreadsheet with 15 columns and ~200 rows. At some point when doing a custom sort on it, one of the columns was not selected, therefore destroying the relationship of the data. Excel ...

There are lots of times in Excel when you find yourself entering the same data over and over again. When you do, ask yourself if you can’t do the task more efficiently another way. For example, if you ...

Placing spreadsheet data into a table quickly formats it and makes it easy to work with and analyze. Here’s how to use this basic yet powerful Excel tool. Tables are one of the fundamental tools in ...