| Apply data protection to a worksheet or entire workbook | |
| Import data from other types of files including .txt, .csv, .accdb | |
| Work with Connected Data | |
| Export data to other formats | |
| Link data between worksheets and workbooks | |
| Create an Automatic Outline | |
| Create a Manual Group | |
| Create a Subtotalled Worksheet | |
| Create, display and merge Scenarios | |
| Define a PivotTable structure | |
| Use PivotTable Grand Totals | |
| Create Calculated fields in a PivotTable | |
| Use Advanced Filters | |
| Use Data Validation techniques | |
| Create a worksheet with Controls | |
| Share workbooks and use Track Changes | |
| Record, view and edit a Macro | |
