Excel 2003: Intermediate

Learning Outcomes:

• Given the information provided in the Lesson Lab, successfully create an inventory list from an online template.

• Utilizing a set of instructions provided, accurately create and format a bar chart.

• Using a set of criteria, use functions such as Date & Time, Lookup & Reference, and Statistical to correctly calculate quarterly grades and cumulative totals.

• Utilizing a specific scenario, effectively use the sorting and filtering function to sort and filter a data set during the time allotted.

This course is designed for persons preparing for certification as an MOS in Excel. Create templates, sort and filter data, import and export data, analyze data, and work with Excel on the Web.

· Creating and ApplyingTemplates
· Creating and Modyfying Charts
· Sorting and Filtering Data
· Create and Apply Custom Filters
· Importing and Exporting Data
· Working with Advanced Formulas
· Working with Graphic Objects
· Using Excel with the Web

Excel 2003: Intermediate

Upon successful completion of this course, students will be able to: Work with Graphic objects. Use Excel and user-defined templates to create templates and workbooks. You will use a variety of techniques to sort and filter data. Reuse and share data by importing and exporting from external sources. Publish a worksheet to the Web. Use Calculations such as Date and Time Functions, Financial Functions, Statistical Functions, Lookup and Reference Functions and Logical Functions. Use Web features and comments to collaborate with others.

Course targeted to:

Students with basic knowledge of Excel and who has experience creating worksheets and charts but need the additional benefits this class provides.

Prerequisites:

Windows: Introduction and Excel 2003: Introduction.