Microsoft Courses:
Microsoft Office Excel 2007 Level 2 Training Course

You can already create, edit, format, and print basic spreadsheets as covered on the Level 1 course. In this course, you will use Microsoft Office Excel 2007 to streamline and enhance your spreadsheets with templates, charts, graphics, and formulas. This course is designed for students who wish to gain the skills necessary to create templates, sort and filter data, import and export data, analyze data, and work with Excel on the web. In addition, this course helps prepare students who desire to take the Microsoft Office Specialist exam in Excel and who already have knowledge of the basics of Excel, including how to create, edit, format, and print basic worksheets.

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

• 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.

Before starting this course,it is recommended that students have attended the Microsoft Office Excel 2007 Level 1 course or have equivalent knowledge.

This course is rated as an Intermediate Course, suitable for accomplished computer users.

Topics covered on the 1 day Microsoft Office Excel 2007 Level 2 course

Enhancing Workbooks

• Customize the Excel Environment
• Customize an Excel Worksheet
• Enhance Worksheets Using Themes
• Work with Comments
• Access External Resources Using Hyperlinks
• Use Web-Based Research Tools

Creating Workbooks Using Templates

• Create a Workbook from a Template
• Create a Custom Template

Organizing Data Using Tables

• Create Tables
• Modify Tables
• Format Tables

Presenting Data Using Charts

• Create a Chart
• Modify Charts
• Format Charts
• Create a Chart Template
• Share Excel Charts

Analyzing Data Using PivotTables and PivotCharts

• Create a PivotTable
• Perform Calculations Using PivotTables
• Analyze Data Using PivotCharts

Enhancing Visual Appeal Using Graphic Objects

• Insert Graphics
• Modify Graphic Objects
• Emphasize an Area of a Worksheet
• Illustrate Workflow Using SmartArt Graphics
• Format Graphic Objects
• Change the Order of Layered Graphic Objects
• Group Graphic Objects
• Organize Graphic Objects

Calculating Data with Advanced Formulas

• Refer to a Range of Cells
• Calculate Data Across Worksheets
• Perform Date and Time Calculations
• Format Text Using Formulas
• Perform Numeric Calculations
• Calculate Data with Lookup & Reference Functions
• Perform Logical Analysis
• Print Formulas

Sorting and Filtering Data

• Sort Data in a Spreadsheet
• Filter Data in a Spreadsheet
• Calculate Large Volumes of Data
• Add Subtotals to a Worksheet

Appendix A: Microsoft Office Specialist: Excel 2007

   (excl.VAT)

PTR Associates Limited

21A Peach Street, Wokingham, Berkshire, RG40 1XJ, United Kingdom
Tel: 0118 979 4000 Fax: 0118 979 4035
Email: training@ptr.co.uk