Manipulating and Formatting Data and Worksheets in Excel 2007

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