Contents

Excel’s Data Features. 5

Sorting Data. 6

Sorting -Ascending/Descending. 6

Sorting Chronologically. 7

Customized Sorts. 8

Review Questions. 12

Filtering Data. 13

Review Questions. 17

Create an Outline. 18

Automatic Outline. 18

Remove an Outline. 19

Manual Outline. 19

Review Questions. 21

Nested Subtotals. 24

Copying the Summarized Subtotal Information. 27

Review Questions. 29

Pivot Tables. 30

Rearrange Data in a PivotTable. 35

Add Data to the Report Filter: 35

Refresh your data. 36

Detail Drill Down. 39

Displaying Data. 40

Renaming Fields. 43

Custom Calculations. 46

Review Questions. 51

Database Functions. 52

Review Questions. 57

Conditional Formats. 58

Adding a Condition to Existing Rule. 59

Delete Conditional Formatting. 61

Finding conditional formatted cells. 62

Review Exercise -On Your Own. 63

Review Questions. 64

Review Questions – Solutions/Feedback. 65

Managing Data with Excel CPE Exam... 70