Pages

Sunday, July 26, 2015

The advantages and disadvantages of Microsoft Excel



Advantages of Microsoft Excel

Microsoft Excel
Microsoft Excel

You have to know that using the spread sheet on Excel allows you to insert a vast amount of data , including numbers via the equations in a simplified , effective , and fast way , Excel is portable , You can send it to someone through email , It allows you to insert the data not only numerically or a spreadsheet but also in an easy read and understandable manner by allowing you to insert the charts and the graphs .


You should know that Microsoft Excel allows you to manipulate , manage and analyze the data helping assist in decision making and creating efficiencies that will directly affect your bottom line , if you are using it for business or to manage personal database and expenses , And it gives you the right tools to accomplish all your needs .

Everyone should know that the web-based spreadsheet programs require the users to connect to the Internet to access their data , If an Internet connection is readily available , The users may prefer web-based spreadsheet programs because they allow the documents to be shared more easily .


Do you  know that Excel contains an extensive list of spreadsheet functions that can be useful to the advanced users and financial analysts , Excel is also available for both Windows and Macintosh computers which allow the data to be shared easily ?

You must know that Microsoft Excel is powerful analysis of large amounts of data , It is an effective program that can be used to complete assignments such as for many labs for students , You can now edit and work with your Excel spreadsheet through Cloud computing and access your work through various mobile devices and tablets .

Microsoft Excel
Microsoft Excel

It is very necessary to know that  Microsoft Excel is easy to enter and format the data , It has the ability to create graphical or visual representations of your data , You can work quickly in analysing large amounts of data , And it is easy to integrate Excel with other business applications .

You should know that Excel has improved on its charting and graphical representation of data with added chart formats and designs as well as improved Pivot Charts , We also have the ability to insert small miniature charts in cells called “Sparklines” which can give a quick overview .

It is very important to know that Microsoft Excel has changed format over the last few years it has also become easier to integrate excel data into other applications such as Microsoft Office , web applications , etc , With Excel Web App you can now work on the spreadsheets simultaneously with other users , The ability to work together enhances your ability to streamline processes and allows for brainstorming sessions with large sets of data .

Everyone must know that you can start with small Excel database application and as the need grows , you can use the same Excel application and upgrade your database platform from Excel to other high-end databases like Access , SQL Server , Oracle , MySQL , etc .


Disadvantages of Microsoft Excel

Microsoft Excel
 Microsoft Excel
You must know that Microsoft Excel is not easy to share , The ability for sharing a tool requires extra software to be installed on the PC and this becomes cumbersome , Tools like Google Documents are revolutionizing the way people share the documents online .

You should know that Microsoft Excel lacks any true relational functionality , when you use MS Access for databases and love the relational aspect of the database ,  The idea that you can link data by common elements ( such as employee ID , Stock Number etc ) greatly assists in the reduction of data , and the ability to analyze data . 

You should know that Excel 2010 has introduced larger spreadsheets and binary formats ,  using large amounts of data on the PC will slow down and freeze the PC , if you can send Excel via email , you can accidentally send your file to someone who should not have it or not authorized to have it , So ,You can password to protect your Excel file .

You should know that Excel has no means of checking for the human error during the data entry which means that the wrong information can skew all the results , Excel worksheet as a database has a limited number of rows or records that you can store but when you reach the 65k lines limit , you can convert it easily to Access and the rest of the application can be used .

It is very important to know that the accuracy is difficult , and the increased data errors is inevitable with larger quantities of information  , Excel’s lack of validation and potential copy-paste errors make it extra easy to slip in the mistakes , Precious time is wasted validating and tracking the data , It can be extremely challenging to spot and correct the errors especially with larger volumes of data .

No comments:

Post a Comment