February 2006 - Posts
Currently, the Excel development team is spending a lot of time tuning Excel 2007’s calculation performance to make it as fast as possible. Given the near-infinite variety of things we see people build in Excel, we are always looking for good examples
Read More...
A few months ago, I described the new features we have added to Excel 2007 in the area of conditional formatting. One of the new formats we added is called a “data bar” … check out this earlier post for a refresher , but the basic idea is that Excel draws
Read More...
One of the program managers on my team (Charlie) has put together a list of 214 keyboard shortcuts available in Excel. While it isn’t exhaustive (for example, it doesn’t cover shortcuts available in dialogs), I find it a useful presentation of the shortcuts
Read More...
Today, a video was released on Channel 9 where Mike Arcuri, Group Program Manager on the Office Business Intelligence team, walks through some of Excel 12's new features. Much (but not all) of this is what I covered recently in the PivotTable and the
Read More...
Over the past few months, I have been asked three specific questions repeatedly either via comments ore more often via email. One of them, "how do I sign up for the public beta", was one that I could answer (which is to register here ). Another one, which
Read More...
Now that we have covered OLAP formulas, I would like to explain a set of work we did in the area of “connection management” in Excel 12 workbooks. Specifically, I want to show you three new things that you can do in a workbook that is connected to external
Read More...
Actually, before I talk about data connections, I want to cover one other way that users can author OLAP formulas ... users can create a PivotTable bound to an OLAP cube and then use the Field List to quickly add all the fields that they care about to
Read More...
Previously when discussing CUBE functions, I showed a couple of examples of reports based on OLAP data that could be built using CUBE functions. Now I’d like to explain how we’ve done something very special with Formula AutoComplete to make it easy to
Read More...
I have had a number of emails in the last week asking for a list of the SQL Server Analysis Services features that we support, asking for a list of the SQL Server Analysis Services features that are new in their 2005 release, etc., so here is a list that
Read More...
Last time, I explained the seven new CUBE functions that are available in Excel 12 to fetch data from Analysis Services cubes. With the theory that a picture is worth a thousand words, I would like to walk through a few examples that illustrate how these
Read More...
OK, I am freshly back from a fascinating couple weeks of visiting a number of customers (thanks to all you that spent time with us over the last few weeks), so it is time to get back to talking about Excel 12 features. We’ve already talked about using
Read More...
