What Is The Use Of Microsoft Office Excel 2010

• What Is The Use Of Microsoft Office Excel 2010 free. download full Version
• What Is The Use Of Microsoft Office Excel 2010 Free Download
• Microsoft Office Excel 2010 Free Download Pc
• How To Microsoft Office Free

Find training courses for Excel. Microsoft Office 2010 also saw the inclusion of a text translation tool, as well as a tool for taking and exporting screenshots. Users can also apply effects to any images that are used in any documents. Microsoft Office 2010 (codenamed Office 14) 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. Microsoft Office Excel 2010. By Microsoft Free to try. Download.com has removed the direct-download link and offers this page for informational purposes only. Developer's Description.

Applies to: SharePoint Server 2010 How do you save document as pdf.

Excel Services is a service application that enables you to load, calculate, and display Microsoft Excel workbooks on Microsoft SharePoint Server 2010. Excel Services was first introduced in Microsoft Office SharePoint Server 2007.

By using Excel Services, you can reuse and share Excel workbooks on SharePoint Server 2010 portals and dashboards. For example, financial analysts, business planners, or engineers can create content in Excel and share it with others by using an SharePoint Server 2010 portal and dashboard—without writing custom code. You can control what data is displayed, and you can maintain a single version of your Excel workbook.

There are four primary interfaces for Excel Services:

• An Excel Web Access Web Part, which enables you to view and interact with a live workbook by using a browser

• Excel Web Services for programmatic access

• An ECMAScript (JavaScript, JScript) object model for automating and customizing, and to drive the Excel Web Access control and help build more compelling, integrated solutions

• A Representational State Transfer (REST) API for accessing workbook parts directly through a URL

You can also extend Excel Calculation Services by using user-defined functions (UDFs).

Note

For more information about Excel Calculation Services, see Excel Services Architecture.

By using Excel Services, you can view live, interactive workbooks by using only a browser. This means that you can save Excel workbooks and interact with them from within portal sites.

You can also interact with Excel-based data by sorting, filtering, expanding, or collapsing PivotTables, and by passing in parameters; this provides the ability to perform analysis on published workbooks. How to restore steam backup. You can interact with a workbook without changing the published workbook—which is valuable for report authors and report consumers.

Excel Services supports workbooks that are connected to external data sources. You can embed connection strings to external data sources in the workbook or save them centrally in a data connection library file.

You can also make selected cells in worksheets editable by making them named ranges (parameters). Items that you choose to make viewable, when you save to Excel Services, appear in the Parameters pane in Excel Web Access. You can change the values of these named ranges in the Parameters pane and refresh the workbook. You can also use the portal's filter Web Part to filter several Web Parts (Excel Web Access and other types of Web Parts) together.

However, you cannot use Excel Services to create new workbooks or to edit existing workbooks. To author a workbook for use with Excel Services, you can use Microsoft Office Excel 2007 or Microsoft Excel 2010.

Note

Microsoft Excel Web App, part of Microsoft Office Web Apps, also supports Excelworkbooks in the browser. For more information about Excel Web App, see Getting Started—Office Web Apps.

Excel Services also has a Web service. You can use Excel Web Services to load workbooks, set values in cells and ranges, refresh external data connections, calculate worksheets, and extract calculated results (including cell values, the entire calculated workbook, or a snapshot of the workbook). In SharePoint Server 2010, you can also save, save a copy, and participate in collaborative editing sessions by using Excel Web Services.

Note

For more information about snapshots, see How to: Get an Entire Workbook or a Snapshot.

Excel Services supports UDFs, which you can use to extend the capabilities of Excel Calculation Services—for example, to implement custom calculation libraries or to read data from Web services and data sources that are not natively supported by Excel Services.

Excel Services is designed to be a scalable, robust, enterprise-class server that provides feature and calculation fidelity with Excel.

Scenarios and Features

Excel Services supports many different scenarios and features, some of which are described in this section.

Business Intelligence Portal and Workbook Analysis

A business intelligence portal displays scorecards and reports, and enables users to explore data by using only a browser. The BI Center feature in SharePoint Server includes a business intelligence portal and dashboard functionalities. Figure 1 shows a report center dashboard with a library of reports, a chart, and Key Performance Indicators (KPIs) already set up.

Excel Services also enables you to calculate data on the server. Excel Services participates in the BI Center by providing the ability to calculate and expose Excel-based content on integrated BI dashboards.You can display an Excel workbook by using the Excel Web Access Web Part, connect to external data sources, and further interact with the data in the workbook.

Figure 1 shows a dashboard with a filter Web Part, and Excel workbooks displayed by using Excel Web Access Web Parts.

Figure 1. Dashboard with filtering and Excel content

In addition to participating in integrated dashboards, Excel Services can also be used to display all or part of Excel workbooks to enable users to interact with that content in the familiar Excel user interface. Figure 2 shows a range being displayed, and cells being exposed for user input through parameters. Designating specific cells as parameters enables users to change values in those cells in a worksheet by using the edit boxes in the right pane. Excel Services then recalculates the worksheet based on the new values.

If you want to use certain functionalities in Excel or if you want to analyze a workbook by using all Excel functionalities, you can open a workbook in Excel by clicking Open in Excel. You can also open a workbook in Excel to print it and to work offline.

Note

To open a workbook by using the Open in Excel command, you must have 'open' rights. For more information, see the next section, Managing Workbooks, and User Permissions and Permission Levels on TechNet. Users who do not have 'open' rights can still open a snapshot in Excel.

Figure 2. Using the Parameters pane

To open a workbook by using the Open in Excel command, you must have 'open' rights. For more information, see the next section, Managing Workbooks, and User Permissions and Permission Levels on TechNet. Users who do not have 'open' rights can still open a snapshot in Excel.

Figure 2. Using the Parameters pane

You can also analyze, pivot, and interact with data by using Excel Web Access.

For more information about Excel Services and business intelligence capability in SharePoint Server 2010, see the business intelligence documentation in SharePoint Server Help.

Managing Workbooks

The workbook management and lockdown capabilities of Excel Services enable you to:

• Maintain only one copy of a workbook, that is created and changed by a trusted author in a central, secure place, instead of maintaining multiple copies on each user's computer. The correct version of the worksheet is easier to find, share, and use from within Excel, SharePoint, and other applications.

• Secure and protect workbook models and back-end data. You can give users view-only rights to limit access to the workbook. For example, you can prevent users from opening a workbook by using Excel or you can control what they are allowed to view in a workbook. Users can have browser-based access to the content in a workbook that the author wants to share, but no ability to open the workbook in the Excel client, view formulas, or view supporting content or other intellectual property that may be in the workbook.

• Create snapshots of a workbook.

Excel Services is optimized for many users and many workbooks. It can also help load-balance calculation across the server farm.

For more information about managing workbooks by using Excel Services, see the SharePoint Server documentation on TechNet or SharePoint Server Help, or Office Online.

Programmatic Access Through Custom .NET Applications

You can create custom applications—for example, ASP.NET applications—that:

• Call Excel Web Services to access, parameterize, and calculate workbooks.

• Open, refresh external data, set cells or ranges, recalculate, participate in collaborative editing sessions with other applications or people, save, and save as.

• Use custom workflows to schedule calculation operations or send e-mail notifications. (This uses SharePoint capabilities and is not a native part of Excel Services.)

User-Defined Functions (UDFs)

You can also use Excel Services UDFs, which enable you to use formulas in a cell to call custom functions that are written in managed code and deployed to SharePoint Server 2010.

For more information about UDFs in Excel Services, see Understanding Excel Services UDFs.

ECMAScript (JavaScript, JScript)

You can also use the JavaScript object model in Excel Services to automate, customize, and drive the Excel Web Access Web Part control. You can use the JavaScript object model to build more compelling and integrated solutions.

REST API

You can use the REST API in Excel Services to access workbook parts or elements directly through a URL. The discovery mechanisms built into the Excel Services REST API enable developers and users to explore the content of the workbook manually or programmatically.

For more information about the REST API in Excel Services, see Excel Services REST API.

See Also

Tasks

Concepts

Other Resources

Home > Sample chapters > Microsoft Office > Excel

• By Egbert Jeschke, Eckehard Pfeifer, Helmut Reinke, Sara Unverhau
• 12/22/2011

1. CUBEKPIMEMBER()

• CUBEKPIMEMBER()

• CUBEMEMBER()

• CUBEMEMBERPROPERTY()

• CUBERANKEDMEMBER()

• CUBESET()

• CUBESETCOUNT()

• CUBEVALUE()

Cube functions were introduced in Microsoft Excel 2007. They are used with connections to external SQL data sources and provide analysis tools. Data cubes are multidimensional sets of data that can be stored in a spreadsheet, providing a means to summarize information from the raw data source. A cube is different from queries in Microsoft Access or Microsoft SQL Server because the data in a cube is already grouped in hierarchies, and calculated measures are saved in the cube. This offers two advantages to the user: Summary information is readily available, and most of the heavy-duty calculations are performed on the server. The user does not have to spend much time consolidating the data in Excel. However, you cannot use calculated fields or elements for a PivotTable.

To use cube functions, you must be working with data that is available in one of these two forms:

• Through a connection to a SQL Server Analysis Services data source

• In an offline cube in the user's local file system

These conditions limit the usefulness of cube functions. So that you will be able to work through some examples, the sample files accompanying this book include offline cube and data connection files for the example outlined in Chapter 2, 'Using Functions and PowerPivot.'

However, you will have to change the sample data connection files (they have either the extension .odc for a workbook connection, or .oqy for Microsoft Query) because the path to a database must be the full path. Use Windows Notepad to change the paths as follows:

The prepared sample workbook serves as a guide. To avoid unnecessary errors when modifying this sample, perform the following steps to create your own workbook:

1. On the Insert tab, select PivotTable/Use External Data Source. (You can search for additional elements and use the existing data connection files.)

2. Virtual vertex muster 9 0 14 percent. Create the layout and include the content from the data source.

3. Use the cube functions.

When you open a workbook with data connections and use the default Excel settings, you have to explicitly allow these connections (click the Enable Content button, as shown in Figure 14-2). When you activate a document in Excel 2010, the document is trusted and you don't have to confirm the activation again until the trusted document is reset in the Trust Center.

Figure 14-2 The security warning that is shown when Excel is accessing external data.

The descriptions of the functions throughout the rest of this chapter refer to the example in Chapter 2. The example uses two store groups named North and South, which sell sweets (chocolate and cookies) from the years 2008 through 2011. Each store group consists of two stores. Table 14-1 describes the functions.

Table 14-1 Overview of the Cube Functions

CUBEKPIMEMBER()

Syntax CUBEKPIMEMBER(connection,kpi_name,kpi_property,caption)

Definition This function returns a Key Performance Indicator (KPI) property and displays the KPI name in the cell.

Arguments

What Is The Use Of Microsoft Office Excel 2010 free. download full Version

• connection (required) A string with the name of the workbook connection to the cube. After you enter the first quotation mark, the existing context-sensitive data connections are displayed (see Figure 14-4, shown later in this chapter in the description of CUBEMEMBER()).

• kpi_name (required) Specifies the name of the KPI in the cube.

• kpi_property (required) A KPI consists of several components that are specified by using an integer (see Table 14-2).

  Table 14-2 Integers for the Third Argument of the CUBEKPIMEMBER() Function

  Integer	MDX expression	Description Microsoft excel 2010.
  1	[KPIValue]	https://woodsxithuza1989.mystrikingly.com/blog/apple-numbers-for-dummies. Actual value
  2	[KPIGoal]	Target value
  3	[KPIStatus]	State of the KPI at a specific moment in time
  4	[KPITrend]	Measure of the value over time
  5	[KPIWeight]	Relative importance assigned to the KPI
  6	[KPICurrentTimeMember]	Temporal context for the KPI

• caption (optional) A string displayed in the cell instead of the caption of the KPI components in the cube.

What Is The Use Of Microsoft Office Excel 2010 Free Download

Background

Error values and messages provide information about incorrect or missing entries:

• If the connection name is not a valid workbook connection, the CUBEKPIMEMBER() function returns the #NAME? error.

• If the OLAP server (or the offline cube) is not available, you get an error message. The content of the affected cell doesn't change.

• CUBEKPIMEMBER() returns the #N/A error value when kpi_name or kpi_property is invalid.

• CUBEKPIMEMBER() might return the #N/A error when the connection to the data source is interrupted and cannot be re-established

You can combine CUBEKPIMEMBER() with CUBEVALUE(). Specify CUBEKPIMEMBER() as the second argument or reference for CUBEVALUE().

Example In this example, a KPI named average is saved in the cube. This cube calculates the average of the sales and the total number of sales as integers. Both values are also saved as measures in the cube but cannot be used to calculate fields in the PivotTable. The target value (goal) is $1,500. Figure 14-3 shows the example for cookies.

The formula

displays the word average. The formula

Microsoft Office Excel 2010 Free Download Pc

returns 1453 (the rounded average of all sales). In the second formula, you can enter a reference to the cell containing the first formula as the second argument. To get the target value of the average, use the formula

The value of 2 in the last argument is important, because it indicates, in this case, the target value.

You can use the cell containing the formula to create cell captions. The real content of the cell is more informative, as shown by using the CUBEVALUE() function.

Related resources

• By Chris Sorensen, Ammul Shergill
• Online video $299.99

• By Joan Lambert
• Book $24.99

How To Microsoft Office Free

• By Paul McFedries
• Book $24.99