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.
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. ...