Lesson 2 Part 1.3 - Using Cntrl and Arrow Keys to move on the worksheet

In this part you can practice moving the cell pointer around a blank worksheet and
between data entries with the Ctrl key and the arrow keys in Sheet1 of Book1. (Excel 2007)

1. Press Ctrl+→, Ctrl+↓, Ctrl+←, and Ctrl+↑ in succession to jump the cell cursor from one corner to the next of the entire Sheet1 worksheet. The first time you press Ctrl+→, the cell cursor jumps from cell A1 all the way to cell XFD1. When you next press Ctrl+↓, the cursor jumps from cell XFD1 all the way down to cell XFD1048576. When you then press Ctrl+←, the cursor jumps all the way left to cell A1048576, and from there all the way back up to cell A1 when you press Ctrl+↑. All this corner-to-corner jumping happens because there are no occupied cells in a particular direction, so the cursor jumps right to the cell on each border of the worksheet.
2. Move the cell cursor to cell A18, type Stop, and press Ctrl+Home. Next, press Ctrl+↓.The cell cursor stops in cell A18 rather than A1048576 because A18 is now occupied with the label Stop.
3. Move the cell cursor to cell AB18, type Stop again, and then press Home. Now, press Ctrl+→.This time, the cell cursor stops in cell AB18 rather than XFD18 because AB18 is now occupied.
   In case your excel version is 2003 the row ranges will be 65536 and colum IV

Lesson 2 Part 1.2 - Browsing through the Worksheet

In this section we will learn to go to different parts of the workbook

1. To scroll up and down rows of the worksheet by windows, press the Page Up orPage Down or click the blank area above or below the scroll box in the verticalscroll bar.
2. To scroll left and right columns of the worksheet by windows, click the blank areato the left or right of the scroll box in the horizontal scroll bar.
3. To quickly scroll through rows or columns of the worksheet, hold down the Shiftkey as you drag the scroll box up or down in the vertical scroll bar, or left and rightin the horizontal scroll bar.
4. If you use a mouse with a wheel button, scroll up and down the rows of the worksheetby rotating the wheel button forward (to scroll up) and backward (to scrolldown).
5. If you use a mouse with a wheel button, pan through the rows and columns of theworksheet by clicking the wheel button and then dragging the triangular mousepointer in the direction you want to scroll.
6. In case you want to go to a specific row and colum eg A65000 then you can use the "GO" Function. We have not started using any functions yet its OK. Press F5 and a box appears. Type A65000 in it and press enter. The cursor will move to that cell -- EASY !!

Lesson 2 Part 1.1 - Launching Excel

There are various ways to launch excel

1. Click Start on the Windows XP taskbar and then highlight All Programs andMicrosoft Office before clicking Microsoft Office Excel 2007. If you’re usingWindows Vista, you click the Start button, type ex in the Start Search textbox and then press Enter while the Microsoft Excel 2007 Office 2007 option isselected at the top of the Programs menu.
2. Click the Excel 2007 shortcut button on the Windows Quick Launch toolbar.
3. Double-click an Excel workbook file in any folder on any drive to which your
   computer has access
4. Double-click the Microsoft Excel 2007 program shortcut icon on your
   Windows desktop
5. Enter Start --> RUN and type excel and enter

Lesson Number 2 - Data Entry in Spreadsheet - Intro

We will be covering the following in this Lesson

1. Launching Excel and opening a new workbook
2. Navigate around the workbook
3. Selecting cell ranges in a worksheet
4. Doing simple data
5. Using AutoFill to create data series and copy formulas
6. Saving the spreadsheet as an Excel workbook file

Exercise 1-1: Opening the Office Menu and Selecting Its Commands

In this exercise, you get familiar with the commands on the Office menu as you practiceopening the Office menu and selecting some of its commands. Make sure that Excel 2007is running and an empty Sheet1 worksheet is active on your computer monitor
1. Highlight the Office Button (by hovering the mouse pointer over it without clickingthe mouse button) and wait until its ScreenTip appears.The ScreenTip shows you an image of the menu and gives you a brief descriptionof its function.
2. Click the Office Button to open its pull-down menu.Note the commands New through Close in the left menu pane. Also note the ExcelOptions and Exit Excel command buttons at the very bottom of the menu.
3. Highlight the Save As command on the Office menu (but don’t click it).Note all the Save a Copy sub-options that now appear in the right menu pane.
4. Now, click the Save As command on the Office menu to select it.Excel opens the Save As dialog box where you can modify the name, location, andtype of Excel workbook file before saving a copy of it.
5. Press the Esc (Escape) key on your keyboard to close the Save As dialog box.
6. Press Alt+F to open the Office menu again, this time from the keyboard.This time, small letters appear on each command as well as on the sub-optionbuttons attached to the Save As and Print commands. These are the access keysthat you can type to select an option rather than clicking its name or button.
7. Type W to display the Print command sub-options, and then type V to select thePrint Preview sub-option.Excel displays an alert dialog box indicating that there’s no data in the Sheet1worksheet to preview. Note the appearance of the dashes in the Excel worksheetdisplay showing where the pages would be divided.
8. Click OK in the alert box and then press Alt+FI to open the Excel Options dialog box.The Excel Options dialog box contains all the options for changing the Excel programand worksheet options.