Tag Archives: Microsoft Excel 2010

Excel Goes Gangsta (?)

Posted on December 2, 2011 by Biggus Dickus

As a Grandfatherly Canuck I am somewhat ignorant of the “Gangsta” reality in the US of A but on this week’s wonderful visit to the Collie’s in Cleveland I was pressed into displaying my complete and utter uncoolness (while watching … Continue reading →

Posted in Uncategorized | Tagged , , | 3 Comments

UK Excel User Conference

Posted on December 1, 2011 by Biggus Dickus

My pal Simon Murphy, aka Smurf, is hosting another Excel User Conference in January in London on Wednesday, Jan 25th, 2012. Here is a link to info on this session.  I think if you’re in the London area and you … Continue reading →

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

Data Access IS The Problem

Posted on October 26, 2011 by Biggus Dickus

I have harped on this here before, but once again my blood-pressure is rising because I have seen a simple, efficient use of the powers of Excel marginalized by a client’s inability to get support and cooperation from the “Gate-Keepers” … Continue reading →

Posted in Uncategorized | Tagged , , , , | 15 Comments

PowerPivot CTP3 Hierarchies Make All The Difference

Posted on September 26, 2011 by Biggus Dickus

I have been around OLAP databases since 1994.  By “around” I mean that I have used them off and on for all those years without actually becoming a true BI dev – rather I am an occasional consumer. This is … Continue reading →

Posted in Uncategorized | Tagged , , , , , , , , , , , , , , | 3 Comments

What I Did This Summer

Posted on September 7, 2011 by Biggus Dickus

I have now returned home to Canada after an extended stay in the Netherlands over the summer working on an Access Services project.  Beyond the fact that there are much worse places to hang out than Holland, I also learned … Continue reading →

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

No Mention Of Excel Or Access … Hmmm …

Posted on June 9, 2011 by Biggus Dickus

I just saw an interesting article in the Seattle Times where they interviewed somebody named Kurt DelBene who is apparently the President of the Microsoft Business Division.  From the article (linked below) it seems that this guy DelBene is responsible … Continue reading →

Posted in Uncategorized | Tagged , , , , , , , , , , | 3 Comments

Dynamic Range Names And Charts In Excel 2010

Posted on May 19, 2011 by Biggus Dickus

(Update 05/27/11)  Please be advised that there is a more recent post than this that completely negates the need for the technology mentioned in this Post.  It does not mean this is not a Cool solution (IMHO) but it is … Continue reading →

Posted in Uncategorized | Tagged , , , , , , , , | 20 Comments

The Perfect Storm

Posted on April 27, 2011 by Biggus Dickus

For years I have been arguing that the combination of Excel and Access is the strongest “story” in Microsoft Office – and the most ignored.  I have used these two products together and separately to deliver solution after solution that … Continue reading →

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

Excel Careers

Posted on March 21, 2011 by Biggus Dickus

Great post over on friend Simon Murphy’s site about Excel careers (or lack thereof).  Check it out: http://smurfonspreadsheets.wordpress.com/2011/03/21/excel-careers/ Dick

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

Is Excel 2010 Kinda Fragile ?

Posted on December 28, 2010 by Biggus Dickus

I have once again run into a major probem in Excel 2010 related to doing major surgery on a large file and ending up with it being unwilling to Save and requiring me to perform some serious “sleight-of-hand” to save … Continue reading →

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