Monday, September 30, 2013
So I was watching this +Bill Jelen video and noticed how he was normalizing data - his data was not normalized and he used a Mike Alexander technique - he fed the data into a Pivot Table and then used the Pivot Table to generate an extract, thus normalizing the data in a new sheet. Have a read of the background Microsoft documentation on Multiple Consolidation Ranges.
Wednesday, September 11, 2013
Of all the Form Controls, the one that users get excited about is the Combo Box. I've taught the technique for simple combo boxes over and over again but haven't documented it formally. In the meantime, here are some reading resources: