Features of MS Office by Rawal Kishore
Features of MS Office by Rawal Kishore
Features of MS Office by Rawal Kishore
OF
MS OFFICE
By: ABC
Microsoft Office
Office is produced in several versions targeted towards different end-users and computing
environments. The original, and most widely used version, is the desktop version,
available for PCs running the Windows and macOS operating systems. The most
current desktop version is Office 2016 for Windows and macOS, released on 22
September 2015[6] and 9 July 2015,[7] respectively.
More recently, Microsoft developed Office Mobile, which are free-to-use versions of Office
applications for mobile devices. Microsoft also produces and runs Office Online, a web-
based version of core Office apps, which is included as part of a Microsoft account.
Title and Content Layout
Components
Desktop apps
Delve: Allows Office 365 users to search and manage their emails, meetings, contacts, social
networks and documents stored on OneDrive or Sites in Office 365.
Office Forms: An online survey creator, available for Office 365 Education subscribers
Outlook on the web: Similar to Outlook.com but more comprehensive and available only through
Office 365 and Microsoft Exchange Server offerings.
Microsoft Planner: A planning application available on the Microsoft Office 365 platform.
Office 365 Video: A video sharing service for enterprise users with an Office 365 Academic or
Enterprise license
Common Features
Most versions of Microsoft Office (including Office 97 and later) use their own widget set
and do not exactly match the native operating system. This is most apparent in
Microsoft Office XP and 2003, where the standard menus were replaced with a
colored, flat-looking, shadowed menu style. The user interface of a particular version of
Microsoft Office often heavily influences a subsequent version of Microsoft Windows.
For example, the toolbar, colored buttons and the gray-colored 3D look of Office 4.3
were added to Windows 95, and the ribbon, introduced in Office 2007, has been
incorporated into several programs bundled with Windows 7 and later. In 2012, Office
2013 replicated the flat, box-like design of Windows 8.
Users of Microsoft Office may access external data via connection-specifications saved in
Office Data Connection (.odc) files.[27]
Both Windows and Office use service packs to update software. Office had non-
cumulative service releases, which were discontinued after Office 2000 Service
Release 1.
Past versions of Office often contained Easter eggs. For example, Excel 97 contained a
reasonably functional flight-simulator. Office XP and later do not have any Easter eggs,
in compliance with Trustworthy Computing guidelines.
Common Features
Most versions of Microsoft Office (including Office 97 and later) use their own widget set
and do not exactly match the native operating system. This is most apparent in
Microsoft Office XP and 2003, where the standard menus were replaced with a
colored, flat-looking, shadowed menu style. The user interface of a particular version of
Microsoft Office often heavily influences a subsequent version of Microsoft Windows.
For example, the toolbar, colored buttons and the gray-colored 3D look of Office 4.3
were added to Windows 95, and the ribbon, introduced in Office 2007, has been
incorporated into several programs bundled with Windows 7 and later. In 2012, Office
2013 replicated the flat, box-like design of Windows 8.
Users of Microsoft Office may access external data via connection-specifications saved in
Office Data Connection (.odc) files.[27]
Both Windows and Office use service packs to update software. Office had non-
cumulative service releases, which were discontinued after Office 2000 Service
Release 1.
Past versions of Office often contained Easter eggs. For example, Excel 97 contained a
reasonably functional flight-simulator. Office XP and later do not have any Easter eggs,
in compliance with Trustworthy Computing guidelines.
File Formats and Metadata
Microsoft Office prior to Office 2007 used proprietary file formats based on the OLE Compound File
Binary Format.[28] This forced users who share data to adopt the same software platform.[29] In
2008, Microsoft made the entire documentation for the binary Office formats freely available for
download and granted any possible patents rights for use or implementations of those binary format
for free under the Open Specification Promise.[30][31] Previously, Microsoft had supplied such
documentation freely but only on request.[32]
Starting with Office 2007, the default file format has been a version of Office Open XML, though
different than the one standardized and published by Ecma International and by ISO/IEC. Microsoft
has granted patent rights to the formats technology under the Open Specification Promise[33] and
has made available free downloadable converters for previous versions of Microsoft Office including
Office 2003, Office XP, Office 2000[34] and Office 2004 for Mac OS X. Third-party implementations of
Office Open XML exist on the Windows platform (LibreOffice, all platforms), macOS platform
(iWork '08, LibreOffice) and Linux (LibreOffice and OpenOffice.org 3.0). In addition, Office 2010 and
Service Pack 2 for Office 2007 supports the OpenDocument Format (ODF) for opening and saving
documents on Windows (Microsoft Office for Mac has never included ODF support).
Microsoft provides the ability to remove metadata from Office documents. This was in response to
highly publicized incidents where sensitive data about a document was leaked via its
metadata.[35] Metadata removal was first available in 2004, when Microsoft released a tool
called Remove Hidden Data Add-in for Office 2003/XP for this purpose.[36] It was directly integrated
into Office 2007 in a feature called the Document Inspector.
Extensibility
A major feature of the Office suite is the ability for users and third party companies to write add-ins
(plug-ins) that extend the capabilities of an application by adding custom commands and
specialized features. One of the new features is the Office Store.[37] Plugins and other tools can be
downloaded by users.[38] Developers can make money by selling their applications in the Office
Store. The revenue is divided between the developer and Microsoft where the developer gets 80%
of the money.[39] Developers are able to share applications with all Office users.[39]
The app travels with the document, and it is for the developer to decide what the recipient will see
when they open it. The recipient will either have the option to download the app from the Office
Store for free, start a free trial or be directed to payment.[39] With Office's cloud abilities, IT
department can create a set of apps for their business employees in order to increase their
productivity.[40] When employees go to the Office Store, they'll see their company's apps under My
Organization. The apps that employees have personally downloaded will appear under My
Apps.[39] Developers can use web technologies like HTML5, XML, CSS3, JavaScript, and APIs for
building the apps.[41] An application for Office is a webpage that is hosted inside an Office client
application. User can use apps to amplify the functionality of a document, email message, meeting
request, or appointment. Apps can run in multiple environments and by multiple clients, including
rich Office desktop clients, Office Web Apps, mobile browsers, and also on-premises and in the
cloud.[41] The type of add-ins supported differ by Office versions:
Office 97 onwards (standard Windows DLLs i.e. Word WLLs and Excel XLLs)
In addition to supporting retail sales and site-wide installations, Microsoft offers a "Home
Use Program" (HUP) permitting employees of a participating organization access to
home-use Microsoft Office products.[83]
Post-secondary students may obtain the University edition of Microsoft Office 365
subscription. (Despite the name, college students are also eligible.) It is limited to one
user and two devices, plus the subscription price is valid for four years instead of just
one. Apart from this, the University edition is identical in features to the Home Premium
version. This marks the first time Microsoft does not offer physical or permanent
software at academic pricing, in contrast to the University versions of Office
2010 and Office 2011. In addition, students eligible for DreamSpark program may
receive select standalone Microsoft Office apps free of charge.
Discontinued applications and features
Microsoft Binder: Incorporates several documents into one file and was originally
designed as a container system for storing related documents in a single file. The
complexity of use and learning curve led to little usage, and it was discontinued after
Office XP.
Microsoft FrontPage: a WYSIWYG HTML editor and website administration tool for
Windows. It was branded as part of the Microsoft Office suite from 1997 to 2003.
FrontPage was discontinued in December 2006 and replaced by Microsoft SharePoint
Designer and Microsoft Expression Web.
Microsoft InfoPath: Windows application for designing and distributing rich XML-based
forms. Last version was included in Office 2013.[84]
Microsoft Mail: Mail client (in old versions of Office, later replaced by Microsoft
Schedule Plus and subsequently Microsoft Outlook).
Microsoft Office Document Image Writer: a virtual printer that takes documents from
Microsoft Office or any other application and prints them, or stores them in an image
file as TIFF or Microsoft Document Imaging Format format. It was discontinued with
Office 2010.[85]
Discontinued applications and features
Microsoft Office Document Imaging: an application that supports editing scanned
documents. Discontinued with Office 2010.[85]
Microsoft PhotoDraw 2000: A graphics program that was first released as part of the
Office 2000 Premium Edition. A later version for Windows XP compatibility was
released, known as PhotoDraw 2000 Version 2. Microsoft discontinued the program in
2001.
Microsoft Schedule Plus: Released with Office 95. It featured a planner, to-do list, and
contact information. Its functions were incorporated into Microsoft Outlook.
Microsoft Virtual PC: Included with Microsoft Office Professional Edition 2004 for Mac.
Microsoft discontinued support for Virtual PC on the Mac in 2006 owing to new Macs
possessing the same Intel architecture as Windows PCs.[86] It emulated a standard PC
and its hardware.
Discontinued applications and features
Microsoft Vizact 2000: A program that "activated" documents using HTML, adding
effects such as animation. It allows users to create dynamic documents for the Web.
Development has ended due to unpopularity.
Office Assistant, included since Office 97 (Windows) and Office 98 (Mac) as a part
of Microsoft Agent technology, is a system that uses animated characters to
offer context-sensitive suggestions to users and access to the help system. The
Assistant is often dubbed "Clippy" or "Clippit", due to its default to a paper
clip character, coded as CLIPPIT.ACS. The latest versions that include the Office
Assistant were Office 2003 (Windows) and Office 2004 (Mac).
Microsoft Office Groove Server: Centrally managing all deployments of Microsoft Office
Groove in the enterprise
Microsoft Office Project Portfolio Server: Allows creation of a project portfolio, including
workflows, hosted centrally
Office Live
Office Live Small Business: Web hosting services and online collaboration tools for small
businesses
Office Live Workspace: Online storage and collaboration service for documents, superseded
by Office Online
Another point of criticism Microsoft Office has faced was the lack of support in its Mac
versions for Unicode and Bi-directional text languages, notably Arabic and Hebrew.
This issue, which had existed since the first release in 1989, was only addressed in the
2016 version
Windows versions
Microsoft Office for Windows[edit]
Microsoft Office for Windows[92] started in October 1990 as a bundle of three applications designed
for Microsoft Windows 3.0: Microsoft Word for Windows 1.1, Microsoft Excel for Windows 2.0, and
Microsoft PowerPoint for Windows 2.0.[93]
Microsoft Office for Windows 1.5 updated the suite with Microsoft Excel 3.0.[94]
Version 1.6[95] added Microsoft Mail for PC Networks 2.1 to the bundle.[96]
Microsoft Office 3.0,[97] also called Microsoft Office 92, was released on 30 August 1992
and[98] contained Word 2.0, Excel 4.0, PowerPoint 3.0 and Mail 3.0. It was the first version of Office
also released on CD-ROM.[99] In 1993, The Microsoft Office Professional[100] was released, which
added Microsoft Access 1.1.[101]
Microsoft Office 4.0 was released containing Word 6.0, Excel 4.0a, PowerPoint 3.0 and Mail in
1993.[102] Word's version number jumped from 2.0 to 6.0 so that it would have the same version
number as the MS-DOS and Macintosh versions (Excel and PowerPoint were already numbered
the same as the Macintosh versions).
Windows versions
Microsoft Office 4.2 for Windows NT was released in 1994 for i386, Alpha,[103] MIPS and
PowerPC[104] architectures, containing Word 6.0 and Excel 5.0 (both 32-bit,[105] PowerPoint 4.0 (16-
bit), and Microsoft Office Manager 4.2 (the precursor to the Office Shortcut Bar)).
Microsoft Office 95 was released on 24 August 1995. Software version numbers were altered
again to create parity across the suiteevery program was called version 7.0 meaning all but Word
missed out versions. It was designed as a fully 32-bit version to match Windows 95. Office 95 was
available in two versions, Office 95 Standard and Office 95 Professional. The standard version
consisted of Word 7.0, Excel 7.0, PowerPoint 7.0, and Schedule+ 7.0. The professional edition
contained all of the items in the standard version plus Microsoft Access 7.0. If the professional
version was purchased in CD-ROM form, it also included Bookshelf.[citation needed]
The logo used in Office 95 returns in Office 97, 2000 and XP. Microsoft Office 98 Macintosh
Edition also uses a similar logo.
Microsoft Office 97 (Office 8.0) included hundreds of new features and improvements, such as
introducing command bars, a paradigm in which menus and toolbars were made more similar in
capability and visual design. Office 97 also featured Natural Language Systems and grammar
checking. Office 97 was the first version of Office to include the Office Assistant. In Brazil, it was
also the first version to introduce the Registration Wizard, a precursor to Microsoft Product
Activation.
Windows versions
Microsoft Office 2000 to 2003[edit]
Microsoft Office 2000 (Office 9.0) introduced adaptive menus, where little-used options were
hidden from the user. It also introduced a new security feature, built around digital signatures, to
diminish the threat of macro viruses. Office 2000 automatically trusts macros (written in VBA 6) that
were digitally signed from authors who have been previously designated as trusted. The
Registration Wizard, a precursor to Microsoft Product Activation, remained in Brazil and was also
extended to Australia and New Zealand, though not for volume-licensed editions. Academic
software in the United States and Canada also featured the Registration Wizard.
Microsoft Office XP (Office 10.0 or Office 2002) was released in conjunction with Windows XP, and
was a major upgrade with numerous enhancements and changes over Office 2000. Office XP
introduced the Safe Mode feature, which allows applications such as Outlook to boot when it might
otherwise fail by bypassing a corrupted registry or a faulty add-in. Smart tag is a technology
introduced with Office XP in Word and Excel and discontinued in Office 2010. Office XP includes
integrated voice command and text dictation capabilities, as well as handwriting recognition. It was
the first version to require Microsoft Product Activation worldwide and in all editions as an anti-
piracy measure, which attracted widespread controversy.[106] Product Activation remained absent
from Office for Mac releases until it became introduced in Office 2011 for Mac..
Microsoft Office 2003 (Office 11.0) was released in 2003. It featured a new logo. Two new
applications made their debut in Office 2003: Microsoft InfoPath and OneNote. It is the first version
to use new, more colorful icons. Outlook 2003 provides improved functionality in many areas,
including Kerberos authentication, RPC over HTTP, Cached Exchange Mode, and an improved junk
mail filter.
Windows versions
Microsoft Office 2007 and 2010[edit]
Microsoft Office 2007 (Office 12.0) was released in 2007. Office 2007's new features include a
new graphical user interface called the Fluent User Interface,[107] replacing the menus and toolbars
that have been the cornerstone of Office since its inception with a tabbed toolbar, known as
the Ribbon; new XML-based file formats called Office Open XML; and the inclusion of Groove,
a collaborative software application.[108]
Microsoft Office 2010 (Office 14.0, because Microsoft skipped 13.0[109]) was finalized on 15 April
2010 and made available to consumers on 15 June 2010.[110][111] The main features of Office 2010
include the backstage file menu, new collaboration tools, a customizable ribbon, protected view and
a navigation panel. This is the first version to ship in 32-bit and 64-bit variants. Microsoft Office 2010
featured a new logo, which resembled the 2007 logo, except in gold, and with a modification in
shape.[112]
A technical preview of Office 2013 (Build 15.0.3612.1010) was released on 30 January 2012, and a
Customer Preview version was made available to consumers on 16 July 2012.[114] It sports a
revamped application interface; the interface is based on Metro, the interface of Windows
Phone and Windows 8. Microsoft Outlook has received the most pronounced changes so far; for
example, the Metro interface provides a new visualization for scheduled tasks. PowerPoint includes
more templates and transition effects, and OneNote includes a new splash screen.[115] On 16 May
2011, new images of Office 15 were revealed, showing Excel with a tool for filtering data in a
timeline, the ability to convert Roman numerals to Arabic numerals, and the integration of advanced
trigonometric functions. In Word, the capability of inserting video and audio online as well as the
broadcasting of documents on the Web were implemented.[116] Microsoft has promised support for
Office Open XML Strict starting with version 15, a format Microsoft has submitted to the ISO for
interoperability with other office suites, and to aid adoption in the public sector.[117] This version can
read and write ODF 1.2 (Windows only).[118]
On 24 October 2012, Office 2013 Professional Plus was released to manufacturing and was made
available to TechNet and MSDN subscribers for download.[119] On 15 November 2012, the 60-day
trial version was released for public download.[120]
Microsoft Office 2016
On 22 January 2015, the Microsoft Office blog announced that the next version of the suite for
Windows desktop, Office 2016, was in development. On 4 May 2015, a public preview of Microsoft
Office 2016 was released.[24][25][121] Office 2016 was released for OS X on 9 July 2015[7] and for
Windows on 22 September 2015.
Mac versions
Prior to packaging its various office-type Mac OS software applications into Office,
Microsoft released Mac versions of Word 1.0 in 1984, the first year of the Macintosh
computer; Excel 1.0 in 1985; and PowerPoint 1.0 in 1987.[122] Microsoft does not
include its Access database application in Office for Mac.
Microsoft has noted that some features are added to Office for Mac before they appear in
Windows versions, such as Office for Mac 2001's Office Project Gallery and
PowerPoint Movie feature, which allows users to save presentations as QuickTime
movies.[123][124] However, Microsoft Office for Mac has been long criticized for its lack of
support of Unicode and for its lack of support for right-to-left languages,
notably Arabic, Hebrew and Persian.
Mac versions
Microsoft Office for Mac was introduced for Mac OS in 1989, before Office was released
for Windows.[127] It included Word 4.0, Excel 2.2, PowerPoint 2.01, and Mail 1.37.[128] It
was originally a limited-time promotion but later became a regular product. With the
release of Office on CD-ROM later that year, Microsoft became the first major Mac
publisher to put its applications on CD-ROM.[129]
Microsoft Office 1.5 for Mac was released in 1991 and included the updated Excel 3.0,
the first application to support Apples System 7 operating system.[122]
Microsoft Office 3.0 for Mac was released in 1992. It included Word 5.0, Excel 4.0,
PowerPoint 3.0 and Mail Client. Excel 4.0 was the first application to support the
new AppleScript.[122]
Microsoft Office 4.2 for Mac was released in 1994. (Version 4.0 was skipped to
synchronize version numbers with Office for Windows.) Version 4.2 included Word 6.0,
Excel 5.0, PowerPoint 4.0, and Mail 3.2.[130] It was the first Office suite for the Power
Macintosh.[122] Its user interface was identical to Office 4.2 for Windows,[131] leading
many customers to comment that it wasn't Mac-like enough.[123] The final release for
Mac 68K was Office 4.2.1, which updated Word to version 6.0.1, somewhat improving
its performance.
Mac versions
Microsoft Office 2001 was launched in 2000 as the last Office suite for
the classic Mac OS. It required a PowerPC processor. This version
introduced Entourage, an e-mail client that included information management
tools such as a calendar, an address book, task lists and notes.
Microsoft Office v. X was released in 2001 and was the first version of
Microsoft Office for Mac OS X.[133] Support for Office v. X ended on 9 January
2007 after the release of the final update, 10.1.9[134] Office v.X includes Word
X, Excel X, PowerPoint X, Entourage X, MSN Messenger for
Mac and Windows Media Player 9 for Mac; it was the last version of Office for
Mac to include Internet Explorer for Mac
Mac versions
Office 2004
Microsoft Office 2004 for Mac was released on 11 May 2004.[136] It includes
Microsoft Word, Excel, PowerPoint, Entourage and Virtual PC. It is the final
version of Office to be built exclusively for PowerPC and to officially
support G3 processors, as its sequel lists a G4, G5 or Intel processor as a
requirement. It was notable for supporting Visual Basic for
Applications (VBA), which is unavailable in Office 2008. This led Microsoft to
extend support for Office 2004 from September 10, 2009 to January 10,
2012. VBA functionality was reintroduced in Office 2011, which is only
compatible with Intel processors.
Mac versions
Office 2008[edit]
Microsoft Office 2008 for Mac was released on 15 January 2008. It was the
only Office for Mac suite to be compiled as an universal binary, being the first
to feature native Intel support and the last to feature PowerPC support
for G4 and G5 processors, although the suite is unofficially compatible
with G3 processors. New features include native Office Open XML file format
support, which debuted in Office 2007 for Windows,[122] and
stronger Microsoft Office password protection employing AES-128 and SHA-
1. Benchmarks suggested that compared to its predecessor, Office 2008 ran
at similar speeds on Intel machines and slower speeds on PowerPC
machines.[137] Office 2008 also lacked Visual Basic for Applications (VBA)
support, leaving it with only 15 months of additional mainstream support
compared to its predecessor. Nevertheless, five months after it was released,
Microsoft said that Office 2008 was "selling faster than any previous version
of Office for Mac in the past 19 years" and affirmed "its commitment to future
products for the Mac."
Mac versions
Office 2011
Microsoft OneNote for Mac was released on 17 March 2014. It marks the
company's first release of the note-taking software on the Mac. It is available
as a free download to all users of the Mac App Store in OS X Mavericks.[140]
Despite dropping support for older versions of OS X and only keeping support
for 64-bit-only versions of OS X, these versions of OneNote and Outlook are
32-bit applications like their predecessors.
Mac versions
Office 2016
The first Preview version of Microsoft Office 2016 for Mac was released on 5
March 2015.[142] On 9 July 2015, Microsoft released the final version of
Microsoft Office 2016 for Mac which includes Word, Excel, PowerPoint,
Outlook and OneNote. It was immediately made available for Office 365
subscribers with either a Home, Personal, Business, Business Premium, E3
or ProPlus subscription. A non-Office 365 edition of Office 2016 was made
available as a one-time purchase option on 22 September 2015.