Welcome to MSDN Blogs Sign in | Join | Help

December 2005 - Posts

Thursday, December 29, 2005 3:12 PM

PivotTables 9: Great support for SQL Server Analysis Services

Today, I’ll start a series of articles on the improvements we’ve made to PivotTables connected to OLAP (OnLine Analytical Processing) data sources, specifically Microsoft SQL Server Analysis Services models (in addition to its relational database product,
Posted by David Gainer | 4 Comments
Thursday, December 22, 2005 10:28 AM

PivotTables VIII: “Defer Layout Update”, or adding multiple fields in one fell swoop

In this article, I’ll cover a small yet very useful PivotTable feature – deferring PivotTable updates. In current versions of Excel, PivotTables are updated each time a field is added, removed, or moved to a different position. For PivotTables based on
Posted by David Gainer | 16 Comments
Filed under:
Wednesday, December 21, 2005 9:57 PM

PivotTable VII: – Conditional formatting gets even better, or visualizing your data in PivotTables

In a series of previous articles I introduced the new conditional formatting capabilities in Excel 12 (see here for the whole series of posts). Today I want to add one more article to the series, which is the work we have done to make conditional formatting
Posted by David Gainer | 8 Comments
Tuesday, December 20, 2005 4:56 PM

PivotTables VI: – Sorting and filtering

As I mentioned a few articles back, PivotTables enable users to summarize data in an easy-to-read report. Once a user has a summary of something they are interested in, they often want to further explore their data by seeing it ordered differently, by
Posted by David Gainer | 8 Comments
Filed under:
Thursday, December 15, 2005 3:01 PM

PivotTables V: Context menus

Today I wanted to talk about PivotTable context menus, for two reasons … first, because we have updated them to make them more useful, and second, because we have added some neat new features that are exposed primarily in context menus. All of this is
Posted by David Gainer | 17 Comments
Filed under:
Wednesday, December 14, 2005 4:00 PM

PivotTables part 4: Task-oriented UI, or “improvements the Ribbon affords us”, and some bonus talk about dialogs

As I mentioned a few posts back, one of the key goals for PivotTables in Excel 12 was to use the Ribbon and new dialogs to expose PivotTables’ capabilities to a much broader range of users. Today I want to take a closer look at the new user interface
Posted by David Gainer | 7 Comments
Filed under:
Tuesday, December 13, 2005 9:03 AM

PivotTables part 3: More clickable, more compact, and nicely styled

Today, I would like to cover some of the improvements we made in Excel 12 to make PivotTables easier to read and explore. Expand Collapse One of the nice exploration features of PivotTables is the ability to expand and collapse items in order to view
Posted by David Gainer | 16 Comments
Filed under:
Friday, December 09, 2005 12:25 PM

PivotTables part 2: Creating summary reports made easy

One of the goals we had for our PivotTable work in Excel 12 was to make creating PivotTables a much more approachable task. In this post, I would like to walk through an example of creating a PivotTable in order to highlight the changes we have made in
Posted by David Gainer | 11 Comments
Filed under:
Tuesday, December 06, 2005 5:40 PM

PivotTables – overview of improvements in Excel 12

PivotTables are designed to help users make sense of large amounts of data by providing an easy way to build a summarized report. In addition, PivotTables can be rearranged easily, so that once you have some summary data in a PivotTable, you can look
Posted by David Gainer | 19 Comments
Filed under:
Friday, December 02, 2005 5:00 AM

Quick detour #2: Working with currencies made easy …

Before I dive into PivotTables, I thought I would mention an Excel 12 feature that resulted from collaboration with our international subsidiaries. Users that work outside North America (and even some users that work within North America) build a lot
Posted by David Gainer | 8 Comments
Thursday, December 01, 2005 4:46 PM

Excel Services part 12: Unsupported features

In the second article I wrote about Excel Services , I discussed the scenarios that we are targeting with this initial release and also a few scenarios that we will not support. Today I wanted to provide further detail on the latter – specifically, the
Posted by David Gainer | 11 Comments
Filed under:
 
Page view tracker