Saturday, May 27, 2017

MS EXCEL- WHICH BUSINESSES USES IT AND FOR WHAT PURPOSES ?



  MS Excel is used by a wide variety of businesses for different applications, starting from maintaining some household  details to important business application.

 a) Simple applications may include maintaining the addresses of all your friends or customers, maintaining monthly income /expenses of your house hold or maintaining your contact details.

 b)Small businesses like stationery stores, drug stores, courier service  points, two/four wheeler repair shops,two/four wheeler spares outlets, ready made dress outlets, sales and marketing groups, schools and colleges...

 c) In large business houses /departments.

 While we have considered which businesses will use MS Excel, we now move on to find out for what purpose it will be used, there are broadly for the following purposes:

 a) To maintain daily transaction details.
 b) To get average, sum, count,maximum,minumum of some data, like marks 
      obtained, expenses incurred.
 c) To filter and sort data. Filter to see only a paricular set of data like, 
     "Students from Bangalore", "Students of age greater than 15 years",
  "Only  boys/girls" etc. Sorting - like arranging names in
  ascending/descending order, arranging students based on maximum marks
  obtained, arranging executive's  names based on the monthly petrol bill
  claimed by them or tour expenses, executives how have taken maximum 
  number of days in the previous year etc.
d) Performing calculations using in built formulae or your own formulae as
  per different professional areas like engineering, statistics, banking &
  finance, HR, Courier & Logistics etc.
e) Generate  consolidated reports and charts fo business applications.

  By the broad set of applications listed above, you should understand that MS Excel can be practically used for any data related application.It is just versatile and practically available on all computers. If not MS Excel similar applications developed by others are also available for use.

No comments:

Post a Comment