Houston | The Woodlands
(832) 693-9785
Excel Training Houston on Facebook Houston Excel Training on LinkedIn Excel Training Houston on Twitter Houston VBA Training on Google+ Excel VBA Houston Email

  • Microsoft Excel 2010: Level 1 - Beginner

  • Course length:

    1.0 day

    Course Objective:

    You will create and edit basic Microsoft Office Excel worksheets and workbooks.

    Target Student:

    This course is designed for students who desire to gain the necessary skills to create, edit, format, and print basic Microsoft Office Excel worksheets.

    Certification:

    This course is one of a series of courseware titles that addresses Microsoft Office Specialist (MOS) certification skill sets. The MOS and certification program is for individuals who use Microsoft's business desktop software and who seek recognition for their expertise with specific Microsoft Excel features.

    Course Objectives:

    Upon successful completion of this course, students will be able to:
    • create a basic worksheet by using Microsoft Excel.
    • perform calculations in an Excel worksheet.
    • modify an Excel worksheet.
    • modify the appearance of data within a worksheet.
    • manage Excel workbooks.
    • print the content of an Excel worksheet.

  • Course Content

    Lesson 1: Getting Started with Excel

    1. Identify the Elements of the Excel Interface
    2. Navigate and Select Cells in Worksheets
    3. Customize the Excel Interface
    4. Create a Basic Worksheet

    Lesson 2: Performing Calculations in an Excel Worksheet

    1. Create Formulas in a Worksheet
    2. Insert Functions in a Worksheet
    3. Reuse Formulas

    Lesson 3: Modifying a Worksheet

    1. Edit Worksheet Data
    2. Find and Replace Data
    3. Manipulate Worksheet Elements

    Lesson 4: Modifying the Appearance of a Worksheet

    1. Apply Font Properties
    2. Add Borders and Colors to Cells
    3. Align Content in a Cell
    4. Apply Number Formatting
    5. Apply Cell Styles

    Lesson 5: Managing an Excel Workbook

    1. Manage Worksheets
    2. View Worksheets and Workbooks

    Lesson 6: Printing Excel Workbooks

    1. Define the Page Layout
    2. Print a Workbook

    Appendix A: Microsoft Office Excel Exam 77–88210