These articles cover the usage of Excel specific features.
Excel Tables (Part 6) - Preserving Entry Order
How to return an Excel Table to its original order after sorting
19-Sep-2013
Excel Tables (Part 5) - Running Totals
How to add running totals or a running balance to Excel Tables.
25-Jun-2013
Excel Tables (Part 3) - Structured References
A short overview of structured references used in Excel Tables
31-May-2013
Excel Tables (Part 2) - Creating an Excel Table
How to create an Excel table starting from a few column headings
31-May-2013
Excel Tables (Part 1) - An Introduction
An introduction illustrating the difference between an ordinary Range based Table and an Excel Table
21-May-2013
Sumif and Sumifs. Conditional summation
An introduction to the SUMIF and SUMIFS function and how to use them.
11-Apr-2013
What is that dollar in the formula? Relative and absolute references
A look at the difference between relative and absolute references, including when and how to apply them.
1-Mar-2013
How to get graphs to update automatically when new data is added to a plain table
Part 2 of 2 - How to extend plain tables without breaking everything, this time looking a graphs.
27-Feb-2013
How to get formulas to update automatically when new data is added to a plain table
Part 1 of 2 - How to extend plain tables without breaking everything, introducing the problem and a possible solution for formulas.
26-Feb-2013