STREAMLINING WORKFLOW
- Create a Macro
- Edit a Macro
- Apply Conditional Formatting
- Add Data Validation Criteria
- Update a Workbook's Properties
- Modify Excel's Default Settings
COLLABORATING WITH OTHERS
- Protect Files
- Share a Workbook
- Set Revision Tracking
- Review Tracked Revisions
- Merge Workbooks
- Restrict Document Access
AUDITING WORKSHEETS
- Trace Cells
- Troubleshoot Errors in Formulas
- Troubleshoot Invalid Data and Formulas
- Watch and Evaluate Formulas
- Create a Data List Outline
|
ANALYZING DATA
- Create a Trendline
- Create Scenarios
- Perform What-If Analysis
- Perform Statistical Analysis with the Analysis ToolPak
WORKING WITH MULTIPLE WORKBOOKS
- Create a Workspace
- Consolidate Data
- Link Cells in Different Workbooks
- Edit Links
IMPORTING AND EXPORTING DATA
- Export Excel Data
- Import a Delimited Text File
|