|
Certification
Maps
|
Excel 2002 - Level II
One Day
Who Should Attend: The target student for this course is a user who has worked with Excel and has experience creating basic worksheets and charts, but wants to learn further how to analyze data.
Overview: Students will learn how to create templates, sort and filter data, import and export data, analyze data, and collaborate on the Web.
- Topics covered include:
- Working with Templates
- Creating a Workbook from an Excel Template
- Creating a Template
- Creating a Graphic
- Creating a Workbook from a User-Defined Template
- Sorting and Filtering Data
- Sorting Data
- Adding Subtotals to a Worksheet
- Filtering Lists
- Creating and Apply Custom Filters
- Importing and Exporting Data
- Importing Data from the Web
- Importing Data from an External Source
- Exporting Data
- Saving a Worksheet as a Web Page
- Publishing a Worksheet to the Web
- Working with Advanced Formulas
- Sharing Data Among Worksheets
- Creating a Name for a Range of Cells
- Using Functions to Create Advanced Formulas
- Tracing Cell Precedents
- Tracing Cell Dependents
- Locating Errors in Formulas
- Analyzing Data
- Creating a PivotTable Report
- Creating a PivotChart Report
- Creating Scenarios
- Use Solver
- Use Goal Seek
- Collaborating
- Inserting and Editing a Hyperlink
- Adding and Editing Comments in a Worksheet
- Creating Discussion Comments
- Responding to Discussion Comments
Prerequisites: The student should have an understanding of the Windows environment and topics covered in Microsoft Excel 2002 - Level I.
What's Next: Students who want to learn about some of the more advanced features of the program like macros, charts and multiple data sources can take Excel 2002 - Level III.
©2004 Computer Training Center For more information contact ctc@comtrain.com.