| Apply 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 |
|
| Linking data between worksheets and workbooks |
|
| Create an Automatic Outline |
|
| Create a Manual Group |
|
| Use a Subtotalled Worksheet |
|
| Consolidate data with Identical and Different Layouts |
|
| Use a simple What-If model |
|
| 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 |
|
