Some tips on performance statistics with Excel

As a teacher, often to use Excel 2000/XP students to deal with, the following is a small compilation of some of the data, on the use of Excel in the process encountered several problems, is sorted as follows, hope to be helpful to everyone.

1. Edit cells quickly with the keyboard

In case of emergency (for example, your mouse is temporarily unavailable), or do not like to switch frequently between keyboard and mouse

Filtered Ads

, you can use the keyboard to quickly edit cells: First select the cell you want to edit, and then press the "F2" key to put the selected cell in the edited state, and then press the "Enter" key to confirm the modification after the modification is complete.

2. Add Calculator to Excel toolbar

It is sometimes necessary to use a calculator to calculate some data in advance in the process of performance, and then input it into Excel. To add a calculator to the Excel toolbar, click the menu "view → toolbar → customize" command, eject the Customize dialog box, click Tools in the Categories list under the Commands tab, and then select Customize in the Commands list and drag to the toolbar to release the mouse. When you close the Customize dialog box and click the button you just added, Excel starts the calculator.

3. Save Excel information as a picture

Sometimes we need to put the information in Excel as a picture in a Word document or other image-processing software by first selecting all the cells you want in the Excel worksheet, while holding down the Shift key and clicking Copy Picture on the Edit menu. In the dialog box that pops up, select the "as shown on screen" check box and [OK], and then click the "Paste" command on the Edit menu in the destination worksheet or other document of the picture.

4. Realize the transpose of data area ranks

Suppose you want to convert a 10 row x20 column data area (A1:T10) to a 20 row x10 column. After you select the cell for the A1:T10 data area, click Copy on the Edit menu, and then click to select the upper-left cell (such as A11) where you want to place the transpose table range, and click Edit The select Paste command in the menu, select the "Transpose" checkbox in the selected Paste dialog box that pops up and [OK], and the table after the row and column transpose appears in the A11:j30 cell range. Finally, remove the A1:t10 cell range.