Microsoft Excel

Microsoft Excel is a spreadsheet application that is developed by Microsoft for both Microsoft Windows and Mac OS X machines. It is a very widely applied spreadsheet for these platforms, since 1993, and it even replaced Lotus 1-2-3 as the industry standard for spreadsheets. It is useful in entering, editing, analyzing and storing data and is also a part of the Microsoft’s Office applications.

Excel is used in Arithmetic operations such as addition, multiplication, subtraction and division for numerical data can also be done with Excel. It even enables the users to sort the numbers / characters according to some given criteria (like ascending, descending etc.) and helps in solving simple financial, mathematical and statistical formulas.

The information garnered in a spreadsheet can easily be incorporated into electronic presentations, web pages, or printed off in report form.

Useful Features of Microsoft Excel:

Excel has various features like calculation, pivot tables, graphing tools, and also a macro programming language called Visual Basic for Applications. Here is a list of few useful features:

  • Pivot Table: Performs even the highly complex analyses quickly. It summarizes your data with previews of various pivot-table options, so that you can compare them and choose the option that suits best
  • AutoSum: This feature helps you to add the contents of a cluster of adjacent cells
  • AutoFill: This feature allows you to quickly fill cells with repetitive or sequential data such as chronological dates or numbers including repeated text. AutoFill can also be used to alter numbers and text or copy the functions.
  • AutoShapes toolbar: This feature will allow you to draw a number of geometrical shapes, flowchart elements, arrows, stars and more. With these shapes you can draw your own graphs
  • Hyperlink: With this, one can link one file to another file or page with the use of Excel
  • Clip art:  In this we can add images, audio, video clips to the excel file

Microsoft Excel Versions:

For Windows:

Microsoft Excel Versions was introduced in 1987 and the first version was Excel 2.0, then, it came up with Excel 3.0 in 1990, and in 1992, excel 4.0 was introduced with Auto Fill feature.

Excel 5.0 in 1993, was included in Office 4.2 and  4.3, that included DOOM-like game, introduced Visual Basic Programming to provide automated user-defined functions

Excel 7.0 in 1995 for Windows 95 was introduced in Office 95. There were no mark able external changes, however was faster and stable

Excel 8.0 was included in Office 97 (for x86 and Alpha): It was a major upgrade that introduced the paper clip office assistant and contained standard VBA. It even introduced the now-removed Natural Language labels

Excel 9.0 in 1999 was included in Office 2000: It introduced the upgrade to the clipboard where it can hold multiple objects at once.

Excel 10.0 in 2001 was included in Office XP had only very minor enhancements.

Excel 11.0 in 2003 was included in Office 2003 with Minor enhancements and with new Tables

Excel 12.0 in 2007 was included in Office 2010 that came with new ribbon and even included Smart Art. With this version new file formats were introduced like .xlsm for a workbook with macros and .xlsx for a workbook without macros.

Excel 14.0 in 2010 was included in Office 2010 for Windows 7, with minor enhancements included,  Multi-threading recalculation (MTR) , Improved pivot tables, Additional image editing capabilities, In-cell charts called spark lines, Ability to customize the Ribbon etc.

Excel 15.0 in 2013 was included in Office 2013 with a lot of new tools like Flash Fill, PowerView, PowerPivot, Timeline Slicer etc.

For Mac OS

  • Excel 1.0 in 1985
  • Excel 3.0 in 1990
  • Excel 5.0  was released as part of Office 4.X for Motorola 68000 version and first PowerPC version
  • Excel 8.0  in 1998 was a part of Office 98
  • Excel 9.0 in 2000 as part of Office 2001
  • Excel 10.0 in 2001 as the part of Office v. X
  • Excel 11.0 was released in 2004 as part of Office 2004
  • Excel 12.0 was introduced in 2008 in the Office 2008 package
  • Excel 14.0 came out in 2011 part of Office 2011
Safe and Secure
Safe and Secure