Most of the time, your installation of Microsoft Office will come with a decent size collection of Clip Art. However, there are some occasions where your default collection won’t do, and you need something specific. While you can find other images online to suit your needs, this can sometimes be a hassle (searching for a specific picture, being able to download it for free, etc). That’s why your online search for Clip Art should start with….Microsoft (I know, it’s shocking)!

Read the rest of this entry »

One of the key pieces of any major document is the Table of Contents. Not only does it provide the audience with a way to navigate a document when you’re done with it, but it gives you a way to quickly move from section to section while creating it. Since it’s such a common element of many documents, you would think that most people would know how to create one quickly. However, this is not the case. That’s why I decided to put together this quick guide to creating one.

Read the rest of this entry »

For those of us that review and edit documents on a daily basis, using the Track Changes feature of Microsoft Word has become second nature. If you’re not familiar with it, this feature keeps a history of all of your comments, changes to the document, etc. and allows you to ultimately accept or reject each change to your document. It’s an extremely useful tool, especially when you have a document that is going through multiple people before it’s finished.

Because of the popularity of this tool in many offices, I’ve decided to share three tips that should make your life easier when using the Track Changes functionality:

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 »

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 »

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 »