Microsoft Excel 2013 Plain & Simple

Chapter 11. Sorting and filtering worksheet data

In this section:

• Sorting worksheet data

• Creating a custom sort list

• Filtering data quickly with AutoFilter

• Filtering data with a search filter

• Clearing a filter

• Creating an advanced filter

• Filtering Excel tables visually by using slicers

• Clearing and removing slicers

• Validating data for correctness during entry

• Creating a recommended PivotTable

• Analyzing data by using PowerPivot

• Presenting data by using Power View

After you add data to your worksheets, you might want to change the order in which the worksheet rows are displayed. For example, if you have a worksheet listing orders for a week, you might want to list the orders for each customer or perhaps reorder the rows in your worksheet so that the most expensive ...