O'Reilly logo

Data Clean-Up and Management by Kenneth Furuta, Margaret Hogarth

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required