Manipulating and Formatting Data and Worksheets in Excel 2007


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


Overview/Description
Excel 2007 provides a number of improved tools and new features that allow you to visually enhance the appearance of sheets and workbooks. Cells, rows, columns, sheets, and workbooks can be manipulated and customized using various positioning and formatting features. This course explores the processing of copying and moving cells, columns, rows, and sheets, as well as inserting or removing sheets and modifying workbooks. Formatting tables, textual data, and numerical data, as well as conditional formatting, is also covered.

Target Audience
Personnel at all levels of the enterprise; end-users seeking competency in the use of Microsoft Excel 2007.

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)
3.5

Lesson Objectives

Manipulating and Formatting Data and Worksheets in Excel 2007

  • copy or move data in given scenarios
  • add, delete, or resize rows and columns in a given scenario
  • modify rows and columns to view specific sections of the worksheet
  • format workbooks in given scenarios
  • insert and delete a worksheet
  • rename a worksheet and format the tab color
  • copy or move worksheets
  • modify cells and workbooks in a given scenario
  • modify worksheets to view specified data
  • copy and move data and worksheets in a given scenario
  • apply basic data formatting
  • format a data range as a table
  • change the position of data in a cell in a given scenario
  • identify the functions of Alignment commands
  • work with tables in Excel 2007
  • format a data range as a table
  • modify an Excel table
  • apply number formats in a given scenario
  • identify the number formatting options available in Excel 2007
  • apply basic conditional formatting rules in a given scenario
  • recognize situations when conditional formatting is suitable
  • format data and apply conditional formatting in given scenarios
  • move data between workbooks and apply formats in a given scenario

    • Course Number:
    mo_bgex_a02_dt_enus

    Expertise Level
    Beginner