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 PivotTable Slicers by Jan Karel Pieterse So you should know that [...]

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

Delete styles in MS Excel

  This is applicable to Excel 2007-2013. Styles are wonderful, and I've loved having them in Excel.  If you're not familiar with styles, check out these links: (Word 2007+) (Excel 2007+) (Excel 2003) Often times, especially when sharing files, perhaps emailing files back and forth to/from co-workers, a file can become [...]

January 14th, 2013|Tags: , , , , |12 Comments

Get Table Addresses

This was written with Excel 2010 in mind, but will work in 2007-2013. Version differences are pointed out where applicable. Screenshots are using 2010. In the spirit of working with tables via VBA, sometimes you may need to check the range of a table. This is fairly straight-forward in most cases, but sometimes it has [...]

January 14th, 2013|Tags: , , , , |6 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