After creating the basic structure of his worksheet, Sean is now ready to enter data, such as the names of the students, marks obtained, etc.

In This Chapter:

Entering Data

Here we go over the basics of data entry in Excel.

Editing Data

Sean knows that even if he makes a mistake when entering data, he can easily edit it.

Copying and Moving Data

Here we go over the basics of copying and moving data between cells.

Move or Copy a Formula

There are special cases to watch out for when copying or moving formulas.

Move or Copy Cells

Here we go over how to copy data from one set of cells to another and all of the special cases it involves.

Copy Only Visible Cells

If some cells, rows, or columns on your worksheet are not displayed, you have the option of copying all cells or only the visible cells. For example, you can choose to copy only the displayed summary data on an outlined worksheet.

Copying Cell Data and Values

You can copy the underlying data of cells (like the formula) or the final outputted value you see displayed in a cell.

Copy Cell Formats

These steps copy only cell formatting such as font color or fill color, and not the contents of the cells.

Copy Formulas

With this technique you can copy only the formulas from your cells.

Move or Copy Sheets

Sean is very careful when moving or copying sheets. Calculations or charts based on worksheet data might become inaccurate if you move the worksheet. Similarly, if you insert a worksheet between sheets that are referred to by a 3-D formula reference, data

Copy Comments

You can copy and paste only the comments from your cells.

Move Rows, Columns or Text Boxes

Here we go over moving rows, columns and text boxes.

Copy Data and Charts to Word or PowerPoint

Sean wants to copy the data and charts to a word document and make a slide in PowerPoint.

Filtering

Sean wants to know the names of all the students who have received a mark of less than 80 in English, Math, and Physics and also those who got more than 95 in Chemistry. He makes use of the filtering feature.

Sorting

Here we go over some of the various techniques you can use to sort your rows and columns.

Lists

Sean wants to make use of the list features to manage and analyze groups of related data in an Excel worksheet. For example, to sort the list in ascending order of the marks obtained, he can filter names of students who have secured more than 90 marks in

AutoFilter Drop-Downs

AutoFilter drop-downs are automatically added in the header row of a list when a list is created.

Insert Row and Total Row

Here we cover inserting rows into your lists and displaying total rows.

Resize List Command

You can resize a list to include neighbouring cells.

Insert or Delete Command

You can add or remove entire columns from your lists with this command.

Create a Consecutive List of Dates

You can automatically create a full list of consecutive dates with this technique.

Importing Data

Sean does not have to retype any data whenever he wants to analyse the marks obtained by John or when he has to analyse the trend in scoring marks in chemistry by the students. He imports data, updates the Excel reports and summaries automatically from th

Validating Cell Entries

Sean makes use of the Excel features to introduce validation parameters while entering the data to avoid errors such as type of values to be allowed. This is useful when keying in decimals, integers, date, time periods, text length and other parameters s

Forms

Sean wants all the teachers in the school to use spreadsheets. He decides to make use of the forms feature to enable all the teachers in the school to capture and organise the data.