Why Companies Skip the Upgrades

March 17, 2010 19 comments »

The other day, I posted about the release of Office 2010. The comments got me wondering why companies don't upgrade more frequently.

Dan's company, for instance, is just about to jump onto Office 2007 after stewing in Office 2002 for the last 8 years.  Many of you are still using Office 2003.  

.

The way I figure it, most companies don't upgrade because of one reason:  The IT Department.  That's right….I said it.  IT Departments.  Of course, I can back this up with lots of anecdotal (he said – she said) evidence.

.

Let's do a simple exercise.  Let's go into the mind of an IT Portfolio manager. 

.

(cue the dream sequence music…ala Wayne's World)

.

Microsoft Office 2010 is coming out with tons of great features.  This version will make make our Office Documents more secure and will integrate with our beloved SharePoint better than ever before.  (IT folks love their SharePoint).

Financially speaking, we can upgrade easily.  Given our super-duper Microsoft Enterprise Licensing agreement, our costs will be minimal.

On the other hand, we do have over 4000 users – and they are IT morons. 

If we push out a new version of Office, they'll complain, they'll screw up the install,  they'll flood the Help-Desk with calls saying moronic things like "my Excel crashed the Firewall".

And who knows how SAP, Essbase, Hyperion, and the other corporate applications will handle the new version of Office?  In the end, the benefits don't outweigh the risks.  No upgrade this year.

.

(cue the coming out of dream sequence music)

.

So there you are.  You, as the IT Portfolio Manager, have just talked yourself out of upgrading Microsoft Office for another version.  And it's my belief that this entire thought process happens faster than you can say  'Mountain Dew and Sunflower Seeds'.  No meetings needed.

Office 2010 Release Dates

March 15, 2010 3 comments »

On the Microsoft 2010 Engineering Blog, they've posted this:

"For businesses, we will launch the 2010 set of products, including Office 2010, SharePoint 2010, Visio 2010, and Project 2010 worldwide on May 12."  "For consumers, Office 2010 will be available online and on retail shelves this June."

 

This means if you're company jumps on all the latest Microsoft products, May could be an exciting time for you.  

If you're still languishing in Office 2003, just pretend nothing is happening. 

If you're still on Office 2000, find someone to hug.

Why FIND when you can SEARCH

1 comment »

Vinicius writes to ask:

"Dear Mr. Pig. I would like to know what the difference is between Excel's FIND and SEARCH. Which one should I use?"

I love the respect Vinicius shows by calling me Mr. Pig. Anyway, here is your answer Mr. Vinicius:

 

There are two differences between Excel's SEARCH and FIND functions.

 

First, the FIND function is case sensitive, while the SEARCH function is not.

As you can see in this example, the formula in D2 returns 13 because the FIND function is looking for the first Capital B. The first capital B just happens to be the 13th character.

The formula in cell D3 is using the SEARCH function. That function isn't case sensitivity, so it returns the first B it finds (character number 3).

 

 

The Second difference between FIND and SEARCH is the ability to use Wildcard characters. The SEARCH function handles wildcard characters, while the FIND function does not.

In this example, I'm using the (?) wildcard character to tell the SEARCH function to find the first string that starts with a B and ends with a C. The first string that meets my criteria starts on character 13, so that's what I get.

 

Which one should you use?

Technically, the SEARCH function is safer to use because you won't accidentally pull the wrong position due case sensitivity.

I don't think I've ever needed to do a case sensitive find. I'll never use the SEARCH function's wildcard ability, but it's nice that it's there.

 

I'll be honest; prior to this blog post, I used the FIND function mainly out of habit. In fact, prior to Vinicius' email, I kind of forgot about the SEARCH function.

I'm going to make an effort to use the SEARCH function from now on. Well Vinicius, I guess I'm recommending the SEARCH function.

The New BadAss Bass

March 12, 2010 2 comments »

So the boy has been taking guitar lessons for about 2 months now. He's getting pretty good. Pretty soon, I'll send him out to play on the streets for money (like a monkey).

 

Now, I've always wanted to play the Bass guitar. I love the brooding rumble of the bass…I like the walking bass lines…I like the pop slap funky grooves…I like it all. Anyway, the boy (with his guitar playing) has inspired me to finally pick up the Bass. So last night, I went out and bought myself a Fender American Standard Jazz Bass.

» Read more: The New BadAss Bass

The Case for Access

March 10, 2010 17 comments »

Amazon says it's official. My new book will be out on April 5th.

This book is written for all you Excel users who know that expanding your skill-set to include Access can make you more productive. I guide you through analytical and reporting benefits of Access, and show you how you can integrate Excel and Access to make your life easier.

 

To celebrate this new arrival, I've decided to post Chapter 1 of this book as today's blog entry. Enjoy!

» Read more: The Case for Access

Removing User Name from Comments

March 8, 2010 6 comments »

When you insert a comment into Excel, your username is automatically inserted into the comment followed by a colon.  For instance, if you log into your computer using the user name TrunkOfFunk.  Your comments will all start with TrunkOfFunk:.

.

This annoys me to no end.  Theoretically, this "feature" is supposed to tell you who inserted the comments.  I don't think I have ever needed to know that Donna inserted a comment into cell B2. In my opinion, the user name just clutters up the comment. 

.

If you share my distain for the forced username in comments, here is a small procedure that will go through all comments and remove the username.  This is especially handy for those of you who have embarrasing user names like Lou Briccant.

Sub RemoveUserNames()
Dim MyComment As Comment
Dim I As Integer

'Start looping through comments
    For Each MyComment In ActiveSheet.Comments
       
    'Find the position number of the Colon & LineFeed character combination
        I = InStr(1, MyComment.Shape.TextFrame.Characters.Text, ":" & vbLf)
       
    'Use the position number to reset the comment text to all but the user name
        If I> 0 Then
            MyComment.Shape.TextFrame.Characters.Text = _
            Mid(MyComment.Shape.TextFrame.Characters.Text, I + 2)
        End If
       
'Go to the next comment
    Next MyComment
   
End Sub

Bacon Carrots

March 7, 2010 2 comments »

On this blog, Saturday is Bacon recipe day. So no Excel tips and tricks today. Today we learn about bacon.

 

I've been slacking on the bacon posts lately - mostly because I've been a responsible adult, completing work instead of puttering around on the internet.

Because I'm feeling so responsible, I think I'll post an adult recipe today. How about Vegetables! Yeah…vegetables are all adult-ey.

 

Scouring the internet, I found this recipe for Sweet Baby Bacon Carrots. Look gross, but hey...I'm an adult now.

» Read more: Bacon Carrots

Locked Out of Remote Computer

March 3, 2010 3 comments »

So I'm working alot with a client through a Remote Desktop Connection.  This is a scenario where I log into a computer remotely using terminal services via the Window Remote Desktop Connection utility.  I'm sure many of you have the same kind of setup with your remote clients.
» Read more: Locked Out of Remote Computer

Daily Dose of Pig

February 26, 2010 8 comments »

So there you are – a power user - a veritable guru in your office. Everyone comes to you for training and help. So where do YOU go when you want to enhance your skills? The truth is, there is no training out there that touches your level of skill. All the training you've attended has been a joke.

 

That's why I teamed up with Dick Kusleika (Daily Dose of Excel) to come up the Excel and Access Power User Workshop.

» Read more: Daily Dose of Pig

A Color is Not Data

February 25, 2010 14 comments »

Ok people. Repeat after me – "A color is not data".

Every so often I get a spreadsheet from someone who thinks that colors play a major role in data management. You know – those people who happily say "I tagged those records with Yellow". Oh really? I don't think my version of Excel has a "Yellow" data type.

  » Read more: A Color is Not Data