RegisterSign In

Excel 2007 Level 2

Distance-Education.org

Description

This course familiarizes students with intermediate-level spreadsheet features.

Students will learn how to:

  • Convert older workbooks to the new default XML-based file format
  • Customize the Quick Access toolbar
  • Use logical and financial functions
  • ormat worksheets using themes, styles, and page breaks
  • Use 3-D references; ready workbooks for the Web; use templates to create workbooks
  • Insert and manipulate objects such as shapes and SmartArt diagrams into a spreadsheet.

    They will also learn how to customize workbooks by renaming worksheets; inserting, deleting, and hiding worksheets; and changing the color of worksheet tabs. In addition, the course points out how tables in Excel serve as databases and covers how to convert data ranges into tables, apply table styles, freeze and unfreeze rows and columns, sort tables, and use filters in tables. This product was developed using the Release Candidate 1 from Microsoft.


    Outcomes

    This course teaches students how to:

    • Convert older workbooks to the new default XML-based file format
    • Customize the Quick Access toolbar
    • Use logical and financial functions
    • Format worksheets using themes, styles, and page breaks
    • Use 3-D references
    • Ready workbooks for the Web
    • Use templates to create workbooks
    • Insert and manipulate objects such as shapes and SmartArt diagrams into a spreadsheet


    Assessment

    Student performance is assessed by cumulative training time, number of lessons completed and, where tests are available, the percent correct. Many courses also have a pre- and post-test where the pre-test will automatically assign only the lessons needed to achieve course mastery.

  • course quick facts
    course code DED2220
    cost $79.00
    estimated time to
    complete course
    6 Hours
    course materials
    available
    90 Days
    instructor

    Patrick Grady is an award-winning online course developer, and has a varied background, which includes technical writing, instructional design, education, and corporate training. Patrick implements his own diverse knowledge and unique set of skills to creating informative, engaging online courses with a strong focus on positive educational outcomes. He has taught online courses in a number of areas, including: Microsoft Excel 2007.