Monday, September 30, 2013

Multiple Consolidation Ranges in Excel

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.



Citing the full pathname of the document file

Wednesday, September 11, 2013

Focus on producing Combo Boxes

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: