Microsoft PowerPoint presentations have become a stable of “The office meeting”. It used to be strictly reserved for more formal meetings, however with its increasing popularity there are really no restrictions on what types of meetings it is used for today. However, while it is a fantastic tool and very versatile, there are situations where it is overkill to use a PowerPoint presentation. It sounds crazy, but it’s true. Sometimes the benefits of creating a PowerPoint presentation just don’t outweigh the costs.

The following are the situations I’m talking about:

Read the rest of this entry »

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 thought I’d mention this site, as it’s a great resource for Microsoft Office articles. Basically, it aggregates these articles from multiple sources (with the author’s permission) and provides a little synopsis for each one and a link to the original article. I like this site because it’s quick loading and it provides an easy to use interface. Another good feature is that it’s not littered with ads like a lot of the other aggregation sites out there.

It’s definitely worth perusing if you have a chance, as there articles on a ton of different Microsoft Office related topics. Here’s the link:

Microsoft Office Reporter.

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 »

The word Backend is usually used to refer to the part of a system that the end users or clients don’t see. Take buying airline tickets online as an example. In this instance, the person buying tickets online only sees the web page. What they don’t see is the database behind the web pages and the services that get kicked off when they click “Buy”. This is what we refer to as the backend of the system.

Read the rest of this entry »

This particular tips comes from the fact that I’ve been asked this question several times now in the last few days alone, so I thought it would be a good idea to post it here: How do you put a Carriage Return in-between lines of text in a single cell? In other words, how do you use the Enter key like you would in Microsoft Word?

The answer to this is simple: Use Alt + Enter. When typing in your cell and you want to create a blank line before the next line of text starts, hold down the Alt key and press Enter. This will insert a blank line (like in Word) instead of shifting the focus to the next cell.

As I have talked about in previous articles, there are many areas where Microsoft Access and Microsoft Excel overlap. Because of this, there exists the ability to quickly interchange data between the two programs. In this article, I’m going to go over a few simple steps to transfer all of the data from a table in an Access database to an Excel spreadsheet.

Read the rest of this entry »

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 »