You can start Microsoft Excel in three ways, either from Microsoft Office Toolbar, shortcut icon or from Start button > Programs > Microsoft Excel.
The files created and used by Excel are called workbooks and have an extension as .xls or .xlt and other extensions as well. When you start Excel, you can either open an existing workbook file or create a blank workbook to work using Excel.
Workbook and WorkSheets
A workbook consists of many worksheets named as Sheet1, Sheet2 which you can find below the workbook. You can rename these sheets your convenient names. Each of these sheets is works the same. You can work and save different tasks in different worksheets. A worksheet is a tabular structure in columns named as A, B.., AA, AB… so on.
Rows are numbered as 1,2,3. It can support up to 1048 thousand rows and 16 thousand columns in a single sheet. Each of the cells is named as Column Name followed by row number. For eg, the first cell in column A at row 1 is named as A1, cell right to A1 is named as A2. The cell below A1 is named as A2.
Working with the worksheet
You can enter text or numeric data in these cells for creating reports, calculating, drawing graphs, store tabular data as per your tasks and requirements. At any point in time, a single cell remains focussed with a lined box around the cell.
You can change to another cell by click on the cell using a mouse or move the focus using arrow keys on a keyboard.
You can propagate the cell contents by dragging a handle from a cell that is focused to populate automatic values in adjacent cells. You can copy any dimensions of data and paste at any cell as the starting point in any worksheet or workbook.
You can also add a new row or column, delete a row or column either using mouse right-click or keyboard shortcuts or selecting icons in the top taskbar.
Save, Close Worksheet
You can save the workbook at the end by selecting File at the top menu and click Save or using keyboard shortcut Ctrl+S. You can create a new workbook from File > New or Ctrl+N to work in your next task. You can protect your workbook using a lock to prevent your data from being erased.You can close the workbook and or excel by selecting File Close from the menu or clicking ‘x’ at the top right corner of a workbook or excel