Excel is a spreadsheet software that provides tabular format workarea.

usages of Excel:
1. store large volume of data in tabular format
2. manage data (rearrangement, filtering etc)
3. query and perform calculations
4. analyse and prepare reports like charts
5. print data

Versions of Excel: 2007, 2010, 2016, 2019 etc.

default file name of Excel is Workbook or Book

Each Book contains number of worksheets or sheets

Create New file: Ctrl+N

Open already existing file: Ctrl+O

Save file: Ctrl+S

Excel File can be saved with .xlsx format.

Each sheet contains 16,384 columns and 10,48,576 rows

We can have more than one worksheet in a book but can work in one sheet that is called as Active Sheet.

Insert New Sheet at last:
Click on New Sheet Button at right side of sheet Tabs (Shift+F11)
(or)
Home Tab–>Cells Group–>Insert –>insert Sheet

Insert New Sheet before active sheet:
right click on active sheet–>insert

Rename a sheet:
Double Click on sheet name
(or)
right click on sheet–>rename
(or)
being in active sheet–>F2

Delete Sheets:
right click on sheet–>Delete
(or)
Home Tab–>Cells Group–>Insert –>Delete Sheet

Colums are identified with A,B,…AA,….AZ,BA,…..,XFD

Rows are identified with 1,2,3……1048576

Each Cell is identified like below:
ColNameRowNumber Eg:A1
RowNumberColNumber Eg:R2C4

Group of Cells can be identified like
First Cell:Last Cell

2 types of cell Selections:
1. array selection Eg: E2:E10 or H10:K10
2. vector selection Eg: A24:AB45

Out of all cells one cell can be activated at at time.

Identifications of Active Cell:
1. highlighted border
2. its corresponding cols and rows are highlighted
3. its name displays inside name box.

Name box displays the name of active cell
Formula bar displays the actual content of active cell.

Name box can also be used to activate a cell or even select range of cells.

Group of cells can also be assigned with some identification or name using namebox.

Excel Cell can be in 3 modes:
1. active mode
2. selection mode
3. editing mode

Ways to enter into editing mode:
double click inside cell
(or)
click inside formula bar
(or)
F2

Come out from cell by rejecting changes: Esc

Clear content of cell:
Home Tab–>Editing Group–>Clear

Del only deletes the content of the cell.

Entire data that we typed will be saved in the same cell in which we started working.

Manually Resize Column:
Drag from right edge of the desired column
(or)
Home Tab–>Cells Group–>Format Button–>Column width–>Enter numeric value

Auto Fit Column width:
Double click at right edge of the desired column
(or)
Home Tab–>Cells Group–>Format Button–>AutoFit Column

Cell data in Multiple Lines:
Alt+Enter : enable wrap text while entering data