Students will learn the skills and concepts necessary to begin using the charting and list-management capabilities of Excel 97. Students should have a basic knowledge of the concepts involved in using Excel 97 for Windows 95 worksheets. For example, they should be familiar with data types (text, numbers, and formulas) and the use of the menu system for copying data and for opening and saving files.
Create charts that graphically represent worksheet data.
- Modify charts.
- Customize charts by applying formatting.
- Enhance worksheets and charts by using the drawing tools to add graphic objects.
- Sort information in a list by using the Data, Sort command.
- Locate and manage information in a list that meets specified conditions by using the Advance filter feature.