This series of tutorial assumes that you are
Excel is a spreadsheet that helps you to do calculation and charting in an easy way. When you start Excel, you usually see 3 spreadsheets.
Every spreadsheet has a number of rows and columns.
Rows – denoted by numbers
Columns – denoted by alphabets
Cell – is a meeting point of a column and row, denoted by column letter followed by row number, like B3.
You can move to any cell in the spreadsheet by clicking mouse pointer at the cell or by using arrow keys in the keyboard.
When you type in Excel, alphabets will be aligned left, while numbers are aligned right.
To change cell contents, just type over.
To delete cell content, press Delete button keyboard.
Now type the following information and save as Sales and Expenses.
In cell D2, to find profit, type the formula =B2 – C2 and press Enter.
You get the 750 as the profit.
To copy this formula:
- familiar with Windows software, know how to type, save and open a file.
- beginner to Microsoft Excel.
- not afraid of making mistakes during learning.
Excel is a spreadsheet that helps you to do calculation and charting in an easy way. When you start Excel, you usually see 3 spreadsheets.
Every spreadsheet has a number of rows and columns.
Rows – denoted by numbers
Columns – denoted by alphabets
Cell – is a meeting point of a column and row, denoted by column letter followed by row number, like B3.
When you type in Excel, alphabets will be aligned left, while numbers are aligned right.
To change cell contents, just type over.
To delete cell content, press Delete button keyboard.
Now type the following information and save as Sales and Expenses.
In cell D2, to find profit, type the formula =B2 – C2 and press Enter.
You get the 750 as the profit.
To copy this formula:
- Place the cell pointer in cell D2.
- Move the mouse to the bottom of cell D2, till you get a thin plus.
- Drag the mouse till D5. Now you have copied the same formula that calculates profits for each sales people
View EasyElearn video about Microsoft Excel - Introduction
View EasyElearn video about Microsoft Excel - Calculation
