COURSE NAME: Excel 2007 - Level 1 and Level 2 (4060)

Course length: 2 days

Overview:

Students will create and edit basic Microsoft Office Excel 2007 worksheets and workbooks. Students will learn to streamline repetitive tasks and display spreadsheet data in more visually effective ways. In this course, you will use Microsoft Office Excel 2007 to streamline and enhance your spreadsheets with templates, charts, graphics, and formulas.

Prerequesite Courses:

• Windows XP Professional - Level 1 (4060) or equivalent knowledge

Performance-based Objectives:

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

• explore the Excel 2007 environment.
• work with an Excel worksheet by entering and selecting the data in it. You will also save the data in the worksheet.
• modify a worksheet.
• perform calculations.
• format a worksheet.
• develop a workbook.
• print workbook contents.
• customize the layout of the Excel application window.
• enhance the workbook.
• automate workbook creation by using templates.
• organize data using tables. create and modify charts.
• analyze data using PivotTables and PivotCharts.
• work with graphic objects.
• calculate with advanced formulas.
• sort and filter data.

Course content:

Day 1:

Unit 1: Exploring the Excel Environment
Unit 2: Working with an Excel Worksheet
Unit 3: Modifying a Worksheet
Unit 4: Performing Calculations
Unit 5: Formatting a Worksheet
Unit 6: Developing a Workbook
Unit 7: Printing Workbook Contents
Unit 8: Customizing Layout

Day 2:

Unit 1: Enhancing Workbooks
Unit 2: Creating Workbooks Using Templates
Unit 3: Organizing Data Using Tables
Unit 4: Presenting Data Using Charts
Unit 5: Analyzing Data Using PivotTables and PivotCharts
Unit 6: Enhancing Visual Appeal Using Graphic Objects
Unit 7: Calculating Data with Advanced Formulas
Unit 8: Sorting and Filtering Data