Basic Introduction Chinese Name: Microsoft Office Excel Abbreviation: Microsoft Excel R&D Company: Microsoft Company Role: Data Processing Microsoft Office, Microsoft Office Version History, Android Version History, Windows Version History, Mac Version History, Components, Desktop Products, Add-ons, Advanced version includes other programs, other programs, plug-ins, Internet-based services, Microsoft Excel, Microsoft Excel history, version, password protection, technical indicators and competitors. See Microsoft Office Microsoft Office software developed by Microsoft Corporation, which can run on Microsoft Windows, Windows Phone, Mac series, iOS and Android. Like other office applications, it includes federated servers and Internet-based services. Since the 2007 version of Office, it has been called "Office System" instead of "Office Suite", which reflects the fact that they include servers. Office was originally a promotional name, which appeared in1early 1990s, referring to a collection of software previously sold separately. At that time, the main promotion focus was: buying a collection saved a lot of money than buying it alone. The original versions of Office included Word, Excel and PowerPoint. "Professional Edition" includes Microsoft Aess, when Microsoft Outlook did not exist. With the change of time, Office applications are gradually integrated and enjoy functions such as spelling and grammar checking, OLE data integration and VBA scripting language. At present, Microsoft extends Office as a development platform, and can download third-party software from specialized stores. Office is often the standard for making documents and files. It has some functions that other products do not have, but other products also have functions that Office lacks. Since 2007, Microsoft Office System has had a completely different user interface from the previous version. This interface is called Ribbon interface, which is used in Microsoft Office 20 10, Microsoft Office 20 13 and Microsoft Office 20 16. History of Microsoft Office Version The original version of Microsoft Office was launched in 1989, and it was initially run on the Macintosh platform of Apple computer. Since the introduction of word processing, spreadsheets and presentation software, Microsoft Office has been in a leading position. Starting from Microsoft Office 2013 (Office15), more functions of Office provide cross-platform support, and programs of Android and IOS mobile operating systems are provided. This function is mainly used for the desktop version. Since the release of Microsoft Office 20 16, the updates of the same version number on all platforms are roughly the same. History of Android Version Microsoft Office Mobile (Office 15): It is an Office version provided by Microsoft for mobile devices. The main function is to enable Office 365 subscribers to use their Office subscriptions on mobile devices. This version has been criticized because the program is only open to paid subscribers, and has limited functions for non-subscribers (only the contents of files can be read, but not modified), and it can't display the file format correctly and store Office files in the device. At present, the program can still be used on Google Play, but it only supports devices running Android or earlier. Microsoft Office 2016: 20 15 April15, Microsoft released four office programs: Microsoft Word, Microsoft PowerPoint, Microsoft OneNote and Microsoft Outlook on Google Play. These programs were only applicable to tablets at that time, but now they are open to all devices above Android 4.4, and users need to download and update each application independently. Android devices with screen sizes smaller than 10. 1 inch can use most functions normally without subscription. History of Microsoft Office 3.0 for Windows: It was the first version of Microsoft Office for Windows platform. The CD version includes: Word 2.0c, Excel 4.0a, PowerPoint 3.0 and E-mail, which was released on August 30th, 1993. Microsoft Office 4.0: including Word 6.0, Excel 5.0, PowerPoint 4.0, Mail and Aess. At this time, Word was called Word 6.0, not 2.0, in order to have the same version number as the Mac OS version, and the release time was 1994 65438+ 10/7. Microsoft Office 4.2: For Windows NT, (Word 6.0[32-bit, i386, Alpha], Excel 5.0[32-bit, i386, Alpha], PowerPoint 4.0[ 16-bit], Microsoft Office Manager),1released on July 3, 994. Microsoft Office 4.3: It is the last version with 16, and the last version that supports Windows 3.x, Windows NT 3. 1 and Windows NT 3.5, including Word 6.0, Excel 5.0 and PowerPoint 4.0. The professional version is Aess 2.0, released on June 2nd, 1994. Microsoft Office 95: In order to cooperate with Windows 95, it is completely a 32-bit version. There are two versions of Office 95, Office 95 Standard Edition and Office 95 Professional Edition. The standard edition includes Word, Excel, PowerPoint and Schedule+. Professional edition includes all standard edition software and AES. If you buy a professional CD type, it also includes a bookshelf. 1995 will be available for sale on August 30th. Microsoft Office 97: It is an important milestone. This version contains many new functions and improvements. It also introduces the functions of the command bar and spell check.
Office 97 is the last version of the Office software package supporting Windows NT 3.5 1, which was released in 1996 12.30 (both with CD and a set of 45 3.5-inch floppy disks). Microsoft Office 2000: Add adaptive menus, and the less used options will be hidden. He also added many new security functions. Including the function of adding digital signature to reduce the threat of macro virus.
Office 2000 is the last version of Office that supports Windows 95. Office2000 is also the last version that does not include the product boot function, and it was released on199965438+1October 27th. Microsoft Office XP: It was launched to cooperate with Windows XP. Office XP introduces the function of safe mode. It allows applications (such as Outlook) to automatically run in an appropriate state when they cannot start normally. Microsoft Office XP includes a complete speech recognition system and handwriting recognition system. Another new product boot function, users need to use the serial number to boot Office XP, and this same function has also been introduced into Windows XP and subsequent versions of Windows and Office.
Office XP is the last version of Office that supports Windows 98, ME and NT 4.0. Outlook 2002(XP) has a serious problem: you can't remember your email account and password under Vista. Published on May 3, 20061day. Microsoft Office 2003: released in 2003. Two new programs have been added: Microsoft InfoPath and OneNote. Office 2003 is the first version to use Windows XP style icons. In addition, Outlook 2003 has made many improvements, including Kerberos authentication, remote procedure call (RPC) and cached Exchange mode. Outlook has added a spam filter in this version to help solve the spam problem.
Office 2003 is the last version of the Office software package supporting Windows 2000, which was released in June165438+1October 65438+July 2003. Microsoft Office 2007: It was launched to cooperate with Windows Vista. Office 2007 contains many new functions, the most striking of which is the new ribbon interface, which replaces the old menus and toolbars and makes them easier to use.
Office 2007 can only be installed in Windows XP with Service Pack 2 or 3, Windows Server 2003 with Service Pack 1 or later, or Windows Vista. In 2007, Microsoft Office released Service Pack 3, which fixed many loopholes and was released on June 30, 2006. Microsoft Office 20 10: in June 2009, Microsoft began internal testing (TP) of office 2010. Including AESS 20 10, Excel 20 10, Groove 20 10, InfoPath Designer 20 10, InfoPath Filler 20 10, InterConnect 20 10, Lync 2065438 Office 20 10beta was developed in May 2009, and the final version was released on April 2010/5. Microsoft Office 20 10 has 32-bit and 64-bit versions. Microsoft claims that 32 bits are more stable. It is recommended that 64-bit computers install 32-bit Office. Since Office 20 10, a large number of licensed versions need product guidance as well as ordinary versions. Microsoft Office 20 10 has Service Pack 1, and the version is 14.0.6029. 1000. Office 20 10 is the latest version of the office software package that supports Windows XP (Service Pack 3 only), Windows Vista (service pack1or later), Windows Server 2003 (Service Pack 2 only) and Windows Server 2008. Officially released on June 20 10. Microsoft Office 20 13: 20 12, 10,1was officially released and listed on 20 13, 16. There are 32-bit and 64-bit versions. This Office officially began to integrate Microsoft accounts, and the cloud stores user's modifications and settings. The default path for storing files is set to OneDrive. This version has made many obvious improvements to Excel, OneNote and Outlook. Version has an Office application, an application extension. This extension can be downloaded and installed in the specialized stores of office and Office software, providing dynamic and interactive related contents in network information documents.
Office 20 13 can only be installed on Windows 7, Windows Server 2008 R2 or above, and the official version is released on 20 13 1. Microsoft Office 20 16: This version was launched in cooperation with Windows 10. Version 20 13 of the interface has been moderately modified, and a more complete store has been added. Because it is widely rumored that Windows 10 comes with Office, it attracts people's attention. Finally, Microsoft officially clarified that it only comes with a preview function. 2065438+officially listed on September 23rd, 2005. History of Microsoft Office for Mac: 1989 was launched on the MAC platform. This version of Office includes Word 4.0, Excel 2.20 and PowerPoint 2.0 1. This version was launched earlier than Office running on Windows platform. Microsoft Office 1.5 for Mac: launched on 199 1, in which Excel was upgraded to Excel 3.0. It is the first Office to support Apple's System 7 operating system. Microsoft Office 2.9 for Mac: 1992 was launched, among which Excel 4.0 was the first software to support the new AppleScript. Microsoft Office 4.0 for Mac: published in 1993. He was the first Office software package to support Power Macintosh, and the last version of Office released for Mac was: Office 4.2. 1. Microsoft Office 98 Macintosh Edition:1debuted at MacWorld Expo/ San Francisco on June 6, 1998. It has joined the Inter Explorer4.0browser and Outlook Express. The first version of the Office software package supporting QuickTime was released in March 1998. Microsoft Office 20065438+0: released on June 65438+1October 1 1. The required environment is Mac OS 8. 1 (version 8.5 or higher is recommended). Add the environment to Office 200 1. Microsoft Office v. X:2006 54 38+0 was launched for the new Mac OS X platform, and was released on September 3rd, 20065438+0. Microsoft Office 2004 for Mac: May 2004 1 1 launched. Microsoft Office 2008 for Mac: released on June 65438+10/October 65438+May 2008. It is the first office software package that uses universal binary. This means that it can natively support Macs on Intel and Power PC. Microsoft Office 2011for MAC: 2010 was released on September 26th, replacing Entourage with Ribbon interface and Outlook for Mac. Microsoft Office 2011for MAC has released the Service Pack 3 update with version 14.5.2. Microsoft office 2016 for MAC: 2065438+released in September 2005, together with the Windows version, it is called Microsoft Office 2065 438+06. Component Desktop Products These programs are included in all versions of Microsoft Office 20 10 except Microsoft Office Starter 2010. Microsoft office starter 2010 is not a product for public sale. When buying a brand computer, it is installed randomly, and only contains the entry-level versions of Word and Excel, and there are irremovable Microsoft advertisements on the right side of the page. Word: main item: Microsoft Word Microsoft Word is a word processing software, which is considered as the main program of Office. It dominates the word processing software market, and its private DOC format is regarded as the industry standard, although it has been converted from Word 2007 to DOCX format. Word is also suitable for some versions of Microsoft Works. Suitable for Windows and Macintosh platforms. Its main competitors are LibreOffice, Corel WordPerfect and ApplePages. Excel: Main Item: Microsoft Excel Microsoft Excel is a spreadsheet program (a software program that performs numerical and budget operations). Like Microsoft Word, it has a dominant market share. At first, it was the dominant competitor of Lotus 1-2-3, but in the end, it sold much more than it and sold faster, so it became the actual standard. Suitable for Windows and Macintosh platforms. Its main competitors are OpenOffice Calc, AppleNumbers and CorelQuattro Pro. Outlook: Main Item: Microsoft Outlook Microsoft Outlook (not to be confused with Outlook Express) is a personal information management program and email communication software. Take over Microsoft mail in Office 97. It includes an email client, a calendar, a task manager and an address book. The main competitors of its email program are Mozilla Thunderbird and Eudora. Its main competitors are Mozilla, Apple's Mail and Lotus Organizer. A version of it is also included in most palmtop computers. Microsoft mail-mail client (included in the old version of Office and later replaced by Microsoft Outlook). Microsoft Outlook Express-mail client (included in the Macintosh version of Office 98 and later replaced by Microsoft Entourage). Microsoft entourage-mail client (included in Office 2008 and earlier versions and later replaced by Microsoft Outlook for Mac). PowerPoint: Main item: Microsoft PowerPoint Microsoft PowerPoint is a popular entry program under Windows and Macintosh. It can create slides composed of text combinations, pictures, movies and other things. Slides can be displayed on the screen and operated by the presenter. Slides can also be projected onto the screen using a mirror or projector. Windows Mobile 2005(Mago) will use this program to dominate the market. Its main competitors are OpenOffice Impress, CorelWord Perfect and AppleKeynote. Aess: Main item: Microsoft Aess Microsoft Aess is a relational database management system released by Microsoft. It can be used to make a desktop system for processing data. It is also often used to develop simple web applications. (Windows version only) The attached program Microsoft Inter Explorer is a common web browser. At present, Inter Explorer is not bundled with Office, and it remains compatible in Windows 10. Microsoft photo editor-photo editing/graphics software in old and XP versions of Office. It was temporarily supplemented by Microsoft Photo in the advanced version of Office 2000. Microsoft Office Picture Manager- basic photo management software (similar to Google's Picasa or Adobe's basic version of Photoshop Elements). Other programs included in the Advanced Edition are Microsoft frontpage, a website design software (and it needs its own server program). For the 2003 edition, it is included in Microsoft Office Professional Edition 2003 and Microsoft Office Professional Enterprise Edition. It was not included in Microsoft Office System 2007, but was replaced by a separately released Microsoft Expression product line. Microsoft visio drawing program (purchased separately). Microsoft publisher- desktop publishing software. For version 20 16, Included in Microsoft office small business edition 2007, Microsoft office professional (plus) edition 2007, Microsoft office enterprise edition 2007 and Microsoft office professional (plus) edition 2010. Microsoft Project- project manager (purchased separately). Microsoft OneNote, a notebook software, is suitable for tablet computers and general personal computers. It is included in Microsoft Office System 2016. Microsoft SharePoint Designer-WYSIWYG HTML Editor and Microsoft Universal web Designer are used to replace Microsoft Office frontpage. Microsoft InfoPath- enables users to design rich XML-based applications. Included in Microsoft office professional plus edition 2016, Microsoft office enterprise edition 2007 and Microsoft office professional plus edition 2010. Real-time communication software. Other programs Microsoft binder- merge multiple files into one file. Binder is a huge failure for Microsoft and its popularity is very low. Therefore, the new version of Office often does not have this software. Microsoft Entourage- Personal information manager and email software for Macintosh only. (similar to Outlook). Microsoft MapPoint- Drawing and Tourism Planning Software. (as a component of Excel since 20 16) Microsoft Office Communicator 2005-[1] Developer Tools-Development Tools (included in the development version only) Office plug-in 2007 Microsoft Office Add-in: Save Microsoft files as PDF or XPS: Use this add-in to export files in eight 2007 Microsoft Office programs and save them in PDF and XPS formats without the help of third-party software. A main feature of third-party plug-ins supporting Office applications is that users and third-party vendors can write COM-based Office packages to expand the functions of applications and add customized commands and interfaces. Internet-based service Microsoft Office Website-Website. Included in all versions of Microsoft Office 2007 and Microsoft Office 20 10. -[2]Microsoft office update- Web site. Patch finding and installation services for Office2000, XP, 2003 and 2007 and 20 10. -[3] Microsoft AutoUpdate- Installer for Mac users update Office to the latest version. From the version of 1997, Microsoft agents (9.0/2000 and later) and a similar actor technology (8.0/97) began to provide interactive help tools such as Office Assistant. The nickname of "assistant" is often "Clippy" or "Clippit". Because it corresponds to CLIPPIT. The default is ACS. Starting from Macintosh Office 1998, Macintosh version and Windows version of Office share the same file format. Therefore, any Macintosh with Office 1998 or higher can read Office 8.0( 1997) or higher files on the Windows platform, and vice versa. Microsoft Excel Microsoft Excel is a spreadsheet software written by Microsoft for computers using Windows and Apple Macintosh operating systems. Intuitive interface, excellent calculation function and chart tools, coupled with successful marketing, make Excel the most popular personal computer data processing software. 1993, after the release of version 5.0 of Microsoft Office component, Excel began to become the overlord of spreadsheet software on the applicable operating platform. History of Microsoft Excel 1982 Microsoft launched its first spreadsheet software ──Multiplan, which was a great success on CP/M system, but on MS-DOS system, Multiplan lost to Lotus 1-2-3. This incident prompted the birth of Excel, just as the research code of Excel is Doug Klunder: Do what Lotus 1-2-3 can do, and do it better. 1985, the first Excel was born, which was only used for Mac systems. In June, 1987, 1 1, the first Windows Excel (directly bundled with Windows environment, version number 2.0 in Mac) was released. Lotus 1-2-3 cannot be applied to Windows system for a long time. By 1988, the sales volume of Excel surpassed that of Lotus, which made Microsoft stand in the leading position of PC software manufacturers. This incident led to the replacement of the overlord of the software kingdom. Microsoft consolidated its strong competitor position and found the direction of developing graphics software. After that, every two years or so, Microsoft will launch a new version to expand its advantages. At present, the latest version of Excel is 16, which is Microsoft Office Excel 20 16. In the early days, Excel became the target of trademark law because it had the same name as the software sold by another company. After trial, Microsoft was asked to name the software after Microsoft Excel in its official documents and legal documents. However, over time, this practice has gradually disappeared. Although Excel provides a lot of user interface functions, it still retains the functions of the first spreadsheet software VisiCalc: rows and columns form cells, and data, formulas related to data or absolute references to other cells are stored in cells. Excel is the first spreadsheet software that allows users to customize the interface, including fonts, text attributes and cell formats. The function of "intelligent recalculation" is also introduced. When the cell data changes, only the relevant data will be updated, while the original tabulation software can only recalculate all the data or wait for the next instruction. At the same time, Excel also has powerful graphic functions. 1993 When Excel was first bundled into Microsoft Office, Microsoft redesigned the interface between Microsoft Word and PowerPoint to adapt to this extremely popular application at that time. Excel has supported Visual Basic for Applications (VBA) since 1993. VBA is a powerful tool, which makes Excel form an independent programming environment. With VBA and macros, you can automate manual steps. VBA also allows you to create forms to obtain information entered by users. However, the automation function of VBA also makes Excel the target of macro virus. From 5.0 to 9.0, different Easter eggs are hidden in Excel. The versions of MS-DOS include:1987 EXCEL2.0 for MS-DOS 3.0 for Microsoft Windows:1987 EXCEL2 for Windows1990 EXCEL31992 EXCEL4./ Kloc-0/993 EXCEL5 1 995 EXCEL95-aka 7 1997 Excel 97- aka 8 1999 Excel 2000- aka 9 200 1 Excel XP- aka1 0 2003 Excel 2003- also known as11EXCEL2007 in8+06-also known as 16 Apple Macintosh versions include:1985 Excel for Macintosh1989 Excel 2.2 for Macintosh1. 5438+0998 Excel 98 2000 Excel 200 1 200 1 Excel v . X 2004 Excel 2004 2008 Excel 2008 20 10 Excel 20 1 20 16 Excel 2065433。 The 8+06 version of OS/2 includes:1989 EXCEL2.21990 EXCEL2.31991EXCEL3.0. In addition, there are mobile versions of Excel and Excel Mobile for iOS, Android and Windows 10 Mobile. Password protection Password protection in Microsoft Excel provides several types: using a password to open a document; Modify the document with a password; Unprotect the worksheet with a password; Protect the workbook with a password; Protect the workbook with a password. Excel 2007 technical indicators, the upper limit of rows is 1048576(=2), and the upper limit of columns is XFD(= 16384). Competitor Google Documentary Acey Office Capability Spreadsheet edit grid Framework Lotus 1 -2-3 GNU meric kspread open office calc origin quattro pro the crusher (f or Macintosh) visicalc wps form libreoffice See Sway LibreOffice, an open office suite software.