Tag Archives: Microsoft Excel

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

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

I Didn’t Follow My Own Rules

Posted on December 22, 2010 by Biggus Dickus

I am currently involved deeply in a project that replaces an exisiting spreadsheet-based production-planning system.  The existing user-maintained document is one of the most dangerous spreadsheets I have ever seen. But when contacted to help on this I made a terrible … Continue reading →

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

Errata2

Posted on December 15, 2010 by Biggus Dickus

I have always worried about giving code advice here for the simple reason that I might be misleading people with wrong, or inefficeient code or code that I thought worked in all conditions but subsequently could be proven otherwise. Well … Continue reading →

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

Putting Tables To Work In Excel 2010 – Errata

Posted on December 14, 2010 by Biggus Dickus

A week or so ago I included some code in a Blog about using Tables in Excel 2010.  In that blog I included some code that, among other stuff, was supposed to clear all the existing rows of data in … Continue reading →

Posted in Uncategorized | Tagged , , , | 9 Comments