Advanced Customization in Excel 2007

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.

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
120 minutes

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.


Customizing Workbooks 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

Customizing with Macros in Excel 2007

  • 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





Multi-license discounts available for Annual and Monthly subscriptions.