Advanced Customization in Excel 2007


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/Description
Numerous features and tools in Excel 2007 enable you to customize the look and feel of spreadsheets and workbooks, and also the functionality and efficiency of the program itself. Existing templates, themes, and styles can be altered to meet business needs, or you can create custom templates, themes, and styles to further enhance data presentation. Using macros, you can automate common or repetitive tasks, resulting in time savings and increased efficiency in day-to-day tasks. This course covers creating templates in Excel 2007, as well as customizing workbook properties, themes, and styles. Working with macros, including recording, editing, and running, is also explored.

Target Audience
End users seeking proficiency in the use of Microsoft Excel 2007 at an advanced level or seeking to obtain Microsoft Office Specialist (MOS) certification in Microsoft Excel 2007 at Expert level or an equivalent.

Prerequisites
Some knowledge of basic word processing, computing, and spreadsheets; familiarity with the Microsoft Office work environment; an understanding of the Internet and web-page functionality

Expected Duration (hours)
1.9

Lesson Objectives

Advanced Customization in Excel 2007

  • create an Excel template
  • create new cell styles in Excel 2007
  • customize Excel 2007 themes
  • customize workbook settings
  • change the workbook properties
  • customize Excel 2007 workbooks
  • record and run a macro
  • match macro security settings with their effects
  • edit and delete macros
  • assign a button to a macro and add it to the Quick Access Toolbar
  • to create a macro and add it to the Quick Access Toolbar
  • Course Number:
    mo_adex_a03_dt_enus

    Expertise Level
    Intermediate