Tag Archives: Microsoft Excel

Putting Tables To Work In Excel 2010

I was very lucky to be able to develop a major Excel 2007    “Application” shortly after it shipped.  In that file I used the new Structured References that are designed to work with the enhanced Excel “Tables” from that version.  I … Continue reading

Posted in Uncategorized | Tagged , , , , , , | Leave a comment

SDN Conference, Zeist, The Netherlands

I am back this week from speaking at the SDN Conference in Zeist , The Netherlands last week.    If you speak Dutch: http://www.sdn.nl/SDN/SDNEvent/SDNConference2010/tabid/162/Default.aspx This was my second year at the Software Developer Network’s annual conference and as always I was … Continue reading

Posted in Uncategorized | Tagged , , , , , , , , , , , | Leave a comment

Where Have You Been All MY Life?

I just recieved Bill Jelen’s (MrExcel) book “PowerPivot for the Data Analyst: Microsoft Excel 2010” and am enjoying reading it.  I really like the way Bill writes and his honesty is refreshing (to say the least).  Thanx Bill. I have … Continue reading

Posted in Uncategorized | Tagged , , , , | 16 Comments

Time to put my foot down (?)

Once again a client has rejected the idea of automating data collection in Excel by using a “Submit” button on the file and some VBA code to push the data into a Database in a single point on the corporate … Continue reading

Posted in Uncategorized | Tagged , , , , , , | 4 Comments

UK Excel Users Conference

I am sure that EVERY person who uses Excel in the UK goes daily to Simon Murphy’s “Smurf on Spreadsheets” blog and I also know that everyone who ever comes here goes to Simon’s Blog first. But I am still giving notice … Continue reading

Posted in Uncategorized | Tagged , , , , , | Leave a comment

A Long Thread

This may or may not be very interesting to anyone – but it’s my blog and I guess I can say what I want :-). But then again maybe these thoughts will get you all thinking about the potential impact of everything we … Continue reading

Posted in Uncategorized | Tagged , , , , , , | 5 Comments

Why Excel Is Like My Strat

Some time after typing my comments about Vegemite and Heinz Beans in my last thread I went into my office and saw the ultimate example of what I’m talking about with Excel’s problems in the world – my Fender Stratocaster … Continue reading

Posted in Uncategorized | Tagged , , , , , , , , | 12 Comments

Excel is NOT Forever

Here are MY New Year’s thoughts: I used to just assume that spreadsheets were forever – I don’t think that way anymore. I have made the point in many speeches around the world that Scrooge and Cratchit were doing “spreadsheets” … Continue reading

Posted in Uncategorized | Tagged , , , , , , , , | 9 Comments