Tag Archives: Microsoft Excel 2010

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

I Think I’m In Switzerland

Posted on December 7, 2010 by Biggus Dickus

Here’s a picture JUST taken out our bedroom window: So beautiful !!  60+ cms in the last two days with more to come (and then rain on Friday darn it 😦   ) So we have School Snow Days and extra … Continue reading →

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

Observations On A New Bathroom

Posted on December 1, 2010 by Biggus Dickus

We had a flood in my house when I was in Europe last month..  Apparently the toilet overflowed in the upstairs bathroom when my grown son was here alone (apparently :-)) and it destroyed the upstairs bathroom, the hall (which … Continue reading →

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

Putting Tables To Work In Excel 2010

Posted on November 25, 2010 by Biggus Dickus

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

Where Have You Been All MY Life?

Posted on August 25, 2010 by Biggus Dickus

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