Customizing Visual Elements in Excel 2010


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



Overview/Description
Adding visual elements to Excel worksheets can help to enhance what can sometimes be dry facts and figures, making it easier to hold the attention of the intended audience. A balance needs to be struck, however, between enhancing and overwhelming when it comes to adding graphics and colors to your Excel workbooks. Excel 2010 provides you with a number of basic and advanced techniques for customizing common elements such as charts, themes, cell styles, and graphics. This course describes many of these techniques and shows you how to implement them to their best effect.

Target Audience
End users seeking proficiency in the use of Microsoft Excel 2010 at an advanced level

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.0

Lesson Objectives

Customizing Visual Elements in Excel 2010

  • manually adjust a chart's layout and formatting
  • save and apply a chart template
  • manually format illustrations using the Format object dialog box
  • customize and save Excel themes and styles
  • save an Excel template and apply to a new workbook
  • adjust individual chart elements
  • format Excel illustrations
  • create a new cell style
  • create an Excel theme
  • Course Number:
    mo_aexl_a01_dt_enus

    Expertise Level
    Intermediate