How to Start Spread Sheet (MS-Excel)

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 ?

  1.  Click on start.
  2. Click on program
  3. Click on Microsoft Office
  4. Click on Microsoft Excel .

Or

  1. Click on start.
  2. Click on run
  3. type in excel
  4. 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:-

  1. Select the data range and follow all the previous steps by choosing pie chart wizard or
  2. Click on insert menu
  3. Chart command and follow the same .
Name of ItemsQuantity in M.T (Matric Ton )
Paddy250
Wheat180
Maize350
Mustard190

Pie Chart

How To Data Filter in MS-Excel

Staff Salary Sheet Making in MS- EXCEL

s.nNamePostBasic SalaryWorking DayPhone expFuel Exp.P.FFood Exp.Total SalaryAdvanceDue Salary
1Jay SagarManger450002950001000045003000570003548021520
2RameshG.M400003030001000040002500555002500030500
3RakeshAccountant3500028150020003500150034166.661580018366.66
4GitaSales man2500024150020002500150022499.99560016899.99
Formula’s :

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

How To Use VLOOKUP in MS- Excel

 

How To Use XLOOKUP in MS- Excel

Leave a Comment

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

Scroll to Top