Manipulating and Formatting Data and Worksheets in Excel 2007

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

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
210 minutes

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.


Manipulating 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

Formatting in Excel 2007

  • 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





Multi-license discounts available for Annual and Monthly subscriptions.