Why you should use structured references in tables

Tables were introduced in Excel 2007 and are a spin-off from the lists feature of previous versions. This blog post will be based on working with structured formulas in tables, as opposed to standard relative/absolute referencing. I consider this a basic level post. If you're not up to speed with tables, here is some reference [...]

January 7th, 2013|Tags: , , , , |9 Comments

Running Total in a Microsoft Excel Table

Running Total in an Excel Table INTRODUCTION Tables were introduced in Excel, 2007.  I love them, they’re very handy.  Along with them we were introduced to Table referencing.  This made it easy to identify parts of a Table.  It’s called “structured referencing”.  Here is pretty much the best resource for identifying structured referencing in Excel [...]

July 12th, 2012|Tags: , , , , |7 Comments