Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.

Browse by Tags

  • Management Features of PowerPivot for SharePoint

    Thanks to John Hancock from the PowerPivot team for putting together this post. Previous articles have covered some of the features of PowerPivot for Excel, and shown how PowerPivot helps users build really powerful BI applications right in Excel. We have described some of the PowerPivot for SharePoint features on this blog as well as the PowerPivot blog , so for this article I will be focusing on the features that we provide to help IT to manage and understand the self-service BI activity. Self...
  • 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:...
Copyright Excel User Group and the relevant contributors, 2009. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.