Students will learn more advanced spreadsheet features, as well as charting and database tools.
Excel XP (2002): Level 1 (or equivalent experience)
- Create advanced charts (graphs)
- Enhance charts using drawing tools to add graphic objects
- Work with named ranges in formulas and worksheet navigation
- Sort information in a list
- Display selected records that meet specified conditions using the AutoFilter command
- Maintain a list by using the data form; locate records, add records, delete records
- Use the Subtotals command to automatically group, subtotal and grand total data
- Work with 3D worksheets and formulas
- Create more advanced formulas using functions