NationMaster - Encyclopedia: Microsoft Excel

Microsoft Excel (full name Microsoft Office Excel) is a spreadsheet application written and distributed by Microsoft for Microsoft Windows and Mac OS. It features calculation and graphing tools which, along with aggressive marketing, have made Excel one of the most popular microcomputer applications to date. It is overwhelmingly the dominant spreadsheet application available for these platforms and has been so since version 5 in 1993 and its bundling as part of Microsoft Office. Image File history File links No higher resolution available. ... Image File history File links Download high-resolution version (1080x634, 132 KB) Microsoft Office Excel 2007 Part of my Office 2007 Screenshots Project. ... Software development is the translation of a user need or marketing goal into a software product. ... Microsoft Corporation, (NASDAQ: MSFT, HKSE: 4338) is a multinational computer technology corporation with global annual revenue of US$44. ... A software release is the distribution, whether public or private, of an initial or new and upgraded version of a computer software product. ... // An operating system (OS) is the software that manages the sharing of the resources of a computer. ... Windows redirects here. ... Computer software can be organized into categories based on common function, type, or field of use. ... A spreadsheet is a rectangular table (or grid) of information, often financial information. ... A software license is a legal agreement which may take the form of a proprietary or gratuitous license as well as a memorandum of contract between a producer and a user of computer software. ... It has been suggested that closed source be merged into this article or section. ... A software license is a type of proprietary or gratiuitious license as well as a memorandum of contract between a producer and a user of computer software — sometimes called an End User License Agreement (EULA) — that specifies the perimeters of the permission granted by the owner to the... A website (alternatively, Web site or web site) is a collection of Web pages, images, videos and other digital assets that is hosted on one or several Web server(s), usually accessible via the Internet, cell phone or a LAN. A Web page is a document, typically written in HTML... Image File history File links Microsoft_Excel_10_icon. ... Software development is the translation of a user need or marketing goal into a software product. ... Microsoft Corporation, (NASDAQ: MSFT, HKSE: 4338) is a multinational computer technology corporation with global annual revenue of US$44. ... A software release is the distribution, whether public or private, of an initial or new and upgraded version of a computer software product. ... is the 128th day of the year (129th in leap years) in the Gregorian calendar. ... Year 2007 (MMVII) is the current year, a common year starting on Monday of the Gregorian calendar and the AD/CE era. ... A software release is the distribution, whether public or private, of an initial or new and upgraded version of a computer software product. ... // An operating system (OS) is the software that manages the sharing of the resources of a computer. ... Mac OS X (IPA: ) is a line of graphical operating systems developed, marketed, and sold by Apple Inc. ... A software license is a legal agreement which may take the form of a proprietary or gratuitous license as well as a memorandum of contract between a producer and a user of computer software. ... It has been suggested that closed source be merged into this article or section. ... A software license is a type of proprietary or gratiuitious license as well as a memorandum of contract between a producer and a user of computer software — sometimes called an End User License Agreement (EULA) — that specifies the perimeters of the permission granted by the owner to the... A website (alternatively, Web site or web site) is a collection of Web pages, images, videos and other digital assets that is hosted on one or several Web server(s), usually accessible via the Internet, cell phone or a LAN. A Web page is a document, typically written in HTML... A spreadsheet is a rectangular table (or grid) of information, often financial information. ... Microsoft Corporation, (NASDAQ: MSFT, HKSE: 4338) is a multinational computer technology corporation with global annual revenue of US$44. ... Windows redirects here. ... This article or section does not adequately cite its references or sources. ... Year 1993 (MCMXCIII) was a common year starting on Friday (link will display full 1993 Gregorian calendar). ... Microsoft Office is an office suite from Microsoft, which is available on the Microsoft Windows and Apple Mac OS X operating systems. ...

History

Microsoft originally marketed a spreadsheet program called Multiplan in 1982, which was very popular on CP/M systems, but on MS-DOS systems it lost popularity to Lotus 1-2-3. This promoted development of a new spreadsheet called Excel which started with the intention to, in the words of Doug Klunder, 'do everything 1-2-3 does and do it better' . The first version of Excel was released for the Mac in 1985 and the first Windows version (numbered 2.0 to line-up with the Mac and bundled with a run-time Windows environment) was released in November 1987. Lotus was slow to bring 1-2-3 to Windows and by 1988 Excel had started to outsell 1-2-3 and helped Microsoft achieve the position of leading PC software developer. This accomplishment, dethroning the king of the software world, solidified Microsoft as a valid competitor and showed its future of developing graphical software. Microsoft pushed its advantage with regular new releases, every two years or so. The current version for the Windows platform is Excel 12, also called Microsoft Office Excel 2007. The current version for the Mac OS X platform is Microsoft Excel 2004. Categories: Computer stubs | Spreadsheets | Domain-specific programming languages | Numerical programming languages ... CP/M was an operating system originally created for Intel 8080/85 based microcomputers by Gary Kildall of Digital Research, Inc. ... Microsofts disk operating system, MS-DOS, was Microsofts implementation of DOS, which was the first popular operating system for the IBM PC, and until recently, was widely used on the PC compatible platform. ... Lotus 1-2-3 is a spreadsheet program from Lotus Software (now part of IBM). ... Year 1985 (MCMLXXXV) was a common year starting on Tuesday (link displays 1985 Gregorian calendar). ... Year 1987 (MCMLXXXVII) was a common year starting on Thursday (link displays 1987 Gregorian calendar). ... Year 1988 (MCMLXXXVIII) was a leap year starting on Friday (link displays 1988 Gregorian calendar). ...

Early in its life Excel became the target of a trademark lawsuit by another company already selling a software package named "Excel" in the finance industry. As the result of the dispute Microsoft was required to refer to the program as "Microsoft Excel" in all of its formal press releases and legal documents. However, over time this practice has been ignored, and Microsoft cleared up the issue permanently when they purchased the trademark to the other program. Microsoft also encouraged the use of the letters XL as shorthand for the program; while this is no longer common, the program's icon on Windows still consists of a stylized combination of the two letters, and the file extension of the default Excel format is .xls. Image File history File links No higher resolution available. ... Image File history File links No higher resolution available. ... Windows 2. ... Nuvola icons for KDE are available as PNG images, which come in six sizes, and SVG images, which are scalable On computer displays, a computer icon is a small pictogram. ... A filename extension or filename suffix is an extra set of (usually) alphanumeric characters that is appended to the end of a filename to allow computer users (as well as various pieces of software on the computer system) to quickly determine the type of data stored in the file. ...

Excel offers many user interface tweaks over the earliest electronic spreadsheets; however, the essence remains the same as in the original spreadsheet, VisiCalc: the cells are organized in rows and columns, and contain data or formulas with relative or absolute references to other cells. Image File history File links No higher resolution available. ... Image File history File links No higher resolution available. ... The user interface is the part of a system exposed to users. ... VisiCalc was the first spreadsheet program available for personal computers. ...

Excel was the first spreadsheet that allowed the user to define the appearance of spreadsheets (fonts, character attributes and cell appearance). It also introduced intelligent cell recomputation, where only cells dependent on the cell being modified are updated (previous spreadsheet programs recomputed everything all the time or waited for a specific user command). Excel has extensive graphing capabilities.

When first bundled into Microsoft Office in 1993, Microsoft Word and Microsoft PowerPoint had their GUIs redesigned for consistency with Excel, the killer app on the PC at the time. Microsoft Office is an office suite from Microsoft, which is available on the Microsoft Windows and Apple Mac OS X operating systems. ... Year 1993 (MCMXCIII) was a common year starting on Friday (link will display full 1993 Gregorian calendar). ... Microsoft Word is a word processing application from Microsoft. ... Microsoft Office PowerPoint is a presentation program developed by Microsoft for its Microsoft Office system. ... GUI can refer to the following: GUI is short for graphical user interface, a term used to describe a type of interface in computing. ... A killer application (commonly shortened to killer app) is a computer program that is so useful that people will buy a particular computer hardware, gaming console, and/or an operating system simply to run that program. ... This article or section does not cite its references or sources. ...

Since 1993, Excel has included Visual Basic for Applications (VBA), a programming language based on Visual Basic which adds the ability to automate tasks in Excel and to provide user defined functions (UDF) for use in worksheets. VBA is a powerful addition to the application which, in later versions, includes a fully featured integrated development environment (IDE). Macro recording can produce VBA code replicating user actions, thus allowing simple automation of regular tasks. VBA allows the creation of forms and in-worksheet controls to communicate with the user. The language supports use (but not creation) of ActiveX (COM) DLL's; later versions add support for class modules allowing the use of basic object-oriented programming techniques. Image File history File links No higher resolution available. ... Image File history File links No higher resolution available. ... // Description Visual Basic for Applications (VBA) is an implementation of Microsofts Visual Basic, an event driven programming language and associated development environment which is built into most Microsoft Office applications (including Apple Mac OS versions), some other Microsoft applications such as Microsoft MapPoint and Microsoft Visio - a former independent... This article is about the Visual Basic language shipping with Microsoft Visual Studio 6. ... This article or section does not cite any references or sources. ... Component Object Model (COM) is a platform for software componentry introduced by Microsoft in 1993. ... Component Object Model (COM) is a platform for software componentry introduced by Microsoft in 1993. ... Dynamic-link library (also written without the hyphen), or DLL, is Microsofts implementation of the shared library concept in the Microsoft Windows and OS/2 operating systems. ... Object-oriented programming (OOP) is a programming paradigm that uses objects to design applications and computer programs. ...

The automation functionality provided by VBA has caused Excel to become a target for macro viruses. This was a serious problem in the corporate world until antivirus products began to detect these viruses. Microsoft belatedly took steps to prevent the misuse by adding the ability to disable macros completely, to enable macros when opening a workbook or to trust all macros signed using a trusted certificate. A macro in computer science is an abstraction, that defines how a certain input pattern is replaced by an output pattern according to a defined set of rules. ... A computer virus is a computer program that can copy itself and infect a computer without permission or knowledge of the user. ... Microsoft Corporation, (NASDAQ: MSFT, HKSE: 4338) is a multinational computer technology corporation with global annual revenue of US$44. ...

Versions 5.0 to 9.0 of Excel contain various Easter eggs, although since version 10 Microsoft has taken measures to eliminate such undocumented features from their products. A virtual Easter egg is a hidden message or feature in an object such as a movie, book, CD, DVD, computer program, or video game. ... Microsoft Corporation, (NASDAQ: MSFT, HKSE: 4338) is a multinational computer technology corporation with global annual revenue of US$44. ...

Versions

Versions for Microsoft Windows include: Image File history File links Size of this preview: 800 Ã— 578 pixelsFull resolution (1032 Ã— 745 pixel, file size: 48 KB, MIME type: image/png) This screenshot shows Microsoft Excel 97 being run on Windows XP. File history Legend: (cur) = this is the current file, (del) = delete this old version, (rev... Image File history File links Size of this preview: 800 Ã— 578 pixelsFull resolution (1032 Ã— 745 pixel, file size: 48 KB, MIME type: image/png) This screenshot shows Microsoft Excel 97 being run on Windows XP. File history Legend: (cur) = this is the current file, (del) = delete this old version, (rev... Image File history File links Size of this preview: 800 Ã— 499 pixelsFull resolution (1280 Ã— 798 pixel, file size: 120 KB, MIME type: image/jpeg) Microsoft Excel running under Windows XP Home Edition This is a screenshot of copyrighted computer software, and the copyright for its contents is most likely held... Image File history File links Size of this preview: 800 Ã— 499 pixelsFull resolution (1280 Ã— 798 pixel, file size: 120 KB, MIME type: image/jpeg) Microsoft Excel running under Windows XP Home Edition This is a screenshot of copyrighted computer software, and the copyright for its contents is most likely held... Image File history File links Excel_2003. ... Image File history File links Excel_2003. ... Windows redirects here. ...

Versions for the Apple Macintosh include: Year 1987 (MCMLXXXVII) was a common year starting on Thursday (link displays 1987 Gregorian calendar). ... Year 1990 (MCMXC) was a common year starting on Monday (link displays the 1990 Gregorian calendar). ... Year 1992 (MCMXCII) was a leap year starting on Wednesday (link will display full 1992 Gregorian calendar). ... Year 1993 (MCMXCIII) was a common year starting on Friday (link will display full 1993 Gregorian calendar). ... Windows NT is a family of operating systems produced by Microsoft, the first version of which was released in July 1993. ... Year 1995 (MCMXCV) was a common year starting on Sunday (link will display full 1995 Gregorian calendar). ... For the band, see 1997 (band). ... This article is about the year. ... Year 2001 (MMI) was a common year starting on Monday (link displays the 2001 Gregorian calendar). ... Year 2003 (MMIII) was a common year starting on Wednesday of the Gregorian calendar. ... Year 2007 (MMVII) is the current year, a common year starting on Monday of the Gregorian calendar and the AD/CE era. ... Windows 95 is a consumer-oriented graphical user interface-based operating system. ... Object Linking and Embedding (OLE) is a technology that allows embedding and linking to documents and other objects, developed by Microsoft. ... The first Macintosh computer, introduced in 1984, upgraded to a 512K Fat Mac. The Macintosh or Mac, is a line of personal computers designed, developed, manufactured, and marketed by Apple Computer. ...

Versions for OS/2 include: Year 1985 (MCMLXXXV) was a common year starting on Tuesday (link displays 1985 Gregorian calendar). ... Year 1988 (MCMLXXXVIII) was a leap year starting on Friday (link displays 1988 Gregorian calendar). ... Year 1989 (MCMLXXXIX) was a common year starting on Sunday (link displays 1989 Gregorian calendar). ... Year 1990 (MCMXC) was a common year starting on Monday (link displays the 1990 Gregorian calendar). ... Year 1992 (MCMXCII) was a leap year starting on Wednesday (link will display full 1992 Gregorian calendar). ... Year 1993 (MCMXCIII) was a common year starting on Friday (link will display full 1993 Gregorian calendar). ... Year 1998 (MCMXCVIII) was a common year starting on Thursday (link will display full 1998 Gregorian calendar). ... Year 2000 (MM) was a leap year starting on Saturday (link will display full 2000 Gregorian calendar). ... Year 2001 (MMI) was a common year starting on Monday (link displays the 2001 Gregorian calendar). ... Year 2004 (MMIV) was a leap year starting on Thursday of the Gregorian calendar. ... Office 2004 for Mac is the current version of Microsoft Office developed for Apples Mac OS X operating system. ... 2008 (MMVIII) will be a leap year starting on Tuesday of the Gregorian calendar. ... Office 2008 for Mac is the name of the upcoming Microsoft Office suite being developed by Microsofts Macintosh Business Unit which will supersede Office 2004 for Mac. ... To meet Wikipedias quality standards, this article or section may require cleanup. ...

Year 1989 (MCMLXXXIX) was a common year starting on Sunday (link displays 1989 Gregorian calendar). ... Year 1991 (MCMXCI) was a common year starting on Tuesday (link will display the 1991 Gregorian calendar). ...

File formats

Microsoft Excel up until 2007 version used a proprietary binary file format called Binary Interchange File Format (BIFF) as its primary format^[1]. Excel 2007 uses Office Open XML as its primary file format, an XML-based container similar in design to XML-based format called "XML Spreadsheet" ("XMLSS"), first introduced in Excel 2002^[2]. The latter format is not able to encode VBA macros. Not to be confused with OpenOffice. ... The Extensible Markup Language (XML) is a general-purpose markup language. ...

Although supporting and encouraging the use of new XML-based formats as replacements, Excel 2007 is still backwards compatible with the traditional, binary, formats. In addition, most versions of Microsoft Excel are able to read CSV, DBF, SYLK, DIF, and other legacy formats. The comma-separated values (or CSV; also known as a comma-separated list or comma-separated variables) file format is a file type that stores tabular data. ... dBASE III The correct title of this article is dBASE. The initial letter is capitalized because of technical restrictions. ... Symbolic Link (SYLK) is a Microsoft file format typically used to exchange data between applications, specifically spreadsheets. ... Is a text file for exchange (import/export) single table oriented data between database programs (Excel, StarCalc, Lotus 1-2-3, FileMaker, dBase, Framework, Multiplan, etc. ...

Microsoft Excel 2007 Office Open XML formats

Microsoft Excel 2007, along with the other products in the Microsoft Office 2007 suite, introduces a host of new file formats. These are part of the Office Open XML (OOXML) specification. Not to be confused with OpenOffice. ... The 2007 Microsoft Office system (also called Microsoft Office 2007) is the most recent version of Microsofts productivity suite. ... Not to be confused with OpenOffice. ...

The ZIP file format is a popular data compression and archival format. ... The Extensible Markup Language (XML) is a general-purpose markup language. ... A macro in computer science is an abstraction, that defines how a certain input pattern is replaced by an output pattern according to a defined set of rules. ...

Exporting and Migration of spreadsheets

API's are also provided to open excel spreadsheets in a variety of other applications and environments other than Microsoft Excel. These include opening excel documents on the web using either ActiveX controls,or plugins like the Adobe Flash Player. Attempts have also been made to be able to copy excel spreadsheets to web applications using comma-separated values. API may refer to: In computing, application programming interface In petroleum industry, American Petroleum Institute In education, Academic Performance Index This page concerning a three-letter acronym or abbreviation is a disambiguation page â€” a navigational aid which lists other pages that might otherwise share the same title. ... ActiveX is a series of high-level, Internet/Intranet technologies Microsoft introduced in late 1990s. ... It has been suggested that this article be split into articles entitled Adobe Flash Player and Talk:Adobe Flash #Merger proposal, accessible from a disambiguation page. ... The comma-separated values (or CSV; also known as a comma-separated list or comma-separated variables) file format is a file type that stores tabular data. ...

Criticism

Due to Excel's foundation on floating point calculations, the statistical accuracy of Excel has been criticized^[3]^[4]^[5]^[6], as has the lack of certain statistical tools. Excel proponents have responded that some of these errors represent edge cases and that the relatively few users who would be affected by these know of them and have workarounds and alternatives.^{[citation needed]} A floating-point number is a digital representation for a number in a certain subset of the rational numbers, and is often used to approximate an arbitrary real number on a computer. ... An edge case is a problem or situation that occurs only at an extreme (maximum or minimum) operating parameter. ...

Excel incorrectly assumes that 1900 is a leap year^[7]^[8]. The bug originated from Lotus 1-2-3, and was implemented in Excel for the purpose of backward compatibility^[9]. This legacy has later been carried over into Office Open XML file format. Excel also supports the second date format based on year 1904 epoch. A leap year (or intercalary year) is a year containing an extra day (or, in case of lunisolar calendars, an extra month) in order to keep the calendar year synchronised with the astronomical or seasonal year. ... Lotus 1-2-3 is a spreadsheet program from Lotus Software (now part of IBM). ... This article or section does not cite its references or sources. ... Not to be confused with OpenOffice. ... In chronology, an epoch (or epochal date, or epochal event) means an instant in time chosen as the origin of a particular era. ...

See also

The following tables provide a comparison of desktop spreadsheet applications. ... The following is a list of spreadsheets. ... In chronology, an epoch (or epochal date, or epochal event) means an instant in time chosen as the origin of a particular era. ...

References

External links

Categories: All articles with unsourced statements | Articles with unsourced statements since April 2007 | Domain-specific programming languages | Mac OS software | Mac OS X software | Microsoft Office | Numerical programming languages | Spreadsheets Image File history File links Wikibooks-logo-en. ... Wikibooks logo Wikibooks, previously called Wikimedia Free Textbook Project and Wikimedia-Textbooks, is a wiki for the creation of books. ... Microsoft Office is an office suite from Microsoft, which is available on the Microsoft Windows and Apple Mac OS X operating systems. ... Microsoft Office Accounting (formerly Small Business Accounting) is Microsofts accounting software targeted towards small business customers. ... This article does not cite any references or sources. ... Microsoft Office Communicator is an integrated enterprise communications client, enabling information workers to communicate in real time through the use of instant messaging (IM), voice over Internet protocol (VoIP) and videoconferencing and could be applied to when speaking with company directors and other persons of influence in a corporation. ... Microsoft Office Document Imaging (MODI) is a Microsoft Office application that supports editing documents scanned by Microsoft Office Document Scanning. ... This article is considered orphaned, since there are very few or no other articles that link to this one. ... Microsoft Entourage is an e-mail client and personal information manager developed by Microsoft for Mac OS 8. ... Equation Editor is a program developed by Design Science that allows users to construct math and science equations in a WYSIWYG environment. ... Microsoft Office Groove - Wikipedia, the free encyclopedia /**/ @import /skins-1. ... Microsoft Office 2003 InfoPath - Basic Information Microsoft Infopath is a tool used to develop XML based user forms that can be distributed through a network so that user information can be quickly and easily obtained and stored. ... Microsoft InterConnect, or Microsoft Office InterConnect, is a personal information manager application sold by Microsoft Japan, a division of Microsoft. ... Three maps generated by MapPoint North America 2001 (outside the detailed dataset), Encarta 2005 (not very detailed) and Microsoft AutoRoute 2004 (highly detailed). ... Microsoft Office OneNote, usually referred to as Microsoft OneNote, is a tool for notetaking, information gathering, and multi-user collaboration by Microsoft. ... Microsoft Outlook or Outlook (full name Microsoft Office Outlook since Outlook 2003) is a personal information manager from Microsoft, and is part of the Microsoft Office suite. ... Microsoft Office Picture Manager is a software program included with Microsoft Office suite for Windows 2003 and later. ... Microsoft Office PowerPoint is a presentation program developed by Microsoft for its Microsoft Office system. ... Microsoft Project (or MSP) is a project management software program developed and sold by Microsoft which is designed to assist project managers in developing plans, assigning resources to tasks, tracking progress, managing budgets and analyzing workloads. ... Microsoft Publisher is a desktop publishing application from Microsoft. ... Microsoft SharePoint Designer (full name Microsoft Office SharePoint Designer) is a WYSIWYG HTML editor and general web design program from Microsoft, replacing Microsoft Office FrontPage. ... Microsoft Visio is diagramming software for Microsoft Windows. ... Microsoft Word is Microsofts flagship word processing software. ... Microsoft Office Live Communications Server is described by Microsoft as an enterprise real-time communications server, providing instant messaging and collaboration functionality. ... Microsoft Office Forms Server 2007 allows InfoPath forms to be accessed and filled out using any browser, including mobile phone browsers. ... Microsoft Office Groove - Wikipedia, the free encyclopedia /**/ @import /skins-1. ... The 2007 Microsoft Office system (also called Microsoft Office 2007) is the most recent version of Microsofts productivity suite. ... Microsoft Office Project Server is a project management server solution made by Microsoft. ... REDIRECT [1] Categories: | ... It has been suggested that this article or section be merged with Microsoft Office SharePoint Server 2007. ... Microsoft Office Live Meeting is a web conferencing service operated by Microsoft. ... Microsoft Office Live is an Internet-based software service designed for small businesses with fewer than ten employees launched on February 15, 2006,[1] and is part of Microsofts Windows Live initiative. ... Screenshot from Binder Microsoft Binder was an application included with Microsoft Office designed to allow users to include several different types of files (e. ... Microsoft Data Analyzer was a data analysis software for Microsoft Office XP. Even though it was a stand alone application and was not available in any Office XP bundle, it was a part of the Office XP suite. ... Microsoft FrontPage (later full name Microsoft Office FrontPage) is a WYSIWYG HTML editor and web site administration tool from Microsoft for the Microsoft Windows line of operating systems. ... Microsoft Mail for PC Networks is a file-based E-mail system intended for corporate usage. ... Clippit asking if you need help The Office Assistant was a feature included in Microsoft Office 97 and subsequent versions until Office 2007, in which the assistants have been removed due to widespread dissatisfaction on the part of Office users. ... Microsoft PhotoDraw version 2 box Microsoft PhotoDraw 2000 is a vector graphics and raster imaging software package developed by Microsoft. ... Microsoft Photo Editor was an image-editing application found in some versions of the Microsoft Office suite. ... Microsoft Schedule Plus (or Microsoft Schedule+) was a time management software product by Microsoft, but was discontinued as part of Office when its functionality was incorporated into Outlook 97. ... Microsoft Vizact 2000 box Microsoft Vizact 2000 is a program that activated documents using HTML, adding effects such as animation. ...

Encyclopedia > Microsoft Excel

Contents