What Are The Advantages And Disadvantages Of Ms Excel?

Question

What Are The Advantages And Disadvantages Of Ms Excel?

4 Answers

Answer Question

Answer 1

MS Excel provides the most simplest way to store data and to interpret data. MS Excel is used in almost all kinds of businesses from very small to very large. There are various ways through which MS Excel can help the managers to interpret data. For example, a company which sells mobile connections to the customers can enter their data in the excel sheets in the form of tables. At the end of the month if the manager wants to analyze the data then he can go in the "graphs" option in MS Excel and can see the percentages and the trends of the sales in previous months. Managers can also apply various functions on the data from the MS Excel. Managers can also use MS Excel in their business research analysis like if they want to find out industry trends then they can calculate regression equation and can determine the important factors which can impact their business. All accounting functions can be applied on data in MS Excel. I think MS Excel is the most simplest form of a database.

Answer 2

Anonymous answered

Excel can be sent by E-mail; no need for displacement. Excel is an all-in programme and does not need the addition of financial subsets.

Answer 3

Many
people say that MS excel can be used for small organizations only but
managers of large organizations are also taking benefit from it as it offers
very easy charts and formulas.

Answer 4

There are many advantages and disadvantages of MS Excel and some of them are given below:

If you have an MS Excel in your computer, then you do not need any other software for simple data storage. MS Excel is very user friendly and after understanding a few functions of MS Excel you can learn all on your own. For simple record keeping and functions MS Excel is best and you can also install SQL Server, Oracle, MySQL, etc. For specialized functioning. It can be connected directly with OLAP databases. There are all of the basic financial functions available in MS Excel like Fixed Assets Depreciation, Amortization, etc. MS Excel can also be sent through email and it is very cheap as well.

Some of the disadvantages of MS Excel are there but they can be overcome. When you will save more applications in the same excel file, then its execution can be very slow. If you store different files separately on different locations, then your data can be lost. MS Excel is not suitable for storing confidential data.