|
Advanced Customization in Excel 2007
(Duration: 1:54:00)
Price: $36.00
Course Code:
mo_adex_a03_dt_enus
Course Catalog(s):
Course Provider:
SkillSoft
12 months
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.
Sections:
- • Creating Templates in Excel 2007
- - create an Excel template
- • Customizing Themes and Styles in Excel 2007
- - create new cell styles in Excel 2007
- - customize Excel 2007 themes
- • Customizing Workbook Settings in Excel 2007
- - customize workbook settings
- - change the workbook properties
- • Customizing Excel 2007 Workbooks
- • Record and Run an Excel 2007 Macro
- - record and run a macro
- - match macro security settings with their effects
- • Work with Excel Macros
- - edit and delete macros
- - assign a button to a macro and add it to the Quick Access Toolbar
- • Recording a Macro in Excel 2007
|