Lessons Learned
Now that we are at the end of the workshop, participants should be able to:
- Use SmartArt, pictures, clip art, text boxes and shapes on worksheets
- Audit formulas to see the precedents, dependents, formulas, and comments
- Create, edit, and move charts
- Use PivotTables and Pivot Charts
- Record and run macros
- Understand macro security levels
- Use named ranges to create a greater understanding in formulas and help prevent errors
- Trace errors
- Use error checking
- Evaluate formulas
- Use goal seek
- Create scenarios
- Create data tables
- Transpose data from rows to columns
- Use the Text to Columns feature
- Check data for duplicates
- Create data validation rules
- Consolidate data
- Use groups, subtotaling, and outlines