CALCULATE DATA WITH ADVANCED FORMULAS
- Manage Cell and Range Names
- Calculate Data Across Worksheets
- Use Specialized Functions
- Analyze Data with Logical and Lookup Functions
ORGANIZING WORKSHEET AND TABLE DATA
- Create and Modify Tables
- Format Tables
- Sort or Filter Worksheet or Table Data
- Calculate Data in a Table or Worksheet
PRESENTING DATA USING CHARTS
- Create a Chart
- Modify Charts
- Format Charts
ANALYZING DATA USING PIVOTTABLES AND PIVOTCHARTS
- Create a PivotTable Report
- Analyze Data Using PivotCharts
|
ANALYZING DATA USING PIVOTTABLES AND PIVOTCHARTS
- Create a PivotTable Report
- Analyze Data Using PivotCharts
INSERTING GRAPHIC OBJECTS
- Insert and Modify Pictures and ClipArt
- Draw and Modify Shapes
- Illustrate Workflow Using SmartArt Graphics
- Layer and Group Graphic Objects
CUSTOMIZING AND ENHANCING WORKBOOKS AND THE EXCEL ENVIRONMENT
- Customize the Excel Environment
- Customize Workbooks
- Manage Themes
- Create and Use Templates
|