Organizing data and objects in Excel 2010

Overview

Excel 2010 Provides multiple features for organizing and managing data, including sorting and filtering tools that are an integral part of data analysis. Using data organization features, you can sort, filter, and group data, and highlight data so you can focus on key parts of it. Properly arranged data using the commands in the Arrange group allows you to present them in a logical and easy-to-understand way. This course explores the organization of data in Excel 2010 using the built-in features. It also deals with arranging objects for better viewing, as well as using hyperlinks to organize data. Prerequisites Knowledge of basic text processing, calculations and spreadsheets; familiarization with the Microsoft Office work environment; Understanding the functionality of the Internet and web pages.

Target Audience

End users who want to gain dexterity in using Microsoft Excel 2010 at an advanced level.

Objectives

• Managing and arranging data in Excel 2010
• Sort data in more than one column or row
• Create a filter customize
• highlight 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 in print view
• create a hyperlink
• edit hyperlinks
• sort and filter data
• create a highlight so you can group and centralize data
• arrange objects on a page
• create a hyperlink from a worksheet to a webpage