Align data between the left and right sides of a cell for MS Excel

Align data between the left and right sides of a cell 

• Select the cell,  or cells,  you wish to align. 
• On the Home tab in the Alignment group,  click the Align Text Left icon to align data with the left edge of the cell. 
• Click on the Center icon to center data in the cell. 
• Click on the Align Text Right icon to align data with the right edge of the cell. 

Home Tab for MS Excel

Home Tab:
Formatting and Customizing Data 
Discover the Excel Cell Alignment Options 
The options allow you to change alignment of the text in a cell or cells,  text orientation,  merge several cells together and so no.
For more alignment options,  you can click on the Alignment group dialog box launcher to display the Format Cells dialog box.

Save a workbook (first time)

Save a workbook (first time) 

• From File Tab,  dick Eave OR click the save button on the Quick Access Toolbar. 
• From the Save as dialog box displayed,  ensure that you browse to the folder/diak drive that you would Like to save the file. 

Speed up your data entry

Speed up your data entry 
               Enter key : Pressing the key will enters the data and moves the active cell highlight down to the next cell in the current column.
Tab key : Pressing the key will enters the data and moves the active cell highlight to the next cell in the current row.
Arrow keys: Pressing the key will enters the data and moves the active cell highlight to the next cell in the direction of the specific arrow key pressed.
Esc key: Pressing the key will cancel the current data entry.  Starting with Excel,  we will create a result sheet.  We create the results sheet which will look like.
File Tab:

Table : File Tab Menu 

Enter Data into the Excel Worksheet for MS Excel

Enter Data into the Excel Worksheet:
Enter text into a worksheet 

• Select the cell in which you want to enter the text. 
• Type in the text/data into the cell. 
• Press the Enter key.  Text entries are left aligned by default. 

Excel 2010 ribbon

Excel 2010 ribbon 

• Home : Use this tab when creating,  formatting,  and editing a spreadsheet, 
• Insert: Use this tab when adding particular elements (including graphics,  PivotTables,  charts, hyperlink,  and headers and footers)  to a spreadsheet, 
• Page Layout : Use tab when preparing a spreadsheet for printing or reordering graphics on the sheet 
• Formulas : Use this tab when adding formulas and functions to a spreadsheet or checking a worksheet for formula errors, 
• Data;  Use this tab when importing,  querying,  outlining,  and subtotalling the data placed into a worksheets data list. 
• X Review: Use this tab when proofing,  protecting,  and marking up a spreadsheet for review by other. 
• View : Use this tab when changing the display of the Worksheet area and the data it contains. Excel 2010's user interface is based on the ribbon,  which is a bar across the top of the window that contains tabbed pages of commands and icons/buttons.
• Ribbon: The whole bar,  including all of the tabs. 
• File Tab: On the far left side of the Ribbon,  the file Tab let's you perform tasks that are common across any Office applications.
• Quick Access Toolbar : Located on top of the Excel screen above the File Tab, 
• Tab: Excel's main tasks are brought together and display aim the commands commonly needed Clicking a tab name once activates the tab. 
• Group : A section of a tab that organizes related command buttons into submission. For example,  the Home tab has the following groups;  Clipboard, Don't,  Assignment, Never,  Styles,  Cells,  and Editing. 
• Dialog box launvher: A small icon in the bottom-right comer of a group,  from which you can opens dialog box related to that group. 

Modes for MS Excel

Modes :
There are 2 modes of a cell :

1. Edit Mode. 
2. Selection Mode. 

Following are the ways to bring a cell from select to edit mode:

Double Click on the Cell OR press function Key OR Single Click on Formula Bar.