Excel 2002 Intermediate

Course Overview

Students will learn the skills and concepts necessary to work with intermediate features of Excel 2002 in Office XP.

Excel 2002 Introduction, or equivalent knowledge.

Students will learn how to validate data, use advanced formulas, create pivot tables, create charts from spreadsheet data, and sort and filter data.

Students should be familiar with data types (text and values), copying data, basic formulas and functions, and opening and saving files.

Excel 2002 Advanced is the third course in this series.

Further data entry techniques
Create and edit a comment The AutoComplete feature
Customising your workbook
Apply Conditional Formatting Add Data Validation Criteria Customize Menus Customize Toolbars Group and Outline Structured Data
Working with Templates
Create a Workbook from an Excel Template Create a Template Create a Graphic Create a Workbook from a User-Defined Template
Working with Advanced Formulas
Share Data Among Worksheets Create a Name for a Range of Cells Use Functions
Analyzing Data
Create a PivotTable Report Create a PivotChart Report
Creating and Modifying Charts
Create a Chart Modify Chart Items Format a Chart Change the Chart Type
Enhancing Your Worksheet using Charts
Chart Non-adjacent Data Modify chart items Create a Trend Line
Sorting and Filtering Data
Sort Data Add Subtotals to a Worksheet Filter Lists Create and Apply Custom Filters
Collaboration
Insert and Edit a Hyperlink Add and Edit Comments in a Worksheet Create Discussion Comments Respond to Discussion Comments

	Printer Friendly Version
	Download Outline As PDF

The course trainer was excellent. She spent time with individuals, explaining any problems experienced

- Siemens