One of the easiest ways to make sure that your tables are consistent throughout your Microsoft Word documents is to create one, and then use that as the template for the others. Basically, once you create your template table you cut and paste it to other parts of your document to use it as a base. Sounds simple right? It is, however sometimes it can be difficult to select all the rows and columns in your table by highlighting them. This can especially be true if your table is large and spans multiple pages and/or the rows of your table break across multiple pages.

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 »

What do the “big bosses” at your work do? Do they make copies? Do they write software? Do they conduct testing? The answer to all three of these questions is no. What do they do then? They sell work. This means that they sell projects, products, whatever your company markets to your clients. They are always looking for ways to create new business.

A common misconception at the workplace is that only people at a certain level can sell work. Actually, everybody who works for your company can sell work, it just may not seem obvious. One of the best ways to do this is to sell your Brand when you are doing PowerPoint presentations.

How do you go about doing this? Kevin Potts has outlined some good advice below on how to sell your brand through PowerPoint presentations. I’ve included my comments on the article right before the Author Resource Box.

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 »