Thursday, 19 November 2015

Microsoft excel

Review of excel 2013

Image result for excel Microsoft Excel is a spreadsheet developed by Microsoft for Microsoft Windows, Mac OS X, and iOS. It features calculation, graphing tools, pivot, and a macro programming language called Visual Basic for Applications. It has been a very widely applied spreadsheet for these platforms, especially since version 5 in 1993

Microsoft Excel has the basic features of all spreadsheets, using a grid of cells arranged in numbered rows and letter-named columns to organize data manipulations like arithmetic operations.  In addition, it can display data as line graphs, histograms and charts, and with a very limited three-dimensional graphical display. It has a programming aspect, Visual Basic for Applications, allowing the user to employ a wide variety of numerical methods, for example, for solving differential equations of mathematical physics, and then reporting the results back to the spreadsheet. It also has a variety of interactive features allowing user interfaces that can completely hide the spreadsheet from the user. 

The simplification of the interface means that some functions have been lost or hidden or have become more complicated to find and use than before. For example Auto Correct features have disappeared from the right click menu so you have to enter a settings menu to add corrections you want to use.

Pros:
  • -          Touch Friendly
  • -           Simple interface
  • -          New useful functions such as importing video and alignment grids
  • -          the ability to organize large amounts of data into orderly, logical spreadsheets and charts
  • -          Excel crunches numbers almost instantly, making batch calculations much easier than working things out yourself with a calculator.
  • -          as part of Microsoft's Office suite, Excel works with almost every other piece of software in Office. Excel spreadsheets can be easily added to Word documents etc.



-          Cons:

  • -          PDF import still has formatting issues
  • -          Its quite hard to understand some areas of the software and getting the full benefit out of it takes a lot of practice
  • -          Excel has no means of checking for human error during data entry, which means that the wrong information can skew all the results
  • -          Manually entering data into Excel can take a very long time -- especially if you have a lot of data to enter.
  • -          While there are several low or no-cost alternatives, getting genuine Microsoft Excel isn't free

No comments:

Post a Comment