Wednesday, May 23, 2012

How to Learn Excel Spreadsheet


Free Excel Training from Microsoft
1. Download and install a free trial version of the Microsoft Office suite that includes Excel and several other useful programs in a limited time, fully functional trial version.
2. Click 'Start' at the Windows orb, 'All Programs' and 'Microsoft Office' to open the start menu group. Click 'Microsoft Excel 2010' to launch the software.
3. Click 'File' and 'Help' to launch the interactive training series to learn basic and intermediate Excel functions and to find step-by-step guides to performing the most popular functions.
Basic Excel Functions
4. Click 'Start' at the Windows orb. Click 'All Programs' and 'Microsoft Office' to open the start menu group. Click 'Microsoft Excel 2010' to launch the software.
5. Click once in the top left cell -- A1 -- and type in any number. Press 'Enter' to save the cell and move to the next cell down or press 'Tab' to save the cell and move to the next cell to the right. Alternately, type in any number and click another cell or use the arrow keys on the keyboard to save the cell contents and move to another cell.
6. Enter another number in a second cell. Press 'Enter' or otherwise save the cell contents by moving to another empty cell.
7. Press the '=' sign on the keyboard. Click the first cell with a number in it once with the mouse. Press the ' ' sign on the keyboard. Hold 'Shift' and press ' ' or press the ' ' key on the numeric keypad, if equipped, and then click once on the second cell with a number in it. Press 'Enter.' This creates a formula to add two cells together and display the results in a third cell.
8. Click in the first cell with a number and change the number. Press 'Enter' or otherwise save the cell contents by moving to another empty cell. Notice that the cell that displays the total updates automatically to reflect the new total. Formula cells update as new information is entered.

Blogger news