Create an Excel table in two seconds In addition, notice that the filter feature is automatically applied, so sorting by a specific field is accomplished by a few clicks of the mouse. 6.

Click Sort & Filter > Custom Sort and the Sort dialog box opens. 3. If you have headers, be sure to check the box that says: My data has headers. 4.

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

Not all sorts in Excel are alphabetical. Sometimes, you need to sort by an irregular set of terms, and when that happens, you need to create a custom sort. Here's how.

Helen Bradley demonstrates Excel formatting tricks that will help you when things don't work as planned. Learn her methods now.

Learn how to make custom templates in Microsoft Excel to save you time and effort when creating similar reports or spreadsheet data analysis ...