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

October 2009 - The Excel Team Blog

The Excel Team Blog
  • 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...
  • 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...
  • Are you an Office Developer? You'll Want to Read This:

    Today at the SharePoint conference the Office Developer Marketing Team announced the Office 2010 Application Compatibility Program . Details were posted today at Gray Knowlton's blog . Here's an excerpt from his post: With the great value Office 2010 brings for end users, IT Professionals and Developers, we are also investing heavily in making deployment of the new version of Office easier. As part of our focus on deployment, we have renewed priority on helping ensure applications and Add...
  • Learn More About Access 2010

    I know many Excel users also tend to be Access users, so I thought it would be a good idea to share this bit of news. The Access folks recently recorded a great video showcasing the major work that has gone into Access 2010. In short: Access solutions, built in Access and published to the web where users interact with forms and reports via the browser. Pretty exciting stuff. Check it out here: http://blogs.msdn.com/access/archive/2009/10/19/access-web-databases-and-the-access-show.aspx Read More...
    Filed under:
  • More updates from SPC

    Steve Tullis & Pej Javaheri presented “Intro to Excel and Excel Services 2010” to a standing room only crowd at SharePoint Conference 2010. Features demo’d include: Excel: Pivot Chart improvements Filter Search Named sets Improvements to conditional formatting Slicers Sparklines Excel Services: Client fidelity improvements & support of new Excel 2010 features (View) Support of workbooks containing images, VBA, etc. Edit & Collaboration in the Enterprise (SharePoint) and in the Cloud Read...
  • Office Web Apps Technical Preview Expanding

    From the Office Web Apps Blog : About a month ago I wrote about the Technical Preview on Windows Live. Since then we’ve seen a lot of interest in Office Web Apps and received numerous requests from people wanting to try them out. To make this possible, we are opening up the Technical Preview and inviting more people to try out the Office Web Apps. For a limited time, you can sign-up for a Technical Preview account here (if you are already a part of the technical preview, this link will generate an...
  • 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...
  • SPC Day 1: Keynote

    More dispatches from Charlie Ellis at SPC. Note, he mentions some new features we haven't yet talked about on the blog (spoilers!) but will soon! Three things really struck me during the keynote address: There’s just incredible momentum around SharePoint and a ton of excitement around SharePoint 2010 and all the great new social networking functionality, integration with the Office clients, the Web Apps, and – of course – the Business Intelligence in SharePoint. The atmosphere of the conference...
  • SharePoint Conference Starts Today

    The SharePoint Conference is on this week in Vegas. What does that have to do with Excel, you ask? Plenty! The conference represents the first time we’ve shared with customers publicly all the great work we’ve put into the next release of SharePoint, which includes, of course, Excel Services and other investments in BI. So there will be some exciting announcements and lots of information to absorb. We’ll be covering all the Excel related stuff on this blog over the next month or so. Here are some...
  • 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...
  • Going Back to the Topic of Functions For a Moment…

    A few weeks back I wrote several posts on the improvements we have made to Excel’s function library. I’d now like to share with you a draft of a whitepaper we are planning to release when Excel 2010 ships. The whitepaper describes all of the improvements we are making. It also includes detailed descriptions of the new algorithms used. The whitepaper contains much of what I have included in my previous posts; however, it also contains some more detailed information, especially in regards to the function...
  • 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...
1 2 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.