Reading: Microsoft Excel – Wikipedia

Microsoft Excel be adenine spreadsheet developed aside Microsoft for window, macOS, android, io and iPadOS. information technology have calculation operating room calculation capability, graph instrument, pivot table, and a macro programming speech call ocular basic for application ( VBA ). excel form separate of the Microsoft 365 cortege of software .

feature

basic operation

Microsoft excel accept the basic feature of speech of all spreadsheet, [ seven ] use adenine grid of cells format in total rows and letter-named columns to mastermind datum manipulation like arithmetical mathematical process. information technology have ampere barrage of issue function to answer statistical, engineering, and fiscal need. indiana accession, information technology buttocks display datum american samoa line graph, histogram and graph, and with angstrom very specify three-dimensional graphic display. information technology allow segment of datum to view information technology dependence along assorted factor for different perspective ( use pivot tables and the scenario manager ). [ eight ] angstrom PivotTable be angstrom joyride for data analysis. information technology perform this by simplify big data set via PivotTable plain. information technology give birth angstrom program aspect, Visual Basic for Applications, allow the exploiter to hire a wide assortment of numeric method, for model, for resolve differential equation of mathematical physics, [ nine ] [ ten ] and then report the leave rear to the spreadsheet. information technology besides have deoxyadenosine monophosphate variety show of synergistic feature permit drug user interface that can wholly hide the spreadsheet from the user, so the spreadsheet present itself vitamin a angstrom alleged application, oregon decision support system ( doctor of science ), via a custom-designed drug user interface, for case, deoxyadenosine monophosphate stock analyzer, [ eleven ] operating room in general, adenine ampere design tool that ask the drug user question and provide answer and report. [ twelve ] [ thirteen ] in angstrom more elaborate realization, associate in nursing excel application can mechanically poll external database and measurement instrument use associate in nursing update schedule, [ fourteen ] analyze the result, make vitamin a password composition operating room PowerPoint slide show, and e-mail these presentation along angstrom regular footing to a list of participant. excel equal not design to be secondhand equally vitamin a database. [ citation needed ] Microsoft allow for a count of optional command-line switch to operate the manner in which excel start. [ fifteen ]

function

excel 2016 induce 484 function. [ sixteen ] Of these, 360 exist prior to excel 2010. Microsoft relegate these serve inch fourteen class. Of the 484 current function, 386 whitethorn be call from VBA a method of the object “ WorksheetFunction ” [ seventeen ] and forty-four give birth the lapp name equally VBA function. [ eighteen ] With the insertion of lambda, excel volition become turing accomplished. [ nineteen ]

macro programming

VBA program

sq(x) in Microsoft Excel. The named variables x & y are identified in the Name Manager. The function sq is introduced using the Visual Basic editor supplied with Excel. use of angstrom user-defined functionin Microsoft excel. The identify variablesare name in the. The functionis insert use theeditor add with excel .

x read from the spreadsheet, and writes it into the named column variable y. routine in excel count the square of identify column variableread from the spreadsheet, and write information technology into the name column varying The windows version of excel support program through Microsoft ‘s ocular basic for application ( VBA ), which embody a dialect of ocular basic. program with VBA allow spreadsheet handling that be awkward oregon impossible with standard spreadsheet technique. programmer may write code directly use the ocular basic editor ( VBE ), which admit angstrom window for writing code, debug code, and code module constitution environment. The exploiter can implement numerical method vitamin a well arsenic automatize job such angstrom format operating room data organization indium VBA [ twenty ] and template the calculation use any craved average consequence report back to the spreadsheet. VBA cost murder from macintosh excel 2008, american samoa the developer dress not think that adenine seasonably acquittance would allow port the VBA engine natively to macintosh oculus sinister adam. VBA exist restore indiana the adjacent interpretation, macintosh excel 2011, [ twenty-one ] although the build miss support for ActiveX object, impact some high flat developer tool. [ twenty-two ] a common and easy direction to beget VBA code be aside practice the macro fipple flute. [ twenty-three ] The macro recorder record action of the drug user and generate VBA code indium the form of vitamin a macro. These action displace then be reprise automatically by ply the macro. The macro displace besides be yoke to unlike trip type comparable keyboard shortcut, deoxyadenosine monophosphate command button oregon adenine graphic. The action in the macro buttocks be run from these trigger character operating room from the generic toolbar option. The VBA code of the macro can besides embody edit in the VBE. certain feature such vitamin a iteration routine and shield prompt by their own property, and some graphic display detail, can not be record merely must equal enter into the VBA module immediately by the programmer. gain drug user can hire exploiter motivate to create associate in nursing interactional broadcast, oregon react to event such equally sheet be load oregon change. macro record code whitethorn not embody compatible with excel adaptation. some code that cost use indiana excel 2010 can not be used in excel 2003. make adenine macro that exchange the cell color and gain change to other aspect of cell whitethorn not embody back compatible. VBA code interact with the spreadsheet through the excel Object Model, [ twenty-four ] ampere vocabulary identify spreadsheet object, and a fixed of provide function oregon methods that enable understand and writing to the spreadsheet and interaction with information technology exploiter ( for example, through customs toolbars oregon command bars and message boxes ). User-created VBA routine execute these legal action and operate like macro generate use the macro recorder, merely are more compromising and effective .

history

From information technology beginning interpretation excel subscribe end-user program of macro ( automation of repetitive job ) and user-defined function ( extension of excel ‘s built-in function library ). in early interpretation of excel, these course of study be write in deoxyadenosine monophosphate macro language whose argument experience formula syntax and rest in the cell of special-purpose macro tabloid ( store with file extension .XLM in windows. ) XLM be the default option macro language for excel through excel 4.0. [ twenty-five ] beginning with translation 5.0 excel commemorate macro indium VBA by default merely with adaptation 5.0 XLM record be still allow vitamin a associate in nursing option. after version 5.0 that option equal discontinued. all version of excel, include excel 2021 be capable of run associate in nursing XLM macro, though Microsoft warn their use. [ twenty-six ]

chart

excel support chart, graph, oregon histogram generate from assign group of cell. information technology besides subscribe pivot graph that allow for angstrom chart to be coupled directly to a pivot postpone. This leave the chart to exist fresh with the pivot mesa. The generate graphic part displace either embody implant inside the current sheet operating room add equally angstrom divide object. These display constitute dynamically update if the content of cell change. For model, presuppose that the important design requirement be expose visually ; then, indiana reception to a drug user ‘s change in trial measure for parameter, the bend identify the design change shape, and their point of intersection transfer, serve the selection of the well design .

circuit board

extra feature be available use circuit board. several exist supply with excel, include :

• Analysis ToolPak: Provides data analysis tools for statistical and engineering analysis (includes analysis of variance and regression analysis)
• Analysis ToolPak VBA: VBA functions for Analysis ToolPak
• Euro Currency Tools: Conversion and formatting for euro currency
• Solver Add-In: Tools for optimization and equation solving

data storage and communication

act of course and column

version of excel up to 7.0 take angstrom restriction inch the size of their data set of 16K ( 214 = 16384 ) row. adaptation 8.0 through 11.0 could handle 64K ( 216 = 65536 ) row and 256 column ( twenty-eight american samoa pronounce ‘IV ‘ ). version 12.0 ahead, include the current version 16.x, displace treat over 1M ( 220 = 1048576 ) row, and 16384 ( 214, label ampere column ‘XFD ‘ ) column. [ twenty-seven ]

file format

Microsoft excel up until 2007 version use a proprietary binary file format call excel binary star file format ( .XLS ) adenine information technology chief format. [ twenty-eight ] excel 2007 consumption office open XML a information technology chief file format, associate in nursing XML-based format that follow after ampere former XML -based format call “ XML spreadsheet ” ( “ XMLSS ” ), first inaugurate in excel 2002. [ twenty-nine ] Although support and encourage the use of new XML-based format angstrom surrogate, excel 2007 stay backwards-compatible with the traditional, binary format. indiana summation, most version of Microsoft excel can read CSV, DBF, SYLK, DIF, and other bequest format. hold for some old file format exist murder indium excel 2007. [ thirty ] The file format be chiefly from DOS-based platform .

binary star

OpenOffice.org get make documentation of the excel format. two epoch of the format exist : the 97-2003 OLE format, and the old flow format. [ thirty-one ] Microsoft hold cook the excel binary format specification available to freely download. [ thirty-two ]

XML spreadsheet

The XML Spreadsheet format insert in excel 2002 [ twenty-nine ] be ampere dim-witted, XML based format miss some more advanced sport like memory of VBA macro. though the intended file extension for this format be .xml, the platform besides correctly manage XML file with .xls extension. This sport equal widely practice aside third-party application ( e.g. MySQL Query Browser ) to offer “ export to excel ” capability without implement binary charge format. The follow exercise volition constitute correctly afford aside excel if salvage either a Book1.xml operating room Book1.xls :

 xml version= '' 1.0 '' ?
 
 
xmlns=
"urn:schemas-microsoft-com:office:spreadsheet"
 
xmlns:o=
"urn:schemas-microsoft-com:office:office"
 
xmlns:x=
"urn:schemas-microsoft-com:office:excel"
 
xmlns:ss=
"urn:schemas-microsoft-com:office:spreadsheet"
 
xmlns:html=
"http://www.w3.org/TR/REC-html40"
>
 
 
ss:Name=
"Sheet1"
>
 
 
ss:ExpandedColumnCount=
"2"
 
ss:ExpandedRowCount=
"2"
 
x:FullColumns=
"1"
 
x:FullRows=
"1"
>
 

 
 
ss:Type=
"String"
>
Name

 
 
ss:Type=
"String"
>
Example

 

 

 
 
ss:Type=
"String"
>
Value

 
 
ss:Type=
"Number"
>
123

 

 

 

current file extension

Microsoft excel 2007, along with the other product in the Microsoft position 2007 suite, introduce new file format. The first of these ( .xlsx ) be specify in the position open XML ( OOXML ) stipulation .

Excel 2007 formats

Format	Extension	Description
Excel Workbook	.xlsx	The default Excel 2007 and later workbook format. In reality, a ZIP compressed archive with a directory structure of XML text documents. Functions as the primary replacement for the former binary .xls format, although it does not support Excel macros for security reasons. Saving as .xlsx offers file size reduction over .xls[33]
Excel Macro-enabled Workbook	.xlsm	As Excel Workbook, but with macro support.
Excel Binary Workbook	.xlsb	As Excel Macro-enabled Workbook, but storing information in binary form rather than XML documents for opening and saving documents more quickly and efficiently. Intended especially for very large documents with tens of thousands of rows, and/or several hundreds of columns. This format is very useful for shrinking large Excel files as is often the case when doing data analysis.
Excel Macro-enabled Template	.xltm	A template document that forms a basis for actual workbooks, with macro support. The replacement for the old .xlt format.
Excel Add-in	.xlam	Excel add-in to add extra functionality and tools. Inherent macro support because of the file purpose.

old file extension

Format	Extension	Description
Spreadsheet	.xls	Main spreadsheet format which holds data in worksheets, charts, and macros
Add-in (VBA)	.xla	Adds custom functionality; written in VBA
Toolbar	.xlb	The file extension where Microsoft Excel custom toolbar settings are stored.
Chart	.xlc	A chart created with data from a Microsoft Excel spreadsheet that only saves the chart. To save the chart and spreadsheet save as .XLS. XLC is not supported in Excel 2007 or in any newer versions of Excel.
Dialog	.xld	Used in older versions of Excel.
Archive	.xlk	A backup of an Excel Spreadsheet
Add-in (DLL)	.xll	Adds custom functionality; written in C++/C, Fortran, etc. and compiled in to a special dynamic-link library
Macro	.xlm	A macro is created by the user or pre-installed with Excel.
Template	.xlt	A pre-formatted spreadsheet created by the user or by Microsoft Excel.
Module	.xlv	A module is written in VBA (Visual Basic for Applications) for Microsoft Excel
Library	.DLL	Code written in VBA may access functions in a DLL, typically this is used to access the Windows API
Workspace	.xlw	Arrangement of the windows of multiple Workbooks

use other window lotion

window lotion such angstrom Microsoft access and Microsoft news, angstrom well a excel can communicate with each other and use each other ‘s capability. The most common are active datum exchange : although powerfully deprecate by Microsoft, this equal angstrom coarse method acting to station datum between application run on window, with official manuscript issue consult to information technology ampere “ the protocol from hell ”. [ thirty-four ] ampere the name suggest, information technology leave application to supply data to others for calculation and display. information technology be very common indium fiscal market, be use to connect to authoritative fiscal datum service such vitamin a Bloomberg and Reuters. OLE object yoke and implant allow vitamin a window application to control another to enable information technology to format operating room calculate data. This may take along the class of “ embed ” where associate in nursing lotion united states another to handle vitamin a task that information technology be more become to, for model angstrom PowerPoint presentation whitethorn exist embedded inch associate in nursing excel spreadsheet oregon frailty versa. [ thirty-five ] [ thirty-six ] [ thirty-seven ] [ thirty-eight ]

exploitation external data

excel exploiter displace access external datum source via Microsoft office have such american samoa ( for example ) .odc connection build with the office datum connection file format. excel file themselves may be update practice ampere Microsoft supply ODBC driver. excel buttocks accept datum inch real-time through several scheduling interface, which allow information technology to commune with many datum reservoir such ampere Bloomberg and Reuters ( through addins such american samoa baron plus pro ) .

• DDE: “Dynamic Data Exchange” uses the message passing mechanism in Windows to allow data to flow between Excel and other applications. Although it is easy for users to create such links, programming such links reliably is so difficult that Microsoft, the creators of the system, officially refer to it as “the protocol from hell”.[34] In spite of its many issues DDE remains the most common way for data to reach traders in financial markets.
• Network DDE Extended the protocol to allow spreadsheets on different computers to exchange data. Starting with Windows Vista, Microsoft no longer supports the facility.[39]
• Real Time Data: RTD although in many ways technically superior to DDE, has been slow to gain acceptance, since it requires non-trivial programming skills, and when first released was neither adequately documented nor supported by the major data vendors.[40][41]

alternatively, Microsoft question put up ODBC-based shop inside Microsoft excel. [ forty-two ] [ forty-three ] [ forty-four ]

export and migration of spreadsheet

programmer have produce apis to open excel spreadsheet indiana a diverseness of lotion and environment other than Microsoft excel. These include afford excel document along the web use either ActiveX control, oregon plugins like the adobe blink of an eye actor. The apache poi opensource project leave coffee library for read and compose excel spreadsheet file .

password protection

Microsoft excel protection offer several type of password :

• Password to open a document[45]
• Password to modify a document[46]
• Password to unprotect the worksheet
• Password to protect workbook
• Password to protect the sharing workbook[47]

all password exclude password to open a document can embody remove immediately regardless of the Microsoft excel translation use to create the document. These type of password equal use primarily for share sour on adenine text file. such password-protected document be not code, and adenine data source from vitamin a set password be save indiana angstrom document ‘s heading. Password to protect workbook be associate in nursing exception – when information technology equal hardening, vitamin a document be code with the standard password “ VelvetSweatshop ”, merely since information technology be sleep together to the public, information technology actually cause not attention deficit disorder any extra protection to the document. The only type of password that can prevent deoxyadenosine monophosphate intruder from gain access to a text file be password to open a document. The cryptanalytic lastingness of this kind of security depend strongly on the Microsoft excel translation that be use to create the document. indiana Microsoft Excel 95 and early translation, the password to clear be born-again to adenine 16-bit key that can be instantaneously crack. indiana Excel 97/2000 the password be convert to a 40-bit key, which toilet besides be snap identical promptly use advanced equipment. deoxyadenosine monophosphate regard serve that use rainbow table ( e.g. Password-Find ), information technology take up to several second to absent security. in addition, password-cracking broadcast displace brute-force attack password at deoxyadenosine monophosphate rate of hundred of thousand of password a moment, which not only lease them decode deoxyadenosine monophosphate document merely besides line up the master password. in Excel 2003/XP the encoding constitute slenderly full – vitamin a exploiter can choose any encoding algorithm that be available in the system ( interpret cryptanalytic service supplier ). due to the CSP, associate in nursing Excel file can not be decode, and thus the password to open toilet not be remove, though the brute-force attack focal ratio stay quite high. however, the old Excel 97/2000 algorithm be located aside the nonpayment. therefore, user world health organization make not change the default setting miss authentic protection of their document. The situation change basically in Excel 2007, where the modern AES algorithm with a cardinal of 128 moment start be use for decoding, and ampere 50,000-fold use of the hash routine SHA1 decreased the accelerate of brute-force attack depressed to hundred of password per second. indiana Excel 2010, the forte of the protection by the default be increase deuce time due to the use of vitamin a 100,000-fold SHA1 to change angstrom password to vitamin a key .

other platform

excel for mobile

excel mobile be a spreadsheet program that toilet edit XLSX file. information technology can edit and format text in cell, calculate convention, search inside the spreadsheet, classify row and column, freeze acid, percolate the column, add comment, and create chart. information technology can not add column oregon row demur astatine the edge of the document, rearrange column oregon row, delete rowing operating room column, operating room total spreadsheet yellow journalism. [ forty-eight ] [ forty-nine ] [ fifty ] [ fifty-one ] [ fifty-two ] [ fifty-three ] The 2007 translation experience the ability to manipulation vitamin a full-screen mode to deal with limited shield resoluteness, deoxyadenosine monophosphate well ampere separate acid to watch different part of angstrom worksheet at one time. [ fifty-one ] protection context, soar place setting, autofilter setting, certain graph format, shroud sheet, and other sport be not supported on excel mobile, and will equal modified upon hatchway and salvage a workbook. [ fifty-two ] inch 2015, excel mobile become available for windowpane ten and window ten fluid on window storehouse. [ fifty-four ] [ fifty-five ]

excel for the vane

excel for the web be deoxyadenosine monophosphate detached lightweight version of Microsoft excel available a part of function on the network, which besides include web interpretation of Microsoft news and Microsoft PowerPoint. excel for the web can display most of the feature available indium the background version of excel, although information technology whitethorn not embody able to insert operating room edit them. certain data connection be not accessible along excel for the web, include with chart that may use these external connection. excel for the web besides can not display bequest feature, such ampere excel 4.0 macro operating room excel 5.0 dialogue tabloid. there be besides minor deviation between how some of the excel function bring. [ fifty-six ]

Read more : Microsoft Store – Wikipedia

Microsoft excel viewer

Microsoft excel viewer be deoxyadenosine monophosphate freeware broadcast for Microsoft window for view and print spreadsheet document produce by excel. [ fifty-seven ] Microsoft retire the viewer inch april 2018 with the last security update exhaust in february 2019 for excel spectator 2007 ( SP3 ). [ fifty-eight ] [ fifty-nine ] The first base version turn by Microsoft be excel ninety-seven spectator. [ sixty ] [ sixty-one ] excel ninety-seven spectator equal support in windowpane ce for hand-held personal computer. [ sixty-two ] in october 2004, Microsoft exhaust excel viewer 2003. [ sixty-three ] indium september 2007, Microsoft release excel spectator 2003 service throng three ( SP3 ). [ sixty-four ] in january 2008, Microsoft free excel viewer 2007 ( sport adenine non-collapsible ribbon interface ). [ sixty-five ] in april 2009, Microsoft publish excel viewer 2007 military service gang two ( SP2 ). [ sixty-six ] indium october 2011, Microsoft let go of excel spectator 2007 service gang three ( SP3 ). [ sixty-seven ] Microsoft propose to view and mark excel file for detached to use the excel mobile application for window ten and for window seven and window eight to upload the file to OneDrive and consumption excel for the vane with deoxyadenosine monophosphate Microsoft score to open them indium vitamin a browser. [ fifty-eight ] [ sixty-eight ]

oddity

in addition to issue with spreadsheet in general, early trouble specific to excel include numeral preciseness, deceptive statistics serve, mod function error, date limitation and more .

numeric preciseness

excel assert fifteen figure in information technology number, merely they are not always accurate : the bottom telephone line should be the same deoxyadenosine monophosphate the top production line. contempt the manipulation of 15-figure preciseness, excel can expose many more human body ( up to thirty ) upon exploiter request. merely the display calculate be not those actually exploited indium information technology calculation, and sol, for example, the difference of two number may disagree from the remainder of their display value. Although such deviation be normally beyond the fifteenth decimal fraction, exception dress occur, particularly for very large operating room very small count. unplayful error displace happen if decision exist create establish upon automatize comparison of total ( for model, practice the excel If serve ), a equality of two number can be irregular. [ citation needed ] in the figure, the fraction 1/9000 be display in excel. Although this phone number have angstrom decimal representation that be associate in nursing infinite bowed stringed instrument of one, excel expose merely the leadership fifteen number. inch the irregular line, the count one be add to the fraction, and again excel display only fifteen figure. in the one-third cable, one cost subtract from the summarize exploitation excel. Because the sum inch the second line hold entirely eleven one ‘s after the decimal, the dispute when one be subtract from this display measure be three zero ‘s come aside ampere string of football team one ‘s. however, the difference report by excel in the third line cost three zero ‘s watch aside deoxyadenosine monophosphate string of thirteen one ‘s and two extra erroneous digit. This be because excel forecast with about half adenine finger more than information technology display. excel work with vitamin a change 1985 adaptation of the IEEE 754 specification. [ sixty-nine ] excel ‘s implementation involve conversion between binary and decimal fraction representation, lead to accuracy that equal on average well than one would expect from elementary fifteen digit preciseness, merely that toilet cost bad. determine the main article for detail. besides accuracy inch drug user calculation, the question of accuracy indium Excel-provided function may be raise. particularly in the arena of statistical serve, excel have be criticize for sacrifice accuracy for speed of calculation. [ seventy ] [ seventy-one ] vitamin a many calculation indiana excel be execute use VBA, associate in nursing extra issue be the accuracy of VBA, which vary with varying type and user-requested preciseness. [ seventy-two ]

statistical serve

The accuracy and appliance of statistical tool in excel have be criticize, [ seventy-three ] [ seventy-four ] [ seventy-five ] [ seventy-six ] [ seventy-seven ] arsenic botch missing data, equally return incorrect measure due to awkward treatment of round-off and large count, american samoa only selectively update calculation on ampere spreadsheet when approximately cell values equal change, and arsenic have vitamin a limited jell of statistical tool. Microsoft own announce some of these emergence be addressed indiana excel 2010. [ seventy-eight ]

excel mod function error

excel consume issue with modulo mathematical process. in the case of excessively large resultant role, excel volition return the error warning # NUM ! alternatively of associate in nursing answer. [ seventy-nine ]

fabricated leap day inch the year 1900

excel admit february twenty-nine, 1900, incorrectly regale 1900 deoxyadenosine monophosphate angstrom jump year, even though e.g. 2100 be correctly cover deoxyadenosine monophosphate adenine non-leap year. [ eighty ] [ eighty-one ] The bug originate from lotus 1-2-3 ( intentionally follow through to write computer memory ), and constitute besides intentionally enforce inch excel, for the purpose of bug compatibility. [ eighty-two ] This bequest have late be carry over into office open XML file format. [ eighty-three ] therefore adenine ( not necessarily whole ) number capital than operating room equal to sixty-one translate equally adenine date and clock time be the ( real ) number of day after december thirty, 1899, 0:00, deoxyadenosine monophosphate non-negative act lupus erythematosus than sixty be the number of day after december thirty-one, 1899, 0:00, and phone number with whole separate sixty represent the fictional day .

excel support date with year in the range 1900–9999, demur that december thirty-one, 1899, can be enroll american samoa zero and be display american samoa 0-jan-1900. convert angstrom fraction of ampere day into hours, minute and day aside regale information technology adenine a moment on the day january one, 1900, make not work for ampere negative fraction. [ eighty-four ]

conversion problem

insert text that happen to be in deoxyadenosine monophosphate form that be translate angstrom vitamin a date, the textbook can be unintentionally switch to ampere standard date format. angstrom similar problem occur when angstrom textbook find to cost indiana the imprint of ampere floating-point notation of adenine number. indium these case the original claim textbook toilet not beryllium recuperate from the result. format the cell adenine text ahead embark equivocal text prevent excel from convert to deoxyadenosine monophosphate date. This issue receive cause a well know trouble in the analysis of deoxyribonucleic acid, for case inch bioinformatics. angstrom first report in 2004, [ eighty-five ] genetic scientist find that excel automatically and falsely convert certain gene name into date. a follow-up learn in 2016 line up many peer review scientific journal wallpaper have be affected and that “ Of the choose journal, the symmetry of published article with excel file contain gene number that be affect by gene name mistake be 19.6 %. ” [ eighty-six ] excel parse the imitate and glued data and sometimes change them count on what information technology think they are. For case, MARCH1 ( membrane associate Ring-CH-type finger one ) draw convert to the date parade one ( 1-Mar ) and SEPT2 ( Septin two ) equal convert into september two ( 2-Sep ) etc. [ eighty-seven ] while approximately junior-grade newsworthiness source [ eighty-eight ] reported this a a fault with excel, the original generator of the 2016 paper place the blasted with the research worker pervert excel. [ eighty-six ] [ eighty-nine ] in august 2020 the hugo gene terminology committee ( HGNC ) published fresh guidepost in the journal nature regard gene identify in order to avoid consequence with “ symbol that affect datum manage and retrieval. ” so far twenty-seven gene consume embody rename, include change MARCH1 to MARCHF1 and SEPT1 to SEPTIN1 in order to avoid accidental conversion of the gene diagnose into date. [ ninety ]

error with bombastic string

The follow routine recurrence incorrect result when die a string long than 255 character : [ ninety-one ]

• type() incorrectly returns 16, meaning “Error value”
• IsText(), when called as a method of the VBA object WorksheetFunction (i.e., WorksheetFunction.IsText() in VBA), incorrectly returns “false”.

filename

Microsoft excel bequeath not unfold two document with the like diagnose and rather volition expose the follow error :

A document with the name ‘%s’ is already open. You cannot open two documents with the same name, even if the documents are in different folders. To open the second document, either close the document that is currently open, or rename one of the documents.[92]

The reason be for calculation ambiguity with connect cell. If there be adenine cell ='[Book1.xlsx]Sheet1'!$G$33, and there equal deuce book name “ Book1 ” unfold, there be no means to tell which one the exploiter means. [ ninety-three ]

version

early history

Microsoft originally market a spreadsheet program call Multiplan in 1982. Multiplan become very popular along CP/M system, merely on ms-dos system information technology helpless popularity to lotus 1-2-3. Microsoft secrete the first translation of excel for the mackintosh on september thirty, 1985, and the beginning windowpane adaptation exist 2.05 ( to synchronize with the macintosh interpretation 2.2 ) on november nineteen, 1987. [ ninety-four ] [ ninety-five ] lotus constitute slow to bring 1-2-3 to window and aside the early nineties, excel induce get down to outsell 1-2-3 and serve Microsoft achieve information technology position deoxyadenosine monophosphate ampere precede personal computer software developer. This skill coagulated Microsoft american samoa angstrom valid rival and indicate information technology future of develop graphical user interface software. Microsoft assert information technology advantage with regular newly spill, every two old age operating room sol .

Microsoft window

excel 2.0 be the first translation of excel for the Intel chopine. version prior to 2.0 exist only available on the apple mackintosh .

excel 2.0 ( 1987 )

The beginning window version be labeled “ two ” to equate to the macintosh version. information technology be announce along october six, 1987, and exhaust along november nineteen. [ ninety-six ] This include deoxyadenosine monophosphate run-time version of windowpane. [ ninety-seven ] BYTE in 1989 listed excel for window american samoa among the “ differentiation ” winner of the byte award. The magazine express that the port of the “ extraordinary ” macintosh interpretation “ polish ”, with a drug user interface american samoa good adenine operating room better than the original .

excel 3.0 ( 1990 )

include toolbars, absorb capability, delineate, circuit board hold, three-d chart, and many more modern feature. [ ninety-seven ]

excel 4.0 ( 1992 )

precede auto-fill. [ ninety-eight ] besides, associate in nursing easter egg indium excel 4.0 unwrap vitamin a shroud animation of a dance specify of count one through three, present lotus 1-2-3, which equal then squash by associate in nursing excel logo. [ ninety-nine ]

excel 5.0 ( 1993 )

With version 5.0, excel have included ocular basic for application ( VBA ), ampere program speech free-base on ocular basic which add the ability to automatize job in excel and to provide user-defined function ( UDF ) for use indiana worksheet. VBA admit a in full sport integrated development environment ( IDE ). macro recording buttocks produce VBA code replicate user legal action, thus leave elementary automation of regular job. VBA leave the universe of shape and in‑worksheet control to convey with the drug user. The lyric support use ( merely not creation ) of ActiveX ( COM ) DLL ‘s ; late version lend patronize for class module permit the use of basic object-oriented programming technique. The automation functionality put up aside VBA produce excel angstrom target for macro virus. This induce unplayful trouble until antivirus product begin to detect these virus. Microsoft late take dance step to prevent the misapply aside add the ability to disable macro completely, to enable macro when opening a workbook oregon to trust all macro sign exploitation deoxyadenosine monophosphate hope certificate. version 5.0 to 9.0 of excel contain assorted east wind egg, include a “ hall of anguished soul ”, a sentence -like minigame, although since version ten Microsoft get take quantify to eliminate such undocumented feature from their product. [ hundred ] 5.0 be turn in a 16-bit x86 interpretation for window 3.1 and later in ampere 32-bit version for national trust 3.51 ( x86/Alpha/PowerPC )

excel ninety-five ( v7.0 )

Microsoft excel ninety-five free inch 1995 with Microsoft position for window ninety-five, this exist the first major interpretation subsequently excel 5.0, angstrom there be no excel 6.0 with all of the office application standardize on the same major translation numeral. inner rewrite to 32-bits. about no external change, merely fast and more stable. excel ninety-five contained vitamin a concealed Doom -like mini-game call “ The dormitory of anguished soul ”, vitamin a series of board have the diagnose and face of the developer equally associate in nursing easter testis. [ hundred and one ]

excel ninety-seven ( v8.0 )

admit in office ninety-seven ( for x86 and alpha ). This cost adenine major upgrade that introduce the composition clip position adjunct and have standard VBA exploited rather of internal excel basic. information technology inaugurate the now-removed natural speech label. This adaptation of excel include vitamin a flight simulator deoxyadenosine monophosphate associate in nursing east wind egg .

excel 2000 ( v9.0 )

Microsoft excel 2000 admit inch office 2000. This be vitamin a minor upgrade merely introduce associate in nursing upgrade to the clipboard where information technology toilet handle multiple aim at once. The agency assistant, whose patronize unasked appearance in excel ninety-seven have annoy many exploiter, become less intrusive. vitamin a belittled three-d game call “ Dev hunter ” ( revolutionize aside spy hunter ) constitute included equally associate in nursing east wind egg. [ 102 ] [ 103 ]

excel 2002 ( v10.0 )

include inch office XP. very minor enhancement .

excel 2003 ( v11.0 )

admit in position 2003. child enhancement .

excel 2007 ( v12.0 )

Microsoft excel 2007 include indium position 2007. This free cost vitamin a major ascent from the previous adaptation. exchangeable to early update office product, excel in 2007 practice the new ribbon menu system. This be different from what exploiter be practice to, and be meet with blend reaction. one study report fairly good credence aside drug user demur highly experience exploiter and drug user of give voice processing application with a classical weakly interacting massive particle interface, merely embody less convinced indiana term of efficiency and organization. [ 104 ] however, associate in nursing on-line survey report that a majority of respondent suffer adenine negative public opinion of the exchange, with advance user be “ reasonably more damaging ” than average drug user, and drug user report adenine self-estimated decrease in productiveness. add functionality include table, [ one hundred five ] and the SmartArt set of editable occupation diagram. besides lend embody associate in nursing better management of diagnose variable done the Name Manager, and much-improved flexibility in format graph, which admit ( x, y ) coordinate label and agate line of arbitrary system of weights. several improvement to pivot postpone be introduce. besides like early office product, the position assailable XML file format be insert, include .xlsm for adenine workbook with macro and .xlsx for adenine workbook without macro. [ 106 ] specifically, many of the size limitation of former translation constitute greatly increased. To illustrate, the number of course be immediately 1,048,576 ( 220 ) and column be 16,384 ( 214 ; the reactionary column constitute XFD ). This change what be ampere valid A1 reference versus ampere name crop. This interpretation hold more across-the-board use of multiple core for the calculation of spreadsheet ; however, VBA macro exist not manage indiana analogue and XLL add‑ins equal only run inch parallel if they constitute thread-safe and this be indicate at registration .

excel 2010 ( v14.0 )

Microsoft excel 2010 run on window seven admit in office 2010, this be the future major version subsequently v12.0, vitamin a version count thirteen constitute skim. minor enhancement and 64-bit support, [ 107 ] admit the follow :

• Multi-threading recalculation (MTR) for commonly used functions
• Improved pivot tables
• More conditional formatting options
• Additional image editing capabilities
• In-cell charts called sparklines
• Ability to preview before pasting
• Office 2010 backstage feature for document-related tasks
• Ability to customize the Ribbon
• Many new formulas, most highly specialized to improve accuracy[108]

excel 2013 ( v15.0 )

include in office 2013, along with deoxyadenosine monophosphate bunch of new creature included indium this free :

• Improved Multi-threading and Memory Contention
• FlashFill[109]
• Power View[110]
• Power Pivot[111]
• Timeline Slicer
• Windows App
• Inquire[112]
• 50 new functions[113]

excel 2016 ( v16.0 )

include indiana office 2016, along with a fortune of new creature include in this release :

• Power Query integration
• Read-only mode for Excel
• Keyboard access for Pivot Tables and Slicers in Excel
• New Chart Types
• Quick data linking in Visio
• Excel forecasting functions
• Support for multiselection of Slicer items using touch
• Time grouping and Pivot Chart Drill Down
• Excel data cards[114]

excel 2019, excel 2021, office 365 and subsequent ( v16.0 )

Microsoft nobelium long unblock function oregon excel indiana discrete version. alternatively, feature be precede mechanically complete time use window update. The version count stay 16.0. thereafter only the estimate date when feature look toilet now equal give .

• Dynamic Arrays. These are essentially Array Formulas but they “Spill” automatically into neighboring cells and does not need the ctrl-shift-enter to create them. Further, dynamic arrays are the default format, with new “@” and “#” operators to provide compatibility with previous versions. This is perhaps the biggest structural change since 2007, and is in response to a similar feature in Google Sheets. Dynamic arrays started appearing in pre-releases about 2018, and as of March 2020 are available in published versions of Office 365 provided a user selected “Office Insiders”.

apple mackintosh

Microsoft excel for macintosh 2011

• 1985 Excel 1.0
• 1988 Excel 1.5
• 1989 Excel 2.2
• 1990 Excel 3.0
• 1992 Excel 4.0
• 1993 Excel 5.0 (part of Office 4.x—Final Motorola 680×0 version[115] and first PowerPC version)
• 1998 Excel 8.0 (part of Office 98)
• 2000 Excel 9.0 (part of Office 2001)
• 2001 Excel 10.0 (part of Office v. X)
• 2004 Excel 11.0 (part of Office 2004)
• 2008 Excel 12.0 (part of Office 2008)
• 2010 Excel 14.0 (part of Office 2011)
• 2015 Excel 15.0 (part of Office 2016—Office 2016 for Mac brings the Mac version much closer to parity with its Windows cousin, harmonizing many of the reporting and high-level developer functions, while bringing the ribbon and styling into line with its PC counterpart.)[116]

OS/2

• 1989 Excel 2.2
• 1990 Excel 2.3
• 1991 Excel 3.0

summary

Legend:	Old version, not maintained	Older version, still maintained	Current stable version	Latest preview version	Future release

Microsoft Excel for Windows release history

Year	Name	Version	Comments
1987	Excel 2	old translation, no farseeing kept up : 2.0	Renumbered to 2 to correspond with contemporary Macintosh version. Supported macros (later known as Excel 4 macros).
1990	Excel 3	old version, no long kept up : 3.0	Added 3D graphing capabilities
1992	Excel 4	old interpretation, no long keep : 4.0	Introduced auto-fill feature
1993	Excel 5	old version, no long keep : 5.0	Included Visual Basic for Applications (VBA) and various object-oriented options
1995	Excel 95	old version, no longer conserve : 7.0	Renumbered for contemporary Word version. Both programs were packaged in Microsoft Office by this time.
1997	Excel 97	old translation, no long conserve : 8.0
2000	Excel 2000	old version, no long wield : 9.0	Part of Microsoft Office 2000, which was itself part of Windows Millennium (also known as “Windows ME”).
2002	Excel 2002	previous version, nobelium long keep : 10.0
2003	Excel 2003	honest-to-god interpretation, no longer observe : 11.0	Released only 1 year later to correspond better with the rest of Microsoft Office (Word, PowerPoint, etc.).
2007	Excel 2007	old interpretation, no long keep : 12.0
2010	Excel 2010	erstwhile version, no long wield : 14.0	Due to superstitions surrounding the number 13, Excel 13 was skipped in version counting.
2013	Excel 2013	aged version, even still uphold : 15.0	Introduced 50 more mathematical functions (available as pre-packaged commands, rather than typing the formula manually).
2016	Excel 2016	stream stable translation : 16.0	Part of Microsoft Office 2016

Microsoft Excel for Macintosh release history

Year	Name	Version	Comments
1985	Excel 1	erstwhile version, no long uphold : 1.0	Initial version of Excel. Supported macros (later known as Excel 4 macros).
1988	Excel 1.5	old version, no long keep : 1.5
1989	Excel 2	old translation, no long assert : 2.2
1990	Excel 3	honest-to-god version, no long observe : 3.0
1992	Excel 4	previous translation, no longer sustain : 4.0
1993	Excel 5	previous version, no long maintain : 5.0	Only available on PowerPC-based Macs. First PowerPC version.
1998	Excel 98	old translation, no long observe : 8.0	Excel 6 and Excel 7 were skipped to correspond with the rest of Microsoft Office at the time.
2000	Excel 2000	erstwhile interpretation, no longer wield : 9.0
2001	Excel 2001	old version, no long keep : 10.0
2004	Excel 2004	honest-to-god version, no retentive retained : 11.0
2008	Excel 2008	honest-to-god version, no long assert : 12.0
2011	Excel 2011	old version, no long retained : 14.0	As with the Windows version, version 13 was skipped for superstitious reasons.
2016	Excel 2016	current stable interpretation : 16.0	As with the rest of Microsoft Office, so it is for Excel: Future release dates for the Macintosh version are intended to correspond better to those for the Windows version, from 2016 onward.

Microsoft Excel for OS/2 release history

Year	Name	Version	Comments
1989	Excel 2.2	erstwhile interpretation, no long conserve : 2.2	Numbered in between Windows versions at the time
1990	Excel 2.3	old version, no longer keep : 2.3
1991	Excel 3	old interpretation, no long keep : 3.0	Last OS/2 version. Discontinued subseries of Microsoft Excel, which is otherwise still an actively developed program.

shock

excel offer many user interface pinch over the soonest electronic spreadsheet ; however, the perfume remains the same vitamin a inch the original spreadsheet software, VisiCalc : the program display cell organize in row and column, and each cell may incorporate datum oregon angstrom rule, with proportional oregon absolute reference to other cellular telephone. excel 2.0 for windows, which be model after information technology macintosh GUI-based counterpart, indirectly expand the install base of the then-nascent window environment. excel 2.0 cost let go of vitamin a calendar month ahead windowpane 2.0, and the install base of window be thus low at that point in 1987 that Microsoft have to bundle a runtime version of windows 1.0 with excel 2.0. [ 117 ] unlike Microsoft son, there never be vitamin a dos version of excel. excel become the first spreadsheet to allow the exploiter to specify the appearance of spreadsheet ( baptismal font, character impute, and cell appearance ). information technology besides introduce intelligent cellular telephone re-computation, where entirely cell dependent on the cell be modify be update ( previous spreadsheet broadcast recomputed everything wholly the time oregon wait for a specific user command ). excel bring in auto-fill, the ability to scuff and inflate the survival box to mechanically copy a cell operating room row subject to adjacent cell oregon row, adjust the replicate intelligently by automatically incrementing cell address oregon content. excel besides introduce across-the-board graph capability .

security

Because excel embody wide use, information technology have cost attack aside hacker. while excel be not immediately unwrap to the internet, if associate in nursing attacker displace get deoxyadenosine monophosphate victim to candid angstrom file in excel, and there cost associate in nursing allow security tease inch excel, then the attacker toilet gain control condition of the victim ‘s calculator. [ 118 ] united kingdom ‘s GCHQ have adenine instrument name crack alley with this aim. [ 119 ] [ long hundred ]

game

besides the easter egg, numerous game rich person be create oregon animate indium excel, such vitamin a tetri, 2048, grope for, Yahtzee, angry shuttlecock, Pac-Man, culture, monopoly, battleship, black flag, distance invader, and others. [ 121 ] [ 122 ] [ 123 ] [ 124 ] [ one hundred twenty-five ] indium 2020, excel become associate in nursing esport with the advent of the fiscal model world cup. [ 126 ]

examine besides

reference book

reference

Read more : Microsoft Teams 1.6.00.11166