Microsoft Excel 2007 Introduction Training

How To Take This Class:

• Live Instructor-Led Online Class   > View Schedule or Register
• Onsite Group Training   > Request Pricing

Instructor-Led Online Course Tuition:

$225.00

Course Duration:

1 Day

What Students Receive:

Each student will receive:

• A printed courseware manual for use during and after class.
• Access to a searchable, electronic version of the courseware manual for reference after class (available for 12 months after class.)
• A PC headset for communicating with your instructor and fellow students during your Microsoft Excel 2007 Training Class
• A course completion certificate upon successful completion of your Microsoft Excel 2007 Training course
• Six months of post-class email support from a Microsoft Excel Instructor

Course Description:

You have basic computer skills such as using a mouse, navigating through windows, and surfing the Internet. You have also used paper-based systems to store data that you run calculations on. In this Microsoft Excel 2007 Introduction Training course you will learn how to migrate that data to an electronic format.

Course Objectives:

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

• Explore the Microsoft® Office Excel® 2007 environment and create a basic worksheet.
• Perform calculations.
• Modify a worksheet.
• Format a worksheet.
• Print workbook contents.
• Manage large workbooks.

Course Audience:

This course is designed for people preparing for certification as a Microsoft Certified Application Specialist in Excel, who already have knowledge of Microsoft® Office, Windows® 2000 (or above), and who desire to gain the skills necessary to create, edit, format, and print basic Microsoft Office Excel 2007 worksheets.

Course Prerequisites:

General understanding of the Windows desktop environment

Course Syllabus:

1. Lesson 1: Creating a Basic Worksheet
• Topic 1A: Explore the User Interface and the Ribbon
• Topic 1B: Navigate and Select in Excel
• Topic 1C: Obtain Help
• Topic 1D: Enter Data and Save a Workbook
• Topic 1E: Customize the Quick Access Toolbar
2. Lesson 2: Performing Calculations
• Topic 2A: Create Basic Formulas
• Topic 2B: Calculate with Functions
• Topic 2C: Copy Formulas and Functions
3. Lesson 3: Modifying a Worksheet
• Topic 3A: Manipulate Data
• Topic 3B: Insert and Delete Cells, Columns, and Rows
• Topic 3C: Search for Data in a Worksheet
• Topic 3D: Spell Check a Worksheet
4. Lesson 4: Formatting a Worksheet
• Topic 4A: Modify Fonts
• Topic 4B: Add Borders and Color to Cells
• Topic 4C: Change Column Width and Row Height
• Topic 4D: Apply Number Formats
• Topic 4E: Position Cell Contents
• Topic 4F: Apply Cell Styles
5. Lesson 5: Printing Workbook Contents
• Topic 5A: Print Workbook Contents Using Default Print Options
• Topic 5B: Set Print Options
• Topic 5C: Set Page Breaks
6. Lesson 6: Managing Large Workbooks
• Topic 6A: Format Worksheet Tabs
• Topic 6B: Manage Worksheets in a Workbook
• Topic 6C: Manage the View of Large Worksheets