If you use Excel 2007 (Currently my company has not upgraded yet), you might be interested in reading the thread below from the google user groups:

Microsoft Excel 2007 Calculation Bug

It looks like a problem with the floating point representation of certain numbers. Fortunately, from what I can see this specific problem is unique to 2007, so if you haven’t upgraded yet you should be ok. Otherwise, if you use 2007 I’d read up on it to see if this affects you in any way.

This is a passionate plea from not only me, but millions of other people who have to deal with Excel spreadsheets on a daily basis: Please refrain from using 8000 colors if you’re creating a spreadsheet. I received a spreadsheet the other day and there was at least 15 different colors used to differentiate the data. The result was that it took me twice as long as it should have to review it. This is a disturbing trend that seems to be getting worse, and I really want it to end.

Read the rest of this entry »

I came across this functionality the other day when I was trying to convert some data I had in a Microsoft Word document into a Microsoft Excel spreadsheet. The problem was that although the data was in columns in the Word document, it wasn’t actually in a table. This means that when I tried to copy a row into Excel, instead of it going into three columns the entire row went into the first column. It was a major problem for me because there was a significant amount of data, and I didn’t have time to try to hand copy it row by row into Excel. Fortunately for me, this is when I found out about the Text to Columns feature in Excel.

Read the rest of this entry »

When working in a spreadsheet, nine times out of ten you’ll end up inserting a row. In fact, you’ll more than likely be inserting multiple rows at a time. However, if you just highlight where you want to insert and use the Insert command, only one row will be inserted. This can be annoying if you are trying to insert multiple rows at one time. Fortunately, you aren’t consigned to “one row at a time” hell just yet. Microsoft Excel does allow you to insert multiple rows in a single click.

It’s quite simple to accomplish this by following these steps:

Read the rest of this entry »

This is the last part in a series describing how to use the Hyperlink tool in Microsoft Excel (see the bottom of this post for links to the first three parts). In this part, I will be showing you how to create a link to an email address in your spreadsheet.

When would this be useful? A good example where I’ve seen this used is for contact information. If you have a user working on a spreadsheet you created (say an order tracking form), and they have a question or problem, they can click on the email link and a new message window will pop-up (in their default email application) with the To address and Subject pre-populated.

Once again, I’m going to make the assumption that you know how to open the Hyperlink tool dialog (as discussed in Part I of this series). From this dialog, select the E-mail Address option in the Link to: box. The result is shown below:

Read the rest of this entry »

This is the third part in a series describing how to use the Hyperlink tool in Microsoft Excel (see the bottom of this post for links to the first two parts). In this part, I will be showing you how to create a new document and put a link to it in your spreadsheets.

Personally, I haven’t used this function of the Hyperlink tool that much. However, that doesn’t mean that you won’t ever have a use for it. For example, if you are creating a spreadsheet where you want the user to be able to create a new document and then save it off, you would use this function.

I’m going to skip how to open the dialog, as that was discussed in the first article. Assuming the dialog is open, select the Create New Document option in the Link to: box. The result is shown below:

Read the rest of this entry »

This is the second part in a series describing how to use the Hyperlink tool in Microsoft Excel. Check out the first part in the series here. In this part, we will be exploring how to insert an internal link into your spreadsheets.

Read the rest of this entry »

This is the first part in a series that describes how to use the Hyperlink tool in Microsoft Excel. In this part, we will be focusing on how to insert a link to a web page or file into a spreadsheet.

It can pretty much be assumed that 99% of the people you are working with have access to the internet at work. Because of this, linking to web page content has become a very common practice when creating almost any kind of work product. Also, with the advent of the LAN (Local Area Network), linking to files such as Microsoft Word documents has also become common. In Microsoft Excel, both of these tasks can be accomplished using the Hyperlink tool.

To open this tool, click on the icon circled in red below:

Read the rest of this entry »

The If Conditional is a decision structure that is used not only in Microsoft Excel, but in many other applications as well. It’s pretty much THE basic universal decision structure. The concept is simple: A logical condition is tested, if the condition is satisfied (a True result) then one branch is followed. If the condition is not satisfied (a False result) then another branch is followed. The question is, how to use it in Excel?

Read the rest of this entry »

Ok, I lied. It’s Tuesday, it obviously cannot be that exciting. However, I do have two new articles for you, see below:

• See today’s Tip of the Day if you plan on requesting time off for vacation this summer.
• The Microsoft Excel bug bit me again, and this time we explore the basics of using the AutoFilter.