Excel Lookup Functions Explained
Using VLOOKUP, HLOOKUP, INDEX, and MATCH in Excel to interrogate data tables Lookup tables are fantastically useful things in Excel. I remember when someone showed me for the first time how to build a data table and perform some simple lookups on it. For the first time, I began to realise just how powerful Excel could be in the right hands.
Excel Performance Analysis the Professional Way
Analyzing performance data in Excel using array formula and dynamic range name methods.
Beyond Excel’s Holy Grail
Moving beyond a dependence on array formulae in Excel It's something of a rite of passage, really, the day when the intermediate Excel user discovers array formulae. If you haven't got to that stage just yet, stop reading now, but keep this article handy. When you get to the point (and you will) when you can't imagine life again without array formulae, take out this article and read it.
Automatic Chart Harmonisation
Why Excel is missing a charting feature and how that feature can be recreated using VBA.
Excel formula development in the real world
Name field reconcatenation in Excel explained through building worksheet formulae and custom VBA functions.