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.
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