Formatting Data in Excel 2003


Overview/Description
To demonstrate how to format worksheets in Excel 2003

Target Audience


Personnel at all levels of the enterprise; end-users seeking competency in the use of Microsoft Excel; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at core level in the use of Microsoft Excel 2003; end-users seeking basic IT certification such as ECDL, ICDL, IC3, or an equivalent

Prerequisites


Some knowledge of basic word processing, computing, and spreadsheets; familiarity with the Microsoft Office environment; an understanding of the Internet and web-page functionality, as well as an understanding of the process of web-page creation, would be an advantage

Expected Duration


120 Minutes

Objectives :

Formatting Data in Excel 2003

  • apply and adapt a range of Excel cell formats.
  • use visual design techniques to apply formatting to an Excel 2003 workbook.
  • manipulate rows and columns in an Excel 2003 worksheet.
  • apply various types of formatting to an Excel 2003 workbook.
  • apply number formatting to cells in Excel 2003.
  • apply a number format to cell content in Excel 2003.
  • format text and cells and apply number formats to data in Excel 2003.

  • Course Number: 119827_eng