Basics of Excel

• MS Excel is a commercial spreadsheet application, written and distributed by Microsoft.
• It is capable of performing calculations, analysing data and integrating information from different programs.
• A Excel spreadsheet is a two dimensional grid with columns and rows.





• Rows are numbered from 1 onward and keeps on increasing as you keep entering data. Maximum limit is 1,048,576 rows.
• Columns are numbered from A onward and keeps on increasing. After Z, it will start the series of AA, AB and so on. Maximum limit is 16,384 columns.
• The Excel files are save by default with .xlsx extension.

Working with Excel

To create a new spreadsheet

• Open Excel choose a blank sheet type.

Entering data in spreadsheet:

cell edit mode

• The basic way to enter data into Excel is to simply select a cell and type directly into it.
• If you press Enter or select a different cell the typed content remains in the cell and cell exist edit mode.

Entering a single value into a range of cell:

• Highlight all the cell you want to populate.
• Type the value or text into active cell. Then press "Ctrl" Enter.
• This copies the text you have types into all of the cell in the selected range.

Inputting a series of value:

• If you want to enter a series of values like 1, 2, 3 .... into a range of cell, this can be done using the Excel Autofill.

Inserting formula:

• For inserting formula go to the formula bar, enter the formula and then press Enter.

Importing data into Excel:

• Click the cell where you want to put data.
• Go to the data tab, in the get external data group click from where you want to import the data.
• Locate and double click the file that you want to import.

To enter a table:

• Click the insert command in home tab and than on table symbol.

To select data

• Drag the mouse over the data you want to select.
• If you want to select a specific region, select any cell in that region then click F5.
• Select current region from the radio button. Click on OK to see the current region selected.

To delete data

• Select the data you want to delete then right click on the sheet and select delete option.

Save your work

• To save your data click on file then click on Save As.

My notes