One tool that has become increasingly popular in the workplace is Microsoft SharePoint. What is it? Basically, it provides an “instant portal” if you will for your group or organization. It is aimed at the new collaborative centric workplace, where everybody can access all the information they need from a central location.

Read the rest of this entry »

Here’s the situation: You’re working on a document for work, and suddenly you realize that you’re using the same terms over and over again. However, you can’t think of a different way to describe what you’re writing about. What can you do? You can either whip out the dead weight that is a standard printed thesaurus, or you can simply use the one that is included in Microsoft Word.

Read the rest of this entry »

If you haven’t yet experienced the sublime joy of reviewing other peoples documents, you don’t know what you’re missing (and you should probably keep it that way). However, it’s pretty much unavoidable that in some point in your career you’ll have to do this. Once you go through this process a few times, you’ll realize that there are a few things that you keep seeing over and over again. No matter how many times you make a comment about it, these issues just won’t go away. With that in mind, I’ve listed two of the most common mistakes that I’ve come across below. Despite my best efforts, I see them in almost every document I review.

Read the rest of this entry »

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 »