 | Use Excel worksheets as databases |
| Perform basic and advanced sorting |
| Use database functions such as
DAVERAGE, DCOUNT, DSUM, DMIN and DMAX |
| Work with the VLOOKUP function |
| Use AutoFilter and Advanced
Filters |
| Extract data matching criteria |
| Query an external database |
| Generate automatic subtotals |
| Use conditional formatting and
AutoFormat |
| Create, modify, and format
PivotTables |
| Refresh and sort PivotTable data |
| Analyze data with the Auditing
toolbar |
| Use Goal Seek and Solver features |
| Work with scenarios |
| Create custom views, custom
reports, and PivotChart reports |
