Course details

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
Everyone