Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.
The Excel Team Blog » All Tags » Overview (RSS)

Browse by Tags

  • Excel Services in SharePoint 2010 Dashboard Improvements

    Thanks to Dan Parish for putting together this post. One of the great things about Excel Services is the Excel Web Access (EWA) web part. This web part allows you to render entire workbooks, or just portions of a workbook (for example a chart or a Table) in a SharePoint dashboard page. For a high level overview of what you can do with the EWA in SharePoint 2007, take a look at some of our existing blog entries: Excel Services – Key Scenarios Excel services Part 5: All About “Interactivity” Excel...

  • Excel Services in SharePoint 2010 REST API Syntax

    As we saw in the previous post , using the Excel Services REST API is as simple as specifying a URI (Uniform Resource Identifier) in your web browser. In this post we’ll walk through the details of the URI syntax. We start out with a simple Excel workbook stored on a SharePoint 2010 server at the following URL: http://contoso/Finance/Shared%20Documents/Tax.xlsx This example workbook contains two named ranges, a chart, a table and a PivotTable. In order to create a URI that can be used to access the...

  • Simple Access to Spreadsheet Data Using the Excel Services 2010 REST API

    Thanks to Christian Stich for putting together this series on the REST API. Beginning our journey on all things Excel Services 2010, I thought I’d start off with a feature that’s been getting a lot of buzz lately since its introduction at the SharePoint Conference. What is it? The Excel Services 2010 REST API is a new programmability framework that allows for easy discovery of and access to data and objects within a spreadsheet. “Programmability” is almost a bit of a misnomer because in its simplest...

  • Excel Services 2010 Overview

    Thanks to Steve Tullis for putting together this post. Before delving into Excel Services 2010, I want to recap a point that some readers may not be aware of. The Excel team is delivering two browser-based solutions as part of the Office 2010 wave of products. The quick synopsis - here are the two solutions: Excel Services: Version two of our real-time, interactive, Excel-based reporting and dashboard capabilities which ship as part of SharePoint Server 2010. Also included are APIs which enable rich...

  • PowerPivot for SharePoint 2010 – The Business User’s Perspective

    This article continues the series on PowerPivot that started with an overview as well as an introduction to PowerPivot for Excel 2010. We’ll now focus on the support PowerPivot provides for collaboration. Frequently, business users need to share applications they create on their desktops with a workgroup. As it turns out, SharePoint provides a great platform that is critical for realizing the overarching goal of extending business intelligence technology to an organization: Great feature set for...

  • Using PowerPivot with Excel 2010

    In this blog article, we’ll step through using PowerPivot for Excel 2010 for building a rich application in Excel. Note: following screenshots describe the SQL Server 2008 R2 August Community Technology Preview (CTP) functionality for a feature codenamed Gemini. As recently announced , Gemini will be released under the PowerPivot brand. After installation, Gemini appears on the Excel 2010 ribbon: Importing Data Selecting the ‘Load & Prepare Data’ button launches the PowerPivot client window:...

  • Introducing PowerPivot

    Today we have a guest author from the SQL Server Analysis Services team, Ashvini Sharma, to tell us about the PowerPivot (née Gemini) feature that you may have heard about recently. PowerPivot is the recently announced name of technologies this blog previously referred to by its codename, Gemini. This article describes why there is a need for such a tool, and briefly what PowerPivot provides. More information is available on the PowerPivot blog . The Need for PowerPivot PivotTables continue to be...

  • All About SharePoint 2010

    The SharePoint blog has a pretty extensive write up detailing the innovations in SharePoint 2010 . Here are some Excel relevant excerpts: On Business Intelligence: Historically, business intelligence has been a specialized toolset used by a small set of users with little ad-hoc interactivity. Our approach is to unlock data and enable collaboration on the analysis to help everyone in the organization get richer insights. Excel Services is one of the popular features of SharePoint 2007 as people like...

  • A Few More PivotTable Improvements in Excel 2010

    Thanks to Diego Oppenheimer for putting together this post. In today’s post I will be covering a couple of smaller PivotTable features that we incorporated in Excel 2010. Most of these features have been longstanding customer requests or pain points that we felt could be addressed in this release. This includes fixing functionality that worked in versions of Excel previous to Excel 2007 (Filtering on calculated members) as well as making it easier to access features that historically our users have...

  • Excel 2010 PivotTable What-If Analysis (Writeback)

    Thanks to Diego Oppenheimer for putting together this post. When thinking of Excel as an OLAP analytical tool the first thing that usually comes to mind is the ability to quickly and easily analyze data from an OLAP data source. With the introduction of PivotTable What-If Analysis in Excel 2010 you can now easily modify this data as well. Put simply, PivotTable What-If Analysis is the ability to modify values in PivotTable cells, recalculate the PivotTable with those values and, if the results are...

  • PivotTable Named Sets in Excel 2010

    Thanks to Diego Oppenheimer for putting together this post. When working with PivotTables, you often come across scenarios where you want to work with the same set of items from the data over and over again. For example, you might be a regional manager and you want to create a set of reports about the branches in your particular region, but the list of which are “your” branches isn’t in the data source, so you always have to filter to the same eight branches, like so: Example of two PivotTable reports...

  • Interacting with Slicers

    In part 2 of this 3 part series introducing slicers, I’ll show you some of the ways you can interact with slicers. Part 1 can be found here . Slicers reveal where the data is Let’s say I want to slice on my customer data for yesterday, and I only want to see a list of customers with Partial College and Bachelors education levels. As I click on these two tiles to select them, they turn blue. As it turns out, yesterday all my customers were either Partial College or Partial High School. I had no customers...
    Filed under: , ,

  • Easy (and Even Fun!) Data Exploration: Introducing Excel 2010 Slicers

    Thanks to Karen Cheng for putting together this series on Slicers. New to Excel 2010 are slicers, which are visual controls that allow you to quickly and easily filter your data in an interactive way. They float above the grid, like charts and shapes. Here’s an example of the same slicer in three different states. You can select one, all, or some countries. A slicer acts like a report filter, so you can hook it up to a PivotTable, PivotChart, or CUBE function to create an interactive report. Shows...
    Filed under: , ,

  • New and Improved Solver

    Thanks to Eric Patterson for putting together this post. In Excel 2010, we have made a number of improvements to Solver that make it easy for beginners to get started and more advanced ones to find solutions to all types of problems. The purpose of this post is to review the improvements to Solver, and so assumes some familiarity with the tool. If you are not familiar with Solver, you can learn more about Solver from Office Online . The help topic applies to the Solver that ships in Excel 2007 and...
    Filed under: , ,

  • New Functions Bring New UI

    In the past two posts I talked about all of the improvements we have made to the function library in terms of accuracy and consistency. In this post I will describe the UI changes we have made to help users take advantage of these improvements in Excel 2010. In addition I will also talk about the backward compatibility experience for the new function library. Function Improvements UI Changes As a result of the changes we’ve made to improve the consistency of Excel’s function library, we have introduced...
< Previous 1 2 3 Next >
Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.