October 2009 - Posts
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
Read More...
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
Read More...
More info and a fun video here: http://powerpivot.com/
Read More...
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
Read More...
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
Read More...
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,
Read More...
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
Read More...
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,
Read More...
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
Read More...
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
Read More...
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,
Read More...
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
Read More...
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
Read More...
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
Read More...
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
Read More...
Exploring large data sets and creating filters has never been easier than with Excel 2010. Tables, PivotTables and PivotCharts now have a new search functionality that easily enables you to find what you need, filter and repeat for a faster more efficient
Read More...
