Objectives: explore a structured range of data, freeze rows and columns, plan and create an excel table, rename and format an excel table, add, edit, and delete records in an excel table, sort data. Objectives: create and modify a pivottable, apply pivottable styles and formatting, filter a pivottable, insert a slicer to filter a pivottable, insert a recommended pivot table, create a pivotchart. Freezing rows and columns: freezing a row or column keeps headings visible as you work with data in a large worksheet. Creating an excel table: saving time with excel tables. Sorting data: sorting using a custom list, a custom list indicates sequence to order data, two predefined custom sort lists. Month-of-the-year custom lists: can create a custom list to sort records in a sequence you define. Filtering data: filtering temporarily hides any records that do not meet specified criteria, after data is filtered, it can be, sorted, copied, formatted, charted, printed.