Data Analysis with Microsoft Excel: Updated for Office 2007

35

Chapter 2

WORKING WITH DATA

Objectives

In this chapter you will learn to:

Enter data into Excel from the keyboard

Work with Excel formulas and functions

Work with cell references and range names

Query and sort data using the AutoFilter and Advanced Filter

Import data from text fi les and databases

▶

▶

▶

▶

▶

Copyright 2010 Cengage Learning, Inc. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part.