Table Slicers in Microsoft Excel 2013

Slicers were introduced in Excel 2010 for PivotTables. What are slicers you ask? If you don't know, well, you're in for a treat. Here is some background information to bring you up to speed. Introducing Excel 2010 Slicers Use slicers to filter PivotTable data Excel 2010 Slicers by Mike Alexander PivotTable Slicers by Jan Karel [...]

March 7th, 2013|Tags: , , , , |5 Comments

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