| Data manipulation |
| |
Automatic outlining
Group and ungroup
Filtering data
Advanced filtering
Sorting data
Inserting Subtotals
Creating an Advanced Filter
Single input data tables
Double input data tables |
|
| Formulas and functions |
| |
Complex
If statements
Using nested functions
Using named regions
Using lookup functions
Using database functions
The DSUM Function
The DAVERAGE Function
The DCOUNT Function
The DGET Function
The DMIN Function
The DMAX Function |
|
| Tools |
| |
Creating scenarios
Scenario summary reports
Protecting scenarios
Using Goal Seek
Using the Solver
Working with views |
|
| What-if analysis |
| |
Overview of PivotTables
The PivotTable Wizard
Formatting PivotTables
Rearranging PivotTables
Sorting data
Grouping data
Using AutoShow
Overview of PivotCharts
The PivotChart Wizard |
|
| Macros |
| |
Recording a Macro
Running a Macro
Macro buttons |
|
| Collaboration |
| |
Working
with Shared Workbooks
Reviewing Workbooks
Sending Workbooks
Tracking changes
Resolving conflicts
Merging Workbooks
|
|
