Data Clean-Up and Management

5

Microsoft Excel techniques

Abstract:

Microsoft Excel is the workhorse tool for data management and clean-up. This chapter will describe techniques for selecting cells, sorting, filtering and using the AutoSum and Fill functions.

Key words

Excel

select

sort

filter

sum

fill

Creating datasheets

The basic Microsoft Excel unit is a worksheet in a workbook. The file is the workbook; the worksheet is a tab in the workbook. Tabs are at the bottom of the screen; with a right click they can be given meaningful names. In the worksheet, the top row contains the column labels. These describe. Each row is a record for a specific entry, transaction, person, thing or entity. The data in the columns describes the entry, transaction, person, thing or entity. ...