Microsoft® Office Excel 2007 - New Features

This course is designed for existing users of Microsoft® Office Excel 2003 (or earlier), and who need to become familiar with the upgraded and additional features of the latest release of the software for improving the management, presentation, and distribution of spreadsheets.

Course highlights include complete coverage of the new interface, improvements to PivotTables, and a discussion on how to publish a workbook as a PDF.

DURATION

• 1 Day(s) - Instructor Led Training
• 10 Hours - Online Instruction

LOCATION(s)

• Denver, CO (DEN)
• Colorado Springs, CO (COS)
• Virtual Online Training
• Your Location

EXAM(s)

This course will prepare participants for the following exam(s):

• 77-602 - MCAS: Using Microsoft Office Excel 2007

AUDIENCE

This course is designed for the intermediate to advanced Excel user. Participants will be familiarized with the new features in Microsoft® Excel. Those who wish to prepare for certification as a Microsoft Certified Application Specialist in Excel also require this course.

COURSE OBJECTIVES

At the completion of this course, students will be able to:

• Navigate the new tab and ribbon interface
• Create files using templates
• Create formulas
• Customize and finish workbooks
• Create Charts and Pivot Tables from Excel data
• Use Excel with other programs

SKILLS TAUGHT

• Lesson 1: Getting Started
• Lesson 2: The New Interface
• Lesson 3: Basic Spreadsheet Tasks
• Lesson 4: Charts and PivotTables
• Lesson 5: Advanced Topics

TRACK(s)

• Microsoft Certified Application Specialist: Excel 2007
• Microsoft Office Specialist
• Microsoft Office 2007 Master

PREREQUISITE(s)

Before attending this course, students must have completed (or equivalent knowledge for):

• Knowledge of and experience in the use of the Microsoft® Windows operating system
• Microsoft® Office Excel 2003 - Levels 1-2
• Microsoft® Office Word 2003 - Level 1

RELATED COURSE(s)

The following course offerings compliment this course:

• Microsoft® Office Access
• Microsoft® Office Business Contact Manager
• Microsoft® Office InfoPath
• Microsoft® Office OneNote
• Microsoft® Office Outlook
• Microsoft® Office PowerPoint
• Microsoft® Office Project
• Microsoft® Office Publisher
• Microsoft® Office SharePoint Designer
• Microsoft® Office SharePoint Services
• Microsoft® Office Visio
• Microsoft® Office Word

What’s Next?

The following courses would be suggested to continue on this Learning Path:

• Microsoft® Excel 2007 - Levels 2-4
• Microsoft® Access 2007 - Levels 1-4
• SharePoint Services 3.0 - Level 1-2
• Visual Basic for Applications (Excel or Access)
• SQL Server 2005 Express
• Crystal Reports - Level 1-3