Tag Archives: Excel

Time to put my foot down (?)

Posted on July 27, 2010 by Biggus Dickus

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

See My Post on PowerPivotPro.com

Posted on June 21, 2010 by Biggus Dickus

I wrote a doc about using CUBE functions in Excel to query PowerPivot Data and decided to give it to Rob Collie at PowerPivotPro to post as Rob is doing a great job of promoting PowerPivot and I wanted to … Continue reading →

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

UK Excel Users Conference

Posted on June 14, 2010 by Biggus Dickus

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

PowerPivot and Access Services Tables

Posted on April 27, 2010 by Biggus Dickus

It’s been a long time since I’ve Blogged about PowerPivot.  That is not for lack of interest but moreso for lack of time and also because it has taken me a while to get my head around where PowerPivot will … Continue reading →

Posted in Uncategorized | Tagged , , , , , , | 2 Comments

We Seem To Be Moving Backwards Sometimes

Posted on April 26, 2010 by Biggus Dickus

I just completed an Excel application for a large International client wherein there is a small Excel file that they send out to collect information peridiodically from offices around the world.  This file does not collect any data, it merely … Continue reading →

Posted in Uncategorized | Tagged , , | 5 Comments

A Long Thread

Posted on January 17, 2010 by Biggus Dickus

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

A Productive Week

Posted on January 14, 2010 by Biggus Dickus

This week I feel more productive than I have in a long while.  Why is that?  It’s because I am at a client who has given me all the help I need to get the job done rather than throwing … Continue reading →

Posted in Uncategorized | Tagged , , , , , , | 2 Comments

Why Excel Is Like My Strat

Posted on January 1, 2010 by Biggus Dickus

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

Posted on December 28, 2009 by Biggus Dickus

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

Excel Training Day

Posted on November 27, 2009 by Biggus Dickus

Yesterday I did a full-day training session in Excel 2003 at a local Auto-Parts manufacturer (yes there are a few left) and despite not much enthusiasm on my part going in, it turned out to be a satisfying and inspiring event for … Continue reading →

Posted in Uncategorized | Tagged , , , | 2 Comments