Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Tables   (RSS)
Friday, April 18, 2008 2:50 PM

Building the Excel Media Player – Part 3

Last post we talked about how to use Excel as a flexible development environment and touched on how to use ActiveX Controls to enhance your solution and using tables programmatically to manipulate data. In this post we are going to drill into how to add
Posted by Joseph Chirilov | 1 Comments
Filed under: ,
Wednesday, April 16, 2008 8:31 PM

Building the Excel Media Player – Part 2

Last post we talked about how to use Excel as a flexible development environment and touched on the benefits of using Office graphics to build your UI. This post goes into how to use ActiveX controls in Excel and how to contain and manipulate data in
Posted by Joseph Chirilov | 2 Comments
Filed under: ,
Monday, April 14, 2008 5:39 PM

Building the Excel Media Player – Part 1

Today's author, Jon Adams, a Tester on the Excel team. A copy of the spreadsheet discussed in this post can be found as an attachment at the bottom of this post. As you are probably well aware, Excel is a very versatile tool and is often used in ways
Posted by Joseph Chirilov | 5 Comments
Filed under: ,

Attachment(s): MediaPlayer.xlsm
Wednesday, November 28, 2007 1:46 PM

Tracking Split Costs

Today’s Author: Joe Chirilov , a program manager on the who has done a lot of work on both the Excel and Excel Services teams. Joe is going to discuss a spreadsheet he recently built using Excel 2007. Recently a large group of friends and I went on a
Posted by David Gainer | 12 Comments
Tuesday, July 18, 2006 6:43 AM

Fun With Tables

A few weeks ago when I asked readers what they wanted to see in the way of content over the next few months, a few people suggested some discussion about everyday use. Accordingly, I am going to write today about some things I was doing with Tables in
Posted by David Gainer | 13 Comments
Monday, November 07, 2005 11:43 AM

Tables Part 7: Good-looking, well-behaved table formatting made easy …

If you’ve been reading the last few posts on tables, you may have noticed that the screenshots all had tables with formatting applied to the entire table. You may have thought I spent lots of time manually formatting the tables to look nice for this blog
Posted by David Gainer | 12 Comments
Filed under:
Friday, November 04, 2005 3:13 PM

Tables Part 6: Removing duplicates from tables (and ranges) of data

Being able to remove duplicate rows of information from a table of data is a request we hear fairly often from our customers (and one of the top questions in the comments in this blog). Some users know that this capability exists in Excel today; unfortunately
Posted by David Gainer | 17 Comments
Filed under:
Wednesday, November 02, 2005 4:42 PM

Tables Part 5: Everything you wanted to know about sorting in Excel 12

I mentioned in my previous post that the three-condition limit on sorting (Data|Sort) has been removed in Excel 12. As someone correctly pointed out in a comment many posts ago, this means the current sort dialog has changed in Excel 12. Here’s what the
Posted by David Gainer | 17 Comments
Filed under:
Tuesday, November 01, 2005 3:30 PM

Tables Part 4: AutoFilter improvements: much more than just multi-select …

Sorting and filtering are two of the most important types of basic analysis that you can do with data. In Excel 12, we have improved sort and filter functionality to better expose common tasks, to make key tasks simple, and to enable scenarios that were
Posted by David Gainer | 16 Comments
Filed under:
Friday, October 28, 2005 10:25 PM

Tables Part 3: Using Formulas with Tables

One of our goals with tables was to create a set of features that reduce the overall maintenance required to keep a spreadsheet functioning well over time. This involves making spreadsheets less prone to error, as well as making them more understandable
Posted by David Gainer | 38 Comments
Filed under:
Thursday, October 27, 2005 10:42 AM

Tables Part 2: Stickiness, Structured Selection, And More

One of the key benefits of tables is how other features in Excel 12 behave more predictably and more like you would expect when a table is present. This is made possible by the fact that Excel knows exactly where the table starts and ends, where the header
Posted by David Gainer | 22 Comments
Filed under:
Tuesday, October 25, 2005 3:56 PM

Tables Part 1: Working With Tables Of Data

For the next few posts, I’d like to spend some time explaining the work we’ve done in Excel 12 to improve the experience of working with tabular data in Excel. One thing that we see pretty much every Excel user doing with some frequency is working with
Posted by David Gainer | 29 Comments
Filed under:
Wednesday, September 28, 2005 1:22 PM

The big picture ...

Before I carry on digging into the details of the new and improved features in Excel 12, I wanted to make sure everyone had a good sense for the work we’ve done in this version. When we were planning Excel 12, we spent a significant amount of time talking
Posted by David Gainer | 18 Comments
 
Page view tracker