Results for:
tables

• Summing data across multiple criteria on multiple worksheets

  1 May 2013

  Liam Bastick has provided financial modelling services and training to clients for more than two decades. A senior accountant and professional mathematician, he has worked in numerous countries with many internationally recognized clients, providing and reviewing strategic and operational models for...
• Excel Geek Express—otherwise known as Quick Analysis

  18 Apr 2013

  Guest blogger Emily Warn is co-owner of Two Pens , which provides blogging services and teaches business how to write content that grows a social media following. My writer friends think I'm a geek. You can do what?! I can create a spreadsheet with book sales numbers that can be sorted by name and number...
• Excel table or PivotTable?

  18 Jan 2011

  In Excel there are tables and PivotTables. You may wonder why you'd need to create a table when the whole worksheet already looks like one. And you've heard about PivotTables and how complex they are. To be able to use either effectively, it helps to know what each of them does, and when to use one or...
• Give Excel tables a try

  14 Dec 2010

  Today's blog post on getting started with Excel tables is brought to you by Judi Hurlock, who writes Excel online training for Office.com. Okay, you’ve got data arranged in spreadsheet rows and columns, with column headers. So why try tables? Well, tables make it easy to format data, sort, filter...
• Table Improvements in Excel 2010

  25 Jan 2010

  Thanks to Ben Rampson for putting together this post. In today’s article I will outline three features in Office 2010 that improve table interaction in Excel. These feature additions build on the work started Excel 2007, addressing areas with significant customer feedback and further improving the feature...
• Excel 2010: New Search Filter

  1 Oct 2009

  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 way of navigating those enormous data sets. Filtering...
• A Robust Way To Reference Multiple Columns In a Table

  9 Apr 2009

  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 over time as requirements change. How do you you...
• Creating a Master-Detail View in Excel

  24 Oct 2008

  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 - it returns only a single value that matches...
• Building the Excel Media Player – Part 3

  18 Apr 2008

  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 custom Ribbon UI, context menus. Custom Context...
• Building the Excel Media Player – Part 2

  16 Apr 2008

  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 tables to drive your application. Using ActiveX Controls...
• Building the Excel Media Player – Part 1

  14 Apr 2008

  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 that are hard to imagine. This blog post is a follow...
• Tracking Split Costs

  28 Nov 2007

  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 multi-city tour of Europe that lasted a couple weeks...
• Fun With Tables

  18 Jul 2006

  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 Excel 2007, and tomorrow I will try to write a bit...
• Tables Part 7: Good-looking, well-behaved table formatting made easy …

  7 Nov 2005

  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 but in fact I hardly lifted a finger - I was using...
• Tables Part 6: Removing duplicates from tables (and ranges) of data

  4 Nov 2005

  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 it is buried under advanced filter settings...
• Tables Part 5: Everything you wanted to know about sorting in Excel 12

  2 Nov 2005

  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 new dialog will look like (as always, all the details...
• Tables Part 4: AutoFilter improvements: much more than just multi-select …

  1 Nov 2005

  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 not possible in earlier versions. We have done...
• Tables Part 3: Using Formulas with Tables

  28 Oct 2005

  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 days, months, and years after the spreadsheet was...
• Tables Part 2: Stickiness, Structured Selection, And More

  27 Oct 2005

  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 row is, which cells make up the data and which...
• Tables Part 1: Working With Tables Of Data

  25 Oct 2005

  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 tables. Tables can mean different things to different...