Title: Learning Objectives
Course: Introduction to Spreadsheets (TEMPLATE) > Section: Competency Modules

Upon completion of this competency, the students should be able to:

- 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
- Filter data
- Insert a Total row to summarize an Excel table
- Split a worksheet into two panes
- Insert subtotals into a range of data
- Use the Outline buttons to show or hide details
- Create and modify a PivotTable
- Apply PivotTable styles and formatting
- Filter and sort a PivotTable
- Insert a slicer to ﬁlter a PivotTable
- Group PivotTable items
- Create a PivotChart