Course 5427: Formatting and Printing Worksheets in Microsoft Office Excel 2007

Introduction This online course covers the skills and knowledge you will need to format worksheets in Microsoft® Office Excel® 2007, as well as printing worksheets. This includes defining styles, applying themes to a workbook, and making workbooks easier to read. It also covers how to change the appearance of data based on its value, as well as adding graphics to an Excel document. In addition this course covers the printing of Excel workbooks. Objectives At the end of the course, students will be able to:

• Change cell appearance.
• Enhance the readability of a workbook.
• Print worksheets.
• 
  
  The lab you are attempting to launch is currently unavailable. Click here for more detail.

Modules & Lessons Course Overview Module Introduction Navigation Overview Lab Information Course Information Formatting and Printing Worksheets in Excel 2007 Module Introduction Changing Workbook Appearance Lesson Introduction Format a Cell Lab: Creating and Applying Styles to Cells Workbook Themes and Styles Create and Apply a Table Style Lab: Applying Themes and Styles Self Test Enhancing the Readability of a Workbook Lesson Introduction Format Numeric Data Conditional Formatting Lab: Creating and Applying Conditional Formats Add Images to a Worksheet Self Test Printing Worksheets Lesson Introduction Headers and Footers Lab: Creating a Custom Header for a Workbook Set the Workbook Properties Lab: Printing a Worksheet Self Test Module Summary Glossary Module Introduction System Requirements To view this course, you need:

• A Pentium II, 256 MB RAM with a processor speed greater than or equal to 400 MHZ
• Microsoft® Windows® 2000 or higher
• Microsoft Internet Explorer 6.0 or higher
• Adobe Flash 7.0 or higher (1MB disk space needed to install)
• Microsoft Silverlight 4.0 or higher
• Microsoft Windows Media Player 7.0 or higher
• Microsoft XML Core Services 3.0 or higher
• A Super VGA monitor with minimum screen resolution 1024x768, with 16-bit color.
• A sound card, and either speakers or headphones (for multi-media audio).
• Internet bandwidth of 56K or faster. Broadband internet access is recommended.

For courses containing Virtual Server-based labs (courses in the IT Professional and Developer Catalog), you will need:

• Microsoft Virtual Server ActiveX control (1MB disk space needed to install)

Test your computer's capabilities to see if it supports this course. Accessibility Requirements The following software must be running on your computer in order to access this course with Screen Reader Software:

• Microsoft Internet Explorer 6.0 or higher
• Window-Eyes from GW Micro
• JAWS from Freedom Scientific
• MSAA enabled