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 |
|