Database skills (using a spreadsheet)

Updated 2011.07.27

Basic Database Skills

• Perform single and multi-level sorts
• Apply data filters (AutoFilter, Advanced Filter)
• Use data forms
• Use subtotaling
• Query databases

• Use data validation

Data analysis tools

• Use pivot tables
• Use pivot charts
• Use Goal Seek
• Use database functions:
• Work with Scenarios
• Use Solver
• Use data analysis and PivotTables
• Create interactive PivotTables for the Web

• Add fields to a PivotTable using the Web browser

• Collaborating with workgroups

• Create, edit and remove a comment
• Apply and remove worksheet and workbook protection
• Change workbook properties
• Apply and remove file passwords
• Track changes (highlight, accept, and reject)
• Create a shared workbook

• Merge workbooks