Advantages and Disadvantage of Microsoft Excel .pdf
Original filename: Advantages and Disadvantage of Microsoft Excel.pdf
This PDF 1.7 document has been generated by Microsoft® Word 2016, and has been sent on pdf-archive.com on 03/01/2018 at 13:49, from IP address 14.102.x.x.
The current document download page has been viewed 583 times.
File size: 105 KB (3 pages).
Privacy: public file
Download original PDF file
Advantages and Disadvantage of Microsoft Excel
Introduction: Microsoft Excel is a spreadsheet refined by Microsoft for
Windows,macOS, and Android.It is a software included in Microsoft
office suite.Its features the ability to perform calculations, create pivot
tables, using graphics tools and create macros.
Microsoft Excel basic features used to create spreadsheets, which
use a collection of cells arranged in rows and columns like a big table.
Microsoft Excel Advantages:
1. Easy to store data: In MS Excel, it is easy to store the data,
perform calculations, format the cells and adjust layouts to generate
the output and reports to share with others.Many templates make it
easy to accomplish a wide range of tasks.
2. Analysis of large amounts of data: MS Excel spreadsheet
enhance your ability to analyze large amounts of data.It provides
many analytical tools for the accurate analysis of large amounts of
data. With powerful filtering and sorting tools allow you to sort out a
large amount of data, it will be easier for you to find out the required
information and will assist in your decisions.And filtering removes
repeated data and helps to save time and effort.
3. Used for Formulas: Microsoft Excel performs all mathematical
and logical functions like addition, subtraction, multiplication,
division, average, etc. It provides many formulas that help you to
solve both simple and complex calculations.
4. Graphical Representations of data: It allows you to create the
visual representation of data and information. The data can be
visually displayed in the form of bar charts, column charts, and
5. Secure: Microsoft Excel files can be password protected for
security.A user can create a password within the Excel file.
Microsoft Excel Disadvantages:
1. Time Consuming: In Microsoft Excel, when we entering the data
manually it can take a very long time especially if you have a lot
of data to enter.
2. Viruses: In Microsoft Excel File, the viruses can be attached to
through macros.Macros are mini-programs that are written into an
MS Excel spreadsheet.
3. Customizable Graphs: This is a big disadvantage of Microsoft
Excel, it does offer a good variety of graph capabilities.The
customization of the standard formats, and combinations of the
different data sets and different types of graph is awkward and not
4. Hard to use: MS Excel training programs, it is still hard to use for
some users might not get the hang of it.While it is easy to create the
formulas, the reference cells, copy and paste the data and the
spreadsheets become more difficult to change and manage.
5. Difficult to analyze: The spreadsheets are absolute for creating
one-time analysis.Especially for some people, a spreadsheet is
difficult to analyze.It becomes problematic as the data grows and
emerge over time.As new rows and columns get added or new ones
created, the data and the formulas are not consistently
updated.These mistakes lead to bad results and decisions.
These are the advantages and disadvantages of Microsoft Excel.If you
have any problem related to Microsoft Office or any technical issues feel
to contact our Microsoft Contact Number anytime.