Wednesday, July 4, 2012

Excelsheet for Beginners Day 1 (One)

MS Excel has been referred to as the world’s most popular database program because you can store vast amounts of data within a single workbook or worksheet. This MSEXCEL is meant much more than just crunching numbers.

This was not, however, the purpose for which Excel sheet was created. By using the many functions built in to Excel, you can build formulas that perform complex data calculations.

For millions of users the world over, Excel is also their number-one interface to the corporate database,as well as their premier charting program. Given Excel’s versatility, it should come as no surprise that mastering the basics of the program, is no small task.

Opening a New Workbook
Each time you launch MS Excel (using any method other than double-clicking an Excel workbook file icon), a new workbook containing three blank worksheets opens. You can build your new spreadsheet in this workbook, using any of its sheet pages.

The blank workbook that opens with Excel is given a temporary filename such as Book1, Book2, and so on, that appears after the application’s name on the program window’s title bar.

When Excel opens a blank workbook, the new workbook follows the Blank Workbook template (which controls the formatting applied to all its blank cells). You can also open new workbooks from other, specialized templates or from a workbook that you’ve already created.

Excelsheet workbook

Cell: A rectangle within a workbook or worksheet, it may contain text values or formulas that return a value.

Formula: A equation that performs various operations typically mathematical calculations within a worksheet.

Worksheet: A 2-D page of cells (256 columns wide and 65,536 rows long) that is contained within a workbook.

Workbook: A file that contains one or more worksheets.

Q. How do you create templates out of your own Excel workbook files?
A. Build a spreadsheet in a new or existing workbook file. To this spreadsheet add all the stock text and data, calculating formulas, and formatting required in all the files you will generate from its ensuing template and then save this file with the Office Button | Save As command.

In the Save As dialog box, select Excel Template (*.xltx) in the Save As Type drop-down list box and edit the dummy filename (without removing the .xltx filename extension) before you click the Save button.

To do open work/learn Excel, click Office Button New or press Ctrl+N or Alt+FN. Excel opens the New Workbook, single workbook is called as Excel Sheet, Many Excelsheet are called Excel Workbook.

To Navigate Through a Worksheet

To move by one cell
Press the Up Arrow key to move one cell up.
Press the Down Arrow key to move one cell down.
Press the Left Arrow key or the Tab key to move one cell to the right.
Press the Right Arrow key to move one cell to the left.

To move by one screen (screen resolution its 1280x800)(moving 1280x800 UP/Down fast)
Press Page Up or Page Down to move up or down.
Press Alt+Page Up or Alt+Page Down to move to the left or right.

To move to the edge of the current data entered region
Press Ctrl+Up Arrow to go extreme up(Starting of the data)
Ctrl+Down Arrow to go extreme down(end of the data)
Ctrl+Left Arrow, to go extreme left(Starting of the data)
Ctrl+Right go extreme right(end of the data)

To move to the extreme far end cells
Press End, and then press the Up Arrow, Down Arrow, Left Arrow, or Right Arrow key.

To move to the beginning of the current row
Press Home.

To move to the beginning of a worksheet
Press Ctrl+Home.

To move to the last populated cell on a worksheet
Press Ctrl+End.

Moving to a different sheet in the workbook

The easy way to select a new worksheet is to click its sheet tab, although you can also use the shortcut keys Ctrl+PageDown to select the next sheet and Ctrl+Page Up to select the previous sheet.

Selecting Commands on the Office Menu
Press the Esc (Escape) key on your keyboard to close the Save As dialog box.
click Office Button, Exit Excel or press Alt+FX to close the program.

Selecting Commands from the Ribbon
If you prefer selecting Excel commands from the keyboard, you’ll probably want to
memorize the following access keys for selecting the seven tabs:
Home tab: Alt+H
Insert tab: Alt+N
Page Layout tab: Alt+P
Formulas tab: Alt+M
Data tab: Alt+A
Review tab: Alt+R
View tab: Alt+W

End of  Day 1 (One) .. to continue...


Money CapitalHeight said...
This comment has been removed by the author.
Equity TipsProvider said...

Hi my loved one! I want to say that this post is amazing, great written and include almost all vital infos. I'd like to peer extra posts like this. Stock Tips