Contents

Getting Started With AutoFilter. 7

Adding Subtotals to Only the Visible Data. 10

Working With Multiple Filters. 13

Other Cool AutoFilter Options. 15

Getting Started With Tables. 18

Adding a Total Row.. 20

Other Total Functions. 21

Adding a Column. 22

Format Styles. 23

Remove Duplicates. 24

Pivot Tables. 25

Review Questions. 29

Glossary. 30

INDEX. 31

Answers to Review Questions. 32

CPE Exam.. 35