Organizing Data and Objects in Excel 2010


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



Overview/Description
Excel 2010 provides multiple features for organizing and managing data, including sorting and filtering tools that are integral to data analysis. Using data organization features, you can sort, filter, and group and outline data so that you can focus on its key parts. Properly arranged data using the commands in the Arrange group allows you to present your data in a logical and easy to understand manner. This course explores organizing data in Excel 2010 using the built-in features. It also covers arranging objects for better viewing as well as the use of hyperlinks to organize data.

Target Audience
End users seeking proficiency in the use of Microsoft Excel 2010 at an advanced level

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

Lesson Objectives

Organizing Data and Objects in Excel 2010

  • sort data in more than one column or row
  • create a custom filter
  • outline data using the Subtotal, Auto Outline, or Group commands
  • arrange objects on a worksheet page
  • recognize how you can arrange data to fit a specified page layout for printing
  • create a hyperlink
  • modify hyperlinks
  • sort and filter data
  • create an outline so you can group and summarize data
  • arrange objects on a page
  • create a hyperlink from a worksheet to a web page
  • Course Number:
    mo_aexl_a03_dt_enus

    Expertise Level
    Intermediate