Spread sheet software is the software that works with data on the sheet. MS Excel is a spreadsheet program developed by Microsoft Corporation. It is used for storing data, creating table, chart, using formula and performing other data related tasks. MS Excel Workbook till window 2003 has extension .xls while 2007 and later has extension . xlsx. Excel Template has extension .xlt
How to Start Microsoft Excel ?
- Click on start.
- Click on program
- Click on Microsoft Office
- Click on Microsoft Excel .
Or
- Click on start.
- Click on run
- type in excel
- Click on ok. and show the icon .
How To Make Bar Diagram & Pie Chart in MS-EXCEL
Using pie chat only one data range can be set at a time set a data just like as follows .Process:-
- Select the data range and follow all the previous steps by choosing pie chart wizard or
- Click on insert menu
- Chart command and follow the same .
Name of Items | Quantity in M.T (Matric Ton ) |
Paddy | 250 |
Wheat | 180 |
Maize | 350 |
Mustard | 190 |
Pie Chart
How To Data Filter in MS-Excel
Staff Salary Sheet Making in MS- EXCEL
s.n | Name | Post | Basic Salary | Working Day | Phone exp | Fuel Exp. | P.F | Food Exp. | Total Salary | Advance | Due Salary |
1 | Jay Sagar | Manger | 45000 | 29 | 5000 | 10000 | 4500 | 3000 | 57000 | 35480 | 21520 |
2 | Ramesh | G.M | 40000 | 30 | 3000 | 10000 | 4000 | 2500 | 55500 | 25000 | 30500 |
3 | Rakesh | Accountant | 35000 | 28 | 1500 | 2000 | 3500 | 1500 | 34166.66 | 15800 | 18366.66 |
4 | Gita | Sales man | 25000 | 24 | 1500 | 2000 | 2500 | 1500 | 22499.99 | 5600 | 16899.99 |
P.F = Basic Salary x 10 %
Total Salary = Basic Salary / 30 x Working day + Phone Exp + Fuel Exp – P.F + Food Exp
Due Salary = Total Salary – Advance
How to Make Store Bill in MS Excel
s n | Particular | Quantity | Rate | Amount |
1 | Keyboard | 15 | 530 | 7950 |
2 | Monitor | 12 | 7800 | 93600 |
3 | Printer | 10 | 18500 | 185000 |
4 | CPU | 10 | 22500 | 225000 |
5 | UPS | 20 | 3500 | 70000 |
Total | 581550 | |||
Discount 15% | 87232.5 | |||
Taxable amount | 494317.5 | |||
vat | 64261.27 | |||
Bill Amount | 55857877 |
Amount = Quantity x Rate
Total = Dube click in Auto sum (sigma)
Discount = click on Total amount x 15 %
Taxable Amount = click on Total Amount – Click on Discount amount
Vat = Click on taxable amount x 13 %
Bill Amount = Click on Taxable amount + Click on Vat amount
How To Use VLOOKUP in MS- Excel