Tag Archives: Excel

‘Real-Enough-Time’ Data

I see and hear a whole lot of noise and effort around the acquisition of “Real-Time” data in their Power BI Reports and Dashboards. I argue here that most times this is simply not necessary nor preferred and that it … Continue reading

Posted in Excel, Office Automation, OLAP, Power BI, Power BI Desktop, Power Query, PowerPivot, Process Automation, Self-Service BI, Spreadsheets, the Cloud, Uncategorized, XLPublish, XLPublish.com | Tagged , , , , , , | Leave a comment

UK Excel User Conference

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

PowerPivot CTP3 Hierarchies Make All The Difference

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

No Mention Of Excel Or Access … Hmmm …

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

(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

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

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