Course Details

Previous Page


Workbook Settings, Conditional Formatting, and Number Formats in Excel 2010


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



Overview/Description
You can customize the look and feel of workbooks and the program's functionality and efficiency using Excel 2010's numerous features and tools. You can modify existing themes and styles to meet business needs, or you can create custom themes and styles to further enhance data presentation. Custom number formats allow you even more control over the presentation and usefulness of your workbooks and conditional formatting gives you the power to apply individual formatting based on custom rules that meet your specific needs. This course explores some of the more advanced ways that you can enhance your workbooks and data using Excel 2010's powerful customization features.

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

Workbook Settings, Conditional Formatting, and Number Formats in Excel 2010

  • customize workbook settings using Excel Options
  • change workbook properties
  • create a custom number format
  • recognize how to alter code strings to create custom number formats
  • create a conditional format based on a new formatting rule
  • manage conditional formatting rules
  • customize workbook settings and the Quick Access Toolbar
  • create and apply a custom number format
  • create a new conditional formatting rule
  • Course Number:
    mo_aexl_a02_dt_enus