Microsoft Excel 2010 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 2010 Training course
• Six months of post-class email support from a Microsoft Excel Instructor

Course Description:

In this Microsoft Excel 2010 Introduction Training course students will learn how to create and manage workbooks using Excel 2010. Students will also learn the basics of formatting worksheets and working with formulas.

Course Objectives:

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

• Explore the Microsoft Office Excel 2010 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, or simply wish to gain the skills necessary to create, edit, format, and print basic Microsoft Office Excel 2010 worksheets.

Course Prerequisites:

General understanding of the Windows desktop environment

Course Syllabus:

1. Getting Started with Excel
• Identify the Elements of the Excel Interface
• Navigate and Select Cells in Worksheets
• Customize the Excel Interface
• Create a Basic Worksheet
2. Performing Calculations in an Excel Worksheet
• Create Formulas in a Worksheet
• Insert Functions in a Worksheet
• Reuse Formulas
3. Modifying a Worksheet
• Edit Worksheet Data
• Find and Replace Data
• Manipulate Worksheet Elements
4. Modifying the Appearance of a Worksheet
• Apply Font Properties
• Add Borders and Colors to Cells
• Align Content in a Cell
• Apply Number Formatting
• Apply Cell Styles
5. Managing an Excel Workbook
• Manage Worksheets
• View Worksheets and Workbooks
6. Printing Excel Workbooks
• Define the Page Layout
• Print a Workbook