X

Excel 2007 - Level 1

Course Overview

In this course, students create and edit basic Microsoft® Office Excel® 2007 worksheets and workbooks. (Second Edition)

Who Should Attend

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

    Next Steps and Related Courses

    Course Outline

    1 - Creating a Basic Worksheet

    • Explore the User Interface and the Ribbon
    • Navigate and Select in Excel
    • Obtain Help
    • Enter Data and Save a Workbook
    • Customize the Quick Access Toolbar

    2 - Performing Calculations

    • Create Basic Formulas
    • Calculate with Functions
    • Copy Formulas and Functions

    3 - Modifying a Worksheet

    • Manipulate Data
    • Insert and Delete Cells, Columns, and Rows
    • Search for Data in a Worksheet
    • Spell Check a Worksheet

    4 - Formatting a Worksheet

    • Modify Fonts
    • Add Borders and Color to Cells
    • Change Column Width and Row Height
    • Apply Number Formats
    • Position Cell Contents
    • Apply Cell Styles

    5 - Printing Workbook Contents

    • Print Workbook Contents Using Default Print Options
    • Set Print Options
    • Set Page Breaks

    6 - Managing Large Workbooks

    • Format Worksheet Tabs
    • Manage Worksheets in a Workbook
    • Manage the View of Large Worksheets

  • Enroll Today

    This is a 1-day class

    Price: $295.00
    Payment Options

    ILT Instructor‑Led Training

    OLL Online LIVE

    GTR  Guaranteed to Run

    Class times are listed Eastern time. This class is available for Private Group Training

    To sort by location or date, click the ‘When’ and ‘Where’ column headings.

    Class dates not listed.
    Please contact us for available
    dates and times.