Introduction To MS-OFFICE Innovation

admin@vrindawan.in

Introduction To MS-OFFICE Innovation

COURTESY :- vrindawan.in

Wikipedia

Microsoft Office, or simply Office, is a family of client software, server software, and services developed by Microsoft. It was first announced by Bill Gates on August 1, 1988, at COMDEX in Las Vegas. Initially a marketing term for an office suite (bundled set of productivity applications), the first version of Office contained Microsoft Word, Microsoft Excel, and Microsoft PowerPoint. Over the years, Office applications have grown substantially closer with shared features such as a common spell checker, Object Linking and Embedding data integration and Visual Basic for Applications scripting language. Microsoft also positions Office as a development platform for line-of-business software under the Office Business Applications brand.

Microsoft Office - Wikipedia

It contains a word processor (Word), a spreadsheet program (Excel) and a presentation program (PowerPoint), an email client (Outlook), a database management system (Access), and a desktop publishing app (Publisher).

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. Microsoft also maintains mobile apps for Android and iOS. Office on the web is a version of the software that runs within a web browser.

Since Office 2013, Microsoft has promoted Office 365 as the primary means of obtaining Microsoft Office: it allows the use of the software and other services on a subscription business model, and users receive feature updates to the software for the lifetime of the subscription, including new features and cloud computing integration that are not necessarily included in the “on-premises” releases of Office sold under conventional license terms. In 2017, revenue from Office 365 overtook conventional license sales. Microsoft also rebranded most of their standard Office 365 editions into Microsoft 365 to emphasize their current inclusion of products and services. In October 2022, Microsoft announced that all instances of the Office name would be replaced with Microsoft 365, starting with Office on the web in November that year, and the individual desktop and mobile apps of the Office suite in January 2023—effectively retiring the Office brand after 32 years.

  • Microsoft Word is a word processor included in Microsoft Office and some editions of the now-discontinued Microsoft Works. The first version of Word, released in the autumn of 1983, was for the MS-DOS operating system and introduced the computer mouse to more users. Word 1.0 could be purchased with a bundled mouse, though none was required. Following the precedents of Lisa Write and Mac Write, Word for Macintosh attempted to add closer WYSIWYG features into its package. Word for Mac was released in 1985. Word for Mac was the first graphical version of Microsoft Word. Initially, it implemented the proprietary .doc format as its primary format. Word 2007, however, deprecated this format in favor of Office Open XML, which was later standardized by Ecma International as an open format. Support for Portable Document Format (PDF) and OpenDocument (ODF) was first introduced in Word for Windows with Service Pack 2 for Word 2007.
  • Microsoft Excel is a spreadsheet editor that originally competed with the dominant Lotus 1-2-3 and eventually outsold it. Microsoft released the first version of Excel for the Mac OS in 1985 and the first Windows version (numbered 2.05 to line up with the Mac) in November 1987.
  • Microsoft PowerPoint is a presentation program used to create slideshows composed of text, graphics, and other objects, which can be displayed on-screen and shown by the presenter or printed out on transparencies or slides.
  • Microsoft One Note is a note taking program that gathers handwritten or typed notes, drawings, screen clippings and audio commentaries. Notes can be shared with other OneNote users over the Internet or a network. OneNote was initially introduced as a standalone app that was not included in any Microsoft Office 2003 edition. However, OneNote eventually became a core component of Microsoft Office; with the release of Microsoft Office 2013, OneNote was included in all Microsoft Office offerings. OneNote is also available as a web app on Office on the web, a freemium (and later freeware) Windows desktop app, a mobile app for Windows Phone, iOS, Android, and Symbian, and a Metro-style app for Windows 8 or later.
  • Microsoft Outlook (not to be confused with Outlook Express, Outlook.com or Outlook on the web) is a personal information manager that replaces Windows Messaging, Microsoft Mail, and Schedule+ starting in Office 97; it includes an e-mail client, calendar, task manager and address book. On the Mac OS, Microsoft offered several versions of Outlook in the late 1990s, but only for use with Microsoft Exchange Server. In Office 2001, it introduced an alternative application with a slightly different feature set called Microsoft Entourage. It reintroduced Outlook in Office 2011, replacing Entourage.
  • Microsoft One Drive is a file hosting service that allows users to sync files and later access them from a web browser or mobile device.
  • Microsoft Teams is a platform that combines workplace chat, meetings, notes, and attachments.

Windows-only apps

  • Microsoft Publisher is a desktop publishing app for Windows mostly used for designing brochures, labels, calendars, greeting cards, business cards, newsletters, web sites, and postcards.
  • Microsoft Access is a database management system for Windows that combines the relational Access Database Engine (formerly Jet Database Engine) with a graphical user interface and software development tools. Microsoft Access stores data in its own format based on the Access Database Engine. It can also import or link directly to data stored in other applications and databases.
  • Microsoft Project is a project management app for Windows to keep track of events and to create network charts and Gantt charts, not bundled in any Office suite.
  • Microsoft Visio is a diagram and flow charting app for Windows not bundled in any Office suite.

Mobile-only apps

  • Office Lens is an image scanner optimized for mobile devices. It captures the document (e.g. business card, paper, whiteboard) via the camera and then straightens the document portion of the image. The result can be exported to Word, OneNote, PowerPoint or Outlook, or saved in OneDrive, sent via Mail or placed in Photo Library.
  • Office Mobile is a unified Office mobile app for Android and iOS, which combines Word, Excel, and PowerPoint into a single app and introduces new capabilities as making quick notes, signing PDFs, scanning QR codes, and transferring files.
  • Office Remote is an application that turns the mobile device into a remote control for desktop versions of Word, Excel and PowerPoint.

Server applications

  • Microsoft SharePoint is a web-based collaborative platform that integrates with Microsoft Office. Launched in 2001, SharePoint is primarily sold as a document management and storage system, but the product is highly configurable and usage varies substantially among organizations. SharePoint services include:
    • Excel Services is a spreadsheet editing server similar to Microsoft Excel.
    • InfoPath Forms Services is a form distribution server similar to Microsoft InfoPath.
    • Microsoft Project Server is a project management server similar to Microsoft Project.
    • Microsoft Search Server
  • Skype for Business Server is a real-time communications server for instant messaging and video-conferencing.
  • Microsoft Exchange Server is a mail server and calendaring server.
  • Microsoft Sway is a presentation web app released in October 2014. It also has a native app for iOS and Windows 10.
  • Delve is a service that allows Office 365 users to search and manage their emails, meetings, contacts, social networks and documents stored on OneDrive or Sites in Office 365.
  • Microsoft Forms is an online survey creator, available for Office 365 Education subscribers.
  • Microsoft To Do is a task management service.
  • Outlook.com is a free webmail with a user interface similar to Microsoft Outlook.
  • Outlook on the web is a webmail client similar to Outlook.com but more comprehensive and available only through Office 365 and Microsoft Exchange Server offerings.
  • Microsoft Planner is a planning application available on the Microsoft Office 365 platform.
  • Microsoft Stream is a corporate video sharing service for enterprise users with an Office 365 Academic or Enterprise license.
  • Microsoft Bookings is an appointment booking application on the Microsoft Office 365 platform.Office on the web is a free lightweight web version of Microsoft Office and primarily includes three web applications: Word, Excel and PowerPoint. The offering also includes Outlook.com, One Note and One Drive which are accessible through a unified app switcher. Users can install the on-premises version of this service, called Office Online Server, in private clouds in conjunction with SharePoint, Microsoft Exchange Server and Microsoft Lync Server.

    Word, Excel, and PowerPoint on the web can all natively open, edit, and save Office Open XML files (docx, xlsx, pptx) as well as Open Document files (odt, ods, odp). They can also open the older Office file formats (doc, xls, ppt), but will be converted to the newer Open XML formats if the user wishes to edit them online. Other formats cannot be opened in the browser apps, such as CSV in Excel or HTML in Word, nor can Office files that are encrypted with a password be opened. Files with macros can be opened in the browser apps, but the macros cannot be accessed or executed. Starting in July 2013, Word can render PDF documents or convert them to Microsoft Word documents, although the formatting of the document may deviate from the original. Since November 2013, the apps have supported real-time co-authoring and auto saving files.

    Office on the web lacks a number of the advanced features present in the full desktop versions of Office, including lacking the programs Access and Publisher entirely. However, users are able to select the command “Open in Desktop App” that brings up the document in the desktop version of Office on their computer or device to utilize the advanced features there.

    Supported web browsers include Microsoft Edge, Internet Explorer 11, the latest versions of Firefox or Google Chrome, as well as Safari for OS X 10.8 or later.

    The Personal edition of Office on the web is available to the general public free of charge with a Microsoft account through the Office.com website, which superseded SkyDrive (now OneDrive) and Office Live Workspace. Enterprise-managed versions are available through Office 365. In February 2013, the ability to view and edit files on SkyDrive without signing in was added. The service can also be installed privately in enterprise environments as a SharePoint app, or through Office Web Apps Server. Microsoft also offers other web apps in the Office suite, such as the Outlook Web App (formerly Outlook Web Access), Lync Web App (formerly Office Communicator Web Access), Project Web App (formerly Project Web Access). Additionally, Microsoft offers a service under the name of Online Doc Viewer to view Office documents on a website via Office on the web.

    There are free extensions available to use Office on the web directly in Google Chrome and Microsoft Edge.

    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. E.g.:-

    • The toolbar, colored buttons and the gray-colored 3D look of Office 4.3 were added to Windows 95.
    • The ribbon, introduced in Office 2007, has been incorporated into several programs bundled with Windows 7 and later.
    • The flat, box-like design of Office 2013 (released in 2012) was replicated in Windows 8’s new UI revamp.

    Users of Microsoft Office may access external data via connection-specifications saved in Office Data Connection (.odc) files.

    Office, on all platforms, support editing both server files (in real time) and offline files (manually saved) in the recent years. The support for editing server files (in real time) was originally introduced (in its current form) after the introduction of One Drive (formerly Sky Drive). But, older versions of Office also have the ability to edit server files (notably Office 2007).