Browse by Tags

Formulas Made Easy
Published Wed, Sep 22 2010 12:51 | Bob Phillips
I have been playing with PowerPivot recently, and one of the sites I have visited is Rob Collie's PowerPivotPro blog, http://powerpivotpro.com/ . One particular post that caught my eye was a guest post by Colin Banfield , on building complex DAX formulas...
Who Scratched My Table?
Published Sun, Jul 11 2010 11:45 | Bob Phillips
One of the better additions to Excel 2007 are, in my view, the functionality added to tables http://www.jkp-ads.com/articles/Excel2007tables.asp . I was recently working on a 2007 project and I was looking to add some highlighting using conditional formatting...
The Kid Grows Up
Published Wed, Mar 3 2010 12:41 | Bob Phillips
In a previous post , I talked about building stored procedures (SPs)in an Access database, and calling the same from Excel using ADO. As I mentioned in that post, I am not a fan of the Access GUI. Whilst GUIs can be okay for doing some simple testing...
You Say CustomUI Editor, I Say TextPad
Published Mon, Nov 30 2009 0:11 | Bob Phillips
I have written before about hand-crafting XML so as to customise an Office 2007 ribbon at XML Is Such A Pain and Autogen’ed Ribbon Code As I have mentioned before, the CustomUI editor is far from perfect. It does allow adding of image files and...