Introduction to MS Excel

What is MS Excel?

Microsoft Excel is spreadsheet program used to store and analyze numeric data in an efficient way. You can also say that it’s a collection of rows and columns that forms table.

Columns in MS Excel:

Columns in Microsoft Excel run Vertically and Alphabetic letters are assigned to each Column. e.g. (We have a column named student marks).

Rows in MS Excel:

Rows in Microsoft Excel run Horizontally and Numeric values are mostly assigned to Rows. e.g. (We have a row contains student marks).

Open Microsoft Excel:

If you are using (Windows XP, Windows 7 or Vista) than follow below steps to open Microsoft Excel.

  • Click on Start Menu
  • Point to Microsoft Excel
  • Click on Microsoft Excel

It can also be open from desktop shortcut if you have created. In this blog we will be working on Windows 10 and Microsoft Excel Version will be 2010. Follow below steps to open Microsoft Excel on Windows 10.

  • Click on start Menu
  • Type Microsoft Excel
  • Click on Microsoft Excel

Below image may help you in opening Microsoft Excel on Windows 10.

Worksheet in MS Excel:

A Workbook in Microsoft Excel is a collection of Worksheets. By default there are three worksheets in each new Workbook named as Sheet1, Sheet2 and Sheet3. You can add or delete worksheets depending on your requirements. There is an option to rename worksheets with meaningful names (For example rename Sheet1 with Monthly Expenses Details) by simply double click on worksheet name or by following below steps,

  • Right click on Worksheet name
  • Click on Rename
  • Type new name

Some Important Microsoft Excel Shortcuts:

Edit active cell F2
Cut Ctrl + X
Copy Ctrl + C
Paste Ctrl + V
Paste Special Alt + E + S
Toggle references F4
Start a new line within the same cell Alt + Enter
Insert worksheet Shift + F11
Fill down (e.g. copy formula down in selected cells) Ctrl + D
Insert row Alt + I + R
Insert column Alt + I + C
Print Option Ctrl + P
Save current Workbook Ctrl + S
New Workbook Ctrl + N
Brings up format cells menu Ctrl + 1
Bold Ctrl + B
Italic Ctrl + I
Undo Ctrl + Z
Redo Ctrl + Y
Select all used cells Ctrl + A

Leave a Reply

Your email address will not be published. Required fields are marked *