Browse » Home
Thursday, April 12, 2012
How to Use Excel 2010
1. Open a new Excel 2010 spreadsheet by double-clicking on the Excel icon on your desktop. Look at the spreadsheet and its layout. New files have three worksheets. Move between the three spreadsheets by clicking 'Sheet 1,' 'Sheet 2' or 'Sheet 3' in the lower left part of your screen.
2. Examine the tabs along the top -- 'File', 'Home,' 'Insert,' 'Page Layout,' 'Formulas,' 'Data,' 'Review' and 'View.' Click on each one to see its options. Most basic Excel 2010 commands are found on the 'Home' tab.
3. Click the cell in the upper left part of the spreadsheet marked A1, found in column A, row 1. Type the name of your first variable in cell A1 and additional variable names in B1, C1 and so forth.
4. Create your data table by entering data beneath each variable name in the cells A2, A3 and so forth. Use as many cells as necessary to fit your data set. Scroll down using the arrows on the right hand of your screen.
5. Change the formatting of the cells using the commands found on the 'Home' tab. Click on a cell or group of cells and change their font, color, size or appearance.
6. Move cells by highlighting them and hovering over the thick black border until you see a four-headed arrow. Click and drag the cells to your desired location. Copy cells by highlighting them and right-clicking on them. Click 'Copy,' click to where you want to move them, right-click again and click 'Paste.'
7. Perform basic functions by going to the 'Formulas' tab and clicking 'Insert Function.' Search for the name of the function you want to perform, such as adding, averaging or finding the maximum. Input a range of cells to tell the spreadsheet what calculation to perform. Press the 'Enter' key to view the result of the formula.
8. Save your worksheet by clicking the green 'File' tab. Select 'Save As' to designate a destination folder and unique name for your Excel 2010 spreadsheet. Click 'Print' to print a copy of your spreadsheet.
9. Access the Excel 2010 help files by clicking the blue question button in the top right corner of the screen. Type your question into the search box to find an answer from Microsoft.