Excel Articles

These articles cover the usage of Excel specific features.

How to return an Excel Table to its original order after sorting

How to add running totals or a running balance to Excel Tables.

How to add totals to Excel Tables and use filters.

A short overview of structured references used in Excel Tables

How to create an Excel table starting from a few column headings

An introduction illustrating the difference between an ordinary Range based Table and an Excel Table

An introduction to the SUMIF and SUMIFS function and how to use them.

A look at the difference between relative and absolute references, including when and how to apply them.

Part 2 of 2 - How to extend plain tables without breaking everything, this time looking a graphs.

Part 1 of 2 - How to extend plain tables without breaking everything, introducing the problem and a possible solution for formulas.

Back to the top