What is MS Excel?
MS Excel is a commonly used Microsoft Office application. It is a
spreadsheet program which is used to save and analyse numerical
data.
Layout and Ribbon of Excel
Insert new Sheets: Change the name of the worksheet: click the
worksheet name and enter a new name for the worksheet.
Column
Row
Cell
Auto Fill: Select one or more cells you want to use as a basis for
filling additional cells
Type 1 and 2 in the first two cells.
Drag the fill handle .
If needed, click Auto Fill Options and choose the option you
want.
Wizard
Charts
Auto Shape
Adding Auto Shapes in Excel
Step 1: Open Excel and select the worksheet where you want to
insert the Auto Shape.
Step 2: Click on the "Insert" tab.
Step 3: Click on "Shapes"
Step 4: Select the Auto Shape you want to insert.
Step 5: Draw the Auto Shape on the worksheet.
Short Keys:
Copy: Command+C
Cut: Command+X
Paste: Command+V
New Worksheet: Command+N
Open: Command+O
Save: Command+S
To italicize and make the font bold: Command+I, Command+B
To select the entire row: Shift + Space
To select the entire column: Command+Space
Addition
=Sum(A1:A2)
Subs-traction
=A2-B2
Percentage
=C2/B2
Multiplication
=A1*A2
Format of Table:
Themes: Go to Page Layout
Fronts: Go to Page page Layout and click fronts
Pivot Table
Merge and Centre: Home page
Auto Sum: Home page click auto sum option
Number Format: Go to home page and click the option of format
Insert Table in between: Double click in between the line