1. Managing the Worksheet Environment
- Navigate through a worksheet
- Print a worksheet or workbook
- Personalize environment by using Backstage
2. Creating Cell Data
- Construct cell data
- Apply AutoFill
- Apply and manipulate hyperlinks
3. Formatting Cells and Worksheets
- Apply and modify cell formats
- Merge or split cells
- Create row and column titles
- Hide and unhide rows and columns
- Manipulate page setup options for worksheets
- Create and apply cell styles
4. Managing Worksheets and Workbooks
- Create and format worksheets
- Manipulate window views
- Manipulate workbook views
5. Applying Formulas and Functions
- Create formulas
- Enforce precedence
- Apply cell references in formulas
- Apply conditional logic in a formula
- Apply named ranges in formulas
- Apply cell ranges in formulas
- Audit formulas.
- Manipulate formula options
- Perform data summary tasks.
- Apply functions in formulas
|
6. Presenting Data Visually
- Create charts based on worksheet data
- Apply and manipulate illustrations
- Create and modify images by using the Image Editor
- Apply Sparklines
- Apply advanced chart features
- Apply data analysis
- Apply and manipulate PivotTables
- Apply and manipulate PivotCharts
7. Sharing Worksheet Data with Other Users
- Share spreadsheets by using Backstage
- Manage comments
8. Analyzing and Organizing Data
- Filter data
- Sort data
- Apply conditional formatting
9. Sharing and Maintaining Workbooks
- Apply workbook settings, properties, and data options
- Apply protection and sharing properties to workbooks and worksheets
- Maintain shared workbooks
10. Working with Macros and Forms
- Create and manipulate macros
- Insert and manipulate form controls
|