Excel Services

Last updated

Excel Services is a server technology included in SharePoint 2010 and SharePoint 2007. This shared service enables users to load, calculate, and display Excel 2010 workbooks on Microsoft Office SharePoint Server 2010.

Using Excel Services, users can reuse and share Excel workbooks on Microsoft Office SharePoint Server 2010 portals and dashboards. For example, they can create content in Excel 2010 and share it by using an Office SharePoint Server 2007 portal and dashboard. The entire workbook or just parts of it (such as just a single sheet, chart or table) can be shared.

End-users can view live, interactive workbooks using only a web browser. They can also interact with workbooks to explore data, and analyze Pivot Table reports and charts by using a browser. Excel Services supports workbooks that are connected to external data sources. Users can embed connection strings to external data sources in the workbook or save them centrally in a data connection library file.

Selected cells in worksheets can be made editable by making them named ranges or "parameters". Items which are set as "viewable", when they save to Excel Services, will appear in the Parameters pane in the browser. Users can change the values of these named ranges in the parameters pane and refresh the workbook. They can also use the portal's filter Web Part to filter several Web Parts (Excel Web Access and other types of web parts) together.

Related Research Articles

Microsoft Excel Spreadsheet, part of Microsoft Office

Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android and iOS. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications. It has been a very widely applied spreadsheet for these platforms, especially since version 5 in 1993, and it has replaced Lotus 1-2-3 as the industry standard for spreadsheets. Excel forms part of the Microsoft Office suite of software.

Microsoft Office suite of office software

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, 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, OLE 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. On July 10, 2012, Softpedia reported that Office was being used by over a billion people worldwide.

Microsoft Access Database manager that is part of the Microsoft Office package

Microsoft Access is a database management system (DBMS) from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools. It is a member of the Microsoft Office suite of applications, included in the Professional and higher editions or sold separately. It is also a member of the Microsoft 365 suite. Latest versions have more protections. A trial version of the software is available.

Microsoft Outlook Email client, task and calendar management software developed by Microsoft

Microsoft Outlook is a personal information manager software system from Microsoft, available as a part of the Microsoft Office suite. Though primarily an email client, Outlook also includes such functions as calendaring, task managing, contact managing, note-taking, journal logging, and web browsing.

File Explorer

File Explorer, previously known as Windows Explorer, is a file manager application that is included with releases of the Microsoft Windows operating system from Windows 95 onwards. It provides a graphical user interface for accessing the file systems. It is also the component of the operating system that presents many user interface items on the screen such as the taskbar and desktop. Controlling the computer is possible without Windows Explorer running.

Microsoft Project Project management software

Microsoft Project is a project management software product, developed and sold by Microsoft. It is designed to assist a project manager in developing a schedule, assigning resources to tasks, tracking progress, managing the budget, and analyzing workloads.

Microsoft Office 2003 Office suite by Microsoft

Microsoft Office 2003 is an office suite developed and distributed by Microsoft for its Windows operating system. Office 2003 was released to manufacturing on August 19, 2003, and was later released to retail on October 21, 2003. It was the successor to Office XP and the predecessor to Office 2007.

Microsoft Office XP Version of Microsoft Office suite

Microsoft Office XP is an office suite created and distributed by Microsoft for the Windows operating system. Office XP was released to manufacturing on March 5, 2001, and was later made available to retail on May 31, 2001. It is the successor to Office 2000 and the predecessor of Office 2003.

Microsoft Project Server

Microsoft Office Project Server is a project management server solution made by Microsoft since 2000. It uses Microsoft SharePoint as its foundation, and supports interface from either Microsoft Project as a client application or by web browser connecting to its Project Web App (PWA) component.

Outlook on the web

Outlook on the web is a personal information manager web app from Microsoft. It is included in Microsoft 365, Office 365, Exchange Server 2016/2019, and Exchange Online. It includes a web-based email client, a calendar tool, a contact manager, and a task manager. It also includes add-in integration, Skype on the web, and alerts as well as unified themes that span across all the web apps. Outlook on the web is navigated using the App Launcher icon which brings down a list of web apps from which the user may choose. In 2015, Microsoft started upgrading Outlook.com and Outlook on the web to use the Office 365 infrastructure, which was almost complete in January 2017 after the next version of Outlook.com was released.

Microsoft Office 2007 Version of Microsoft Office

Microsoft Office 2007 is a version of Microsoft Office, a family of office suites and productivity software for Windows, developed and published by Microsoft. It was released to manufacturing on November 3, 2006; it was subsequently made available to volume license customers on November 30, 2006, and later to retail on January 30, 2007, the same respective release dates of Windows Vista. It was preceded by Office 2003 and succeeded by Office 2010.

Microsoft Dynamics CRM is a customer relationship management software package developed by Microsoft. The product focuses mainly on sales, marketing, and service sectors, but Microsoft has been marketing Dynamics CRM as a CRM platform and has been encouraging partners to use its once proprietary, now Open Source framework to customize it. It is part of the Microsoft Dynamics family of business applications.

Microsoft InfoPath Microsoft Office suite application to design rich XML-based forms

Microsoft InfoPath is a software application for designing, distributing, filling and submitting electronic forms containing structured data. Microsoft initially released InfoPath as part of the Microsoft Office 2003 family. The product features a WYSIWYG form designer in which the various controls are bound to data, represented separately as a hierarchical tree view of folders and data fields.

Microsoft Office 2010

Microsoft Office 2010 is a version of the Microsoft Office productivity suite for Microsoft Windows. Office 2010 was released to manufacturing on April 15, 2010, and was later made available for retail and online purchase on June 15, 2010. It is the successor to Office 2007 and the predecessor to Office 2013. Research and development of Office 2010 began in 2006, before the release of its predecessor.

Microsoft Office PerformancePoint Server is a business intelligence software product released in 2007 by Microsoft. The product was generally an integration of the acquisitions from ProClarity - the Planning Server and Monitoring Server - into Microsoft's SharePoint server product line. Although discontinued in 2009, the dashboard, scorecard, and analytics capabilities of PerformancePoint Server were incorporated into SharePoint 2010 and later versions.

SharePoint

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.

Microsoft Search Server (MSS) is an enterprise search platform from Microsoft, based on the search capabilities of Microsoft Office SharePoint Server. MSS shares its architectural underpinnings with the Windows Search platform for both the querying engine and the indexer. Microsoft Search Server was once known as SharePoint Server for Search.

Windows Search, formerly known as Windows Desktop Search on Windows XP and Windows Server 2003, is a system-wide desktop search feature of Microsoft Windows.

IBM Cognos Analytics

IBM Cognos Business Intelligence is a web-based integrated business intelligence suite by IBM. It provides a toolset for reporting, analytics, scorecarding, and monitoring of events and metrics. The software consists of several components designed to meet the different information requirements in a company. IBM Cognos has components such as IBM Cognos Framework Manager, IBM Cognos Cube Designer, IBM Cognos Transformer.

SharePoint Dashboard

A dashboard is a document presenting the most significant information about a subject on a single page. Microsoft SharePoint is a web application platform launched in 2001 as a centralized replacement for multiple web applications and supports various combinations of enterprise website requirements. A Microsoft SharePoint Dashboard is a feature of the Microsoft SharePoint platform that aggregates data from other systems and displays it in a browser-based location.

References