Workbook settings, conditional formatting, and number formats

Overview

You can customize the look and feel of workbooks and program functionality and efficiency using the many features and tools in Excel 2010. You can modify existing themes and styles to suit your business needs, or you can create custom themes and styles to further enhance your presentation. data. Custom number formats allow you to have 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 most advanced ways you can improve your workbooks and data using the powerful customization features of Excel 2010. Prerequisites Knowledge of basic word processing, calculations, and spreadsheets; familiarization with the Microsoft Office work environment; Understanding the functionality of the Internet and web pages.

Target Audience

End users who want to gain dexterity in using Microsoft Excel 2010 at an advanced level.

Objectives

• Applying custom formatting
• customize workbook settings using Excel Options
• change the properties of the workbook
• create a custom number format
• recognize how you can modify 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 Quick Access Toolbar Quick Access tools)
• create and apply a custom number format
• create a new conditional formatting rule