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