Students will create templates, sort and filter data, import and export data, analyze data, and collaborate on the Web.

Target Student:

The target student for this course is a user who has worked with Excel and has experience creating basic worksheets and charts.

Prerequisites:

• Excel 2002: Level 1

Students will gain the skills needed to create and use templates, sort and filter data, import and export data, analyze data, and collaborate on the Web.

Delivery Method:

Instructor-led, group-paced, classroom delivery learning model with structured, hands-on activities.

Course duration:

0.5day(s).

Hardware/Software Requirements:

You will need:

• A Pentium 133 MHz or higher processor required for all operating systems.
• 64 MB of RAM recommended minimum for Windows 2000 Professional; in addition, you should have 8 MB of RAM for each application running simultaneously. (Note: Memory requirements may differ for other operating systems).
• A minimum of 516 MB of free hard disk space. (Under Windows 2000, at least 4 MB of space must be available in the registry.)
• Either a local CD-ROM drive or access to a networked CD-ROM drive.
• A floppy-disk drive.
• A two-button mouse, an IntelliMouse, or compatible pointing device.
• A VGA or higher-resolution monitor; Super VGA recommended.
• An installed printer driver. (Printers are not required; however each PC must have an installed printer driver to use Print Preview.)
• 9600 baud modem or higher. An Internet connection with access to the World Wide Web is necessary to complete some tasks throughout the book. FYI: Internet access may require payment of a separate fee to a service provider; local charges may also apply.
• Access to a discussion server if you want to complete the activities in Topics 6C and 6D.

Upon successful completion of this course, students will be able to:

• Lesson objectives help students become comfortable with the course, and also provide a means to evaluate learning. Upon successful completion of this course, students will be able to:
• You will use Excel and user-defined templates to create templates and workbooks.
• You will use a variety of techniques to sort and filter data.
• You will reuse and share data by importing and exporting.
• You will use various functions and auditing features to create advanced formulas and audit worksheets.
• You will use PivotTables, PivotCharts, and other analysis tools to analyze data.
• You will use Web features and comments to collaborate with others.

Lesson 1: Working with Templates

• Topic 1A: Create a Workbook from an Excel Template
• Topic 1B: Create a Template
• Topic 1C: Create a Graphic
• Topic 1D: Create a Workbook from a User-Defined Template