Expert Zone
-Ray Blake
Ray Blake is Head of Software Design for GR Business Process Solutions, a UK based consultancy.
He creates a range of IT solutions, primarily using Excel, Access and VBA.
Author website: www.grbps.com
-
Excel Lookup Functions Explained | Expert Zone
2007-03-06 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 | Expert Zone
2006-10-04 Analyzing performance data in Excel using array formula and dynamic range name methods.
-
Beyond Excel’s Holy Grail | Expert Zone
2006-08-08 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 | Expert Zone
2006-04-04 Why Excel is missing a charting feature and how that feature can be recreated using VBA.
-
Excel formula development in the real world | Expert Zone
2006-01-11 Name field reconcatenation in Excel explained through building worksheet formulae and custom VBA functions.