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

Browse by Tags

The Excel Team Blog
  • PowerPivotPro – Excel, SharePoint, and PowerPivot

    An interesting post on PowerPivotPro about Automating a report using Excel, SharePoint, and PowerPivot: “Let’s say you don’t have much need for handling large data volumes, your organization isn’t large enough to worry about spreadsheet robustness/business intelligence/one version of the truth, and you haven’t yet seen what DAX can do for you in pivots. Or maybe you get some of that, but don’t really understand this whole SharePoint thing. If you are in either of those boats, here’s an example from...
  • PowerPivot Alpha Geek Challenge

    There was a recent contest with PowerPivot, see the details of the contest here: http://wildfireapp.com/website/6/contests/19877?order=recency&view_entries=1   There were some great PowerPivot reports submitted, including some from our MVPs: Bill Jelen created a “Tag Cloud & SmartArt Updated Via PowerPivot!” report:   Tushar Mehta created a “Visualize US population trends over the last 150 years” report: Check out all of the entries here: http://wildfireapp.com/website/6/contests...
  • 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...
  • Announcing Office 2010 and PowerPivot Beta Availability

    From the Office 2010 Engineering blog : Today is an exciting day! At PDC we announced the availability of the public betas of Microsoft Office 2010, SharePoint Server 2010, Visio 2010, Project 2010 and Office Web Apps for business customers. If you’d like to be one of the millions of people who try, test and give feedback on the latest and greatest, you can download the betas at www.microsoft.com/2010 . We also announced that Microsoft Office Mobile 2010 beta is available now too, and you can download...
  • 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:...
  • New PowerPivot Site

    More info and a fun video here: http://powerpivot.com/ Read More...
  • Gemini Team Blog

    Last month, we blogged about Project Gemini, a cool new add-on to Excel and SharePoint that lets you do some powerful data analysis. Well, the first preview release of Gemini is out this month as part of the SQL Server 2008 R2 August CTP. The Gemini product team has started a new blog http://blogs.msdn.com/gemini . Check it out! It has information on how to download the Gemini bits and try it out with Excel 2010. Read More...
  • Sneak Preview of Project Gemini

    On the topic of “teasers”, one of the things we’ll be talking about in the coming weeks is project Gemini. I won’t get into the details just yet (otherwise it wouldn’t be a teaser), other than to say it’s a powerful data analysis feature, it’s an add-in to Excel (i.e. not a built-in Excel feature), and it’s the result of collaboration between the Excel and SQL teams. The BI Blog has been covering all news related to Gemini . From the BI Blog, here are a couple sneak peak videos : BI Power Hour: Sneak...
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.