MICROSOFT OFFICE EXCEL

Microsoft Excel or Microsoft Office Excel is a spreadsheet application program written and distributed by Microsoft for Microsoft Windows operating system and Mac OS. This application features calculation and graphics devices, using Microsoft's aggressive marketing strategy, make Microsoft Excel as one of the most popular computer programs used on microcomputers, which until now. Even today this program is the spreadsheet program most commonly used by many parties, both on the PC platform based on Windows or Mac OS-based Macintosh platform, since version 5.0 was published in 1993. This application is part of the Microsoft Office System, and the final version is a version of Microsoft Office Excel 2007 that is integrated in Microsoft Office System 2007 package.

History

In 1982, Microsoft made a spreadsheet program called Multiplan, which is very popular in the system CP / M, but not in MS-DOS systems because it was already standing rival, Lotus 1-2-3. This makes Microsoft began developing a new spreadsheet program called Excel, with purpose, as we are told by Doug Klunder, "1-2-3 does not do everything and do it better / do what was done by the 1-2-3 and more good again. "

The first version of Excel was released for the Macintosh in 1985 and follows its Windows version (version number 2.0) in November 1987. Lotus to market too late for a spreadsheet program for Windows, and in the year, Lotus 1-2-3 is still based on MS-DOS. In 1988, Excel began to shift in market share and the 1-2-3 spreadsheet program to make Microsoft as one of the largest developers of software applications for personal computers that can be relied upon. Microsoft has confirmed that this achievement as a very strong competitor for the 1-2-3 and they develop it better. Microsoft, using its superiority, the average release a new version of Excel once every two years, and the latest version of Excel for Windows is Microsoft Office Excel 2007 (Excel 12), while for the Macintosh (Mac OS X), is the latest version of Microsoft Excel 2004 .

At the initial launch, Excel became the target demands by another company in the financial sector has been selling a software package named "Excel. Finally, Microsoft will end with the defeat of the demands and Microsoft Excel have to change the name as" Microsoft Excel "in all Microsoft and press releases documents. However, in practice, this is ignored and even Microsoft Excel buy from companies that previously required them, so the use of Excel name alone will not bring any more trouble. Microsoft also often use the letters XL as shorthand for the program, which, although not common anymore, icons used by the program still consists of two letters (although given some of the style of writing). In addition, the default extension of spreadsheets created by Microsoft Excel is *. xls.

Excel interface offers many advantages when compared with a spreadsheet program that preceded it, but the essence remains the same as VisiCalc (spreadsheet software was first known): Tue arranged in rows and columns, and contain contain data or formulas with relative or absolute references to other cells.

Excel is the first spreadsheet program that allows users to determine how they view the spreadsheet edit: fonts, character attributes, and appearance of each cell. Excel also offers a recount of bright cells, where only cells associated with cells that will be updated nilanya (where other spreadsheet programs will recalculate the entire data or waiting for special instructions from the user). In addition, Excel also offers graphics processing features are very good.

When first bundled into Microsoft Office 1993, Microsoft redesigned the user interface used by Microsoft Word and Microsoft PowerPoint to match the look of Microsoft Excel, which at that time became the most popular spreadsheet application.

Since 1993, Excel has a Visual Basic for Applications (VBA), which can add the ability to automate Excel in Excel and also add a function that can be defined by the user (user-defined function / UDF) for use in the worksheet. In the next version, even Microsoft adds an integrated development environment (IDE) for language VBA for Excel, which allows the programmer to do making a homemade program. In addition, Excel can also record everything done by the user to be a macro, so it can do some automation tasks. VBA also allows to create forms and controls contained in the worksheet to be able to communicate with the user. VBA language also supports the use of ActiveX DLL / COM, but can not.The next version adds support for VBA class module that allows the use of object-oriented programming techniques in VBA.

Automation functions provided by VBA to make Excel macro viruses as a target. This is a serious problem in the corporate world until antivirus makers began to add support to detect and clean macro viruses from an Excel file. Finally, belatedly, Microsoft is also integrating the function to prevent abuse of macros to disable the macros as a whole, or menngaktifkan enable macros when the workbook, or trust macros are encrypted using a trusted digital certificates.