EXCEL BASIC

 LETS START THE EXCEL ....................

WITH WE START JUST LOOK OUT SOME INTERESTING FACT ,

MS Excel is in tabular format (workbook) consisting of rows and columns.

FROME MS Excel 2007, Row numbers ranges from 1 to 1048576; in total 1048576 rows, and Columns ranges from A to XFD; in total 16384 columns.

IN MS Excel 2003 there was  65,536 rows and 256 columns

it is assumed that Audience has knowledge how to open the excel file 

(start + R > then type " Excel" in Box) 

Navigation with Rows and Columns

CTRL + UP   

CTRL+DOWN

CTRL+RIGHT 

CTRL+LEFT    

SHIFT + SPACE  = SELECT RAW

CTRL + SPACE = SELECT COLUMN

CTRL+SHIFT+ SPACE = SELECT ALL ARE AND COLUMN

The intersection of rows and columns is called cell and Cell is identified with Combination of column header and row number.

Important parts of this Excel window.

There are following three important points, which would help you while typing −

• Press Tab to go to next column.
• Press Enter to go to next row.
• Press Alt + Enter to enter a new line in the same column.
• 
  

 you would have to use the scroll bars, as shown in the following screen shot

You can scroll your sheet by rolling your mouse wheel, which is equivalent to clicking the up-arrow or down-arrow buttons in the scroll bar

Use Keyboard for moving around 

The following keyboard commands, used for moving around your sheet, also move the insertion point −

Keys	Moves
	Forward one box
	Back one box
	Up one box
	Down one box
PageUp	To the previous screen
PageDown	To the next screen
Home	To the beginning of the current screen
End	To the end of the current screen

You can move box by box or sheet by sheet. Now click in any box containing data in the sheet. You would have to hold down the Ctrl key while pressing an arrow key, which moves the insertion point as described here −

Key Combination	Where the Insertion Point Moves
Ctrl +	To the last box containing data of the current row.
Ctrl +	To the first box containing data of the current row.
Ctrl +	To the first box containing data of the current column.
Ctrl +	To the last box containing data of the current column.
Ctrl + PageUp	To the sheet in the left of the current sheet.
Ctrl + PageDown	To the sheet in the right of the current sheet.
Ctrl + Home	To the beginning of the sheet.
Ctrl + End	To the end of the sheet.

Moving with Go To Command

Press F5 key to use Go To command, which will display a dialogue box where you will find various options to reach to a particular box.

Normally, we use row and column number, for example K5 and finally press Go To button

Saving the File

Once you are done with typing in your new excel sheet, it is time to save your sheet/workbook to avoid losing work you have done on an Excel sheet. Following are the steps to save an edited excel sheet 

Step 1 − Click the File tab and select Save As option.

Step 2 − Select a folder where you would like to save the sheet, Enter file name, which you want to give to your sheet and Select a Save as type, by default it is .xlsx format.

Step 3 − Finally, click on Save button and your sheet will be saved with the entered name in the selected folder.