Browse by Tags
All Tags »
Tables (RSS)
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...
I’m sure many of you have built a spreadsheet like this before: you’ve got a table of data; one of the columns in this table contains a formula which references a span of columns in the same table. The number of columns you need to reference may change
Read More...
Today's author, Dan Battagin, a Program Manager on the Excel team, talks about joining two tables in Excel (a.k.a. returning multiple rows for VLOOKUP). Today, we'll take a look at the VLOOKUP function, and work out a way to get around its major drawback
Read More...
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
Read More...
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
Read More...
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
Read More...
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
Read More...
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
Read More...
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
Read More...
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
Read More...
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
Read More...
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
Read More...
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
Read 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
Read More...
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
Read More...
