Tuesday, November 13, 2012

How to Use Excel 2007


1. Enter text or numbers into a cell by clicking in the cell, typing the desired text, and press 'Enter.' Press 'Tab' to move to the next cell.
2. To insert a row of cells into your spreadsheet, select where you wish your new row to be, click the Home tab and the 'Insert' button, and then click 'Insert Sheet Row.' Create a new column by clicking 'Insert Sheet Column' under 'Insert.'
3. To merge multiple cells together, either vertically or horizontally, select the cells you wish to merge, and click 'Merge Cells,' which appears under the 'Merge and Center' button in the Alignment group under the Home tab.
4. Add two or more cells together by first clicking in a cell. Type '=SUM(' (open parenthesis), and enter the cells you wish to be added together, followed by ')' (close parenthesis). For example, =SUM(F4,F5,F6) would add the values of cells F4, F5 and F6. Write a long list of cells quickly by entering the starting cell of a row or column, typing ':' (colon), and entering the ending cell, for example, F4:F13. Use calculation operators to multiply, divide, add, subtract, or exponentiate multiple cells. For example, a cell with the formula =B7/B3 would divide the value in B7 by the value in B3.
5. Use a variety of functions to fit your needs. Click the 'Insert Function' button on the formula bar to pull down a long list of functions, and click the function you want. To average two or more cells, go down to AVERAGE, and type the cells you wish to average, between parentheses.

Blogger news