How To Take This Class

Course Overview

In this Microsoft Excel 2010 Introduction Training course, students will be introduced to spreadsheet terminology and Excel's window components, students will learn how to use the Help system and navigate worksheets and workbooks. Then they will enter and edit text, values, formulas, and pictures, and they will save workbooks in various formats. Students will also move and copy data, learn about absolute and relative references, and work with ranges, rows, and columns. This course also covers simple functions, basic formatting techniques, and printing. Finally, students will create and modify charts, and learn how to manage large workbooks.

This course will also help students prepare for the Microsoft Office Specialist core-level exam for Excel 2010 (exam 77-882) and the Microsoft Office Specialist Expert exam for Excel 2010 (exam 77-888). For comprehensive certification training, students should complete the Introduction, Intermediate, and Advanced courses for Excel 2010.

Course Prerequisites

General understanding of the Windows desktop environment

Course Audience

This course is designed for people preparing for certification as a Microsoft Certified Application Specialist in Excel, or who simply wish to gain the skills necessary to create, edit, format, and print basic Microsoft Office Excel 2010 worksheets.

What You'll Learn

Upon successful completion of this course, students will be able to:
    • Start Microsoft Excel and identify the components of the Excel interface; open an Excel workbook; use the Help window; and navigate worksheets.
    • Enter and edit text, values, and formulas; examine the order of operations; insert pictures; use AutoFill; save and update a workbook; and save a workbook as a PDF file.
    • Move and copy data and formulas; use the Office Clipboard; use Paste Link; work with relative and absolute references; and insert and delete ranges, rows, and columns.
    • Use the SUM function, AutoSum, and the AVERAGE, MIN, MAX, COUNT, and COUNTA functions to perform calculations in a worksheet.
    • Format cells, rows, and columns; merge cells; apply color and borders; format numbers; create conditional formats; copy formatting; apply table styles; sort data; and use Find and Replace to update the formatting for specific content.
    • Check spelling; find and replace text and data; preview and print a worksheet; set page orientation and margins; create and format headers and footers; and print gridlines.
    • Create, format, modify, and print charts based on worksheet data; work with various chart elements; and apply chart types and chart styles.
    • Freeze panes and split a worksheet; open and arrange a new window with the current worksheet content; hide and unhide data; set print titles and page breaks to optimize print output; insert different even and odd headers; and manage multiple worksheets.
    • Represent data graphically within cells by applying three forms of conditional formatting (data bars, color scales, and icon sets); insert and modify SmartArt graphics; and insert and modify screenshots.

Course Duration

1 Day

Course Outline

  1. Getting started
    • Spreadsheet terminology
    • The Excel environment
    • Getting help
    • Navigating a worksheet
  2. Entering and editing data
    • Entering and editing text and values
    • Entering and editing formulas
    • Working with pictures
    • Saving and updating workbooks
  3. Modifying a worksheet
    • Moving and copying data
    • Moving and copying formulas
    • Absolute and relative references
    • Inserting and deleting ranges, rows, and columns
  4. Using functions
    • Entering functions
    • AutoSum
    • Other common functions
  5. Formatting
    • Text formatting
    • Row and column formatting
    • Number formatting
    • Conditional formatting
    • Additional formatting options
  6. Printing
    • Preparing to print
    • Page Setup options
    • Printing worksheets
  7. Charts
    • Chart basics
    • Formatting charts
  8. Managing large workbooks
    • Viewing large worksheets
    • Printing large worksheets
    • Working with multiple worksheets
  9. Graphics and screenshots
    • Conditional formatting with graphics
    • SmartArt graphics
    • Screenshots

What Students Receive

Each student will receive:
  • A printed courseware manual for use during and after class.
  • Access to an online 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