Such Happiness In Thought Happens

January 2, 2009

Word 2007 Style creation

Filed under: MS Office — Tags: — Duane @ 8:37 am

This is a quick post to give a brief tutorial to someone new to Word 2007 and how Styles are created there. Read on for more.


October 3, 2008

Milestones past their Due Date

Filed under: MS Office — Tags: , — Duane @ 7:37 pm

This post is in response to a comment made by a reader recently in the Project Tips & Tricks post earlier this year. The comment from Natasha is as follows:
“Is there anyway to make past due milestones a certain color?? I have green for milestones that were complete, black for milestones that are in the future, and I’d like to make milestones that the date has already passed but the % complete is zero = Red. how can i do this?”

Well Natasha, this post answers that question. So read on and enjoy!


May 13, 2008

List analysis in Excel 2003

Filed under: MS Office — Tags: , , , — Duane @ 8:48 am

There are a number of ways of achieving the same result of finding data from an Excel list. In this post I would like to look at some of these different methods so you can determine which one you would use depending upon your situation. The file that I will be using to demonstrate these techniques is available HERE and you can download said file for practice. The file was made using data from the Northwind Access database, which was then exported out to Excel. This post will look at Excel 2003 and earlier. I might do an Excel 2007 version in the future as Sorting, Filters and Pivot Tables have changed in the newer version.


May 9, 2008

MS Project Gantt Charts comparisons

Filed under: MS Office — Tags: , , — Duane @ 11:32 am

This post is to help explain the uses of the different Gantt Charts to be found in Microsoft Project. A practice file to refer to can be found HERE. Note that the link points to a file that is not a .mpp file. When I attempted to download the uploaded file, all it would do is open the file in the browser. So I didn’t want to take any chances, thus changed the extension of the file to be downloaded. When you download the file, change the .mp_ to .mpp and you will then have a working Microsoft Project file to play with.

The practice file is one I made for a university assignment a few years ago. It is rather simplistic in scope, but the tasks are linked, have resources, and there are costs to the project.


March 12, 2008

Office 2003 to 2007 Conversion Guides

Filed under: MS Office — Tags: , — Duane @ 9:10 pm

Been awhile since I did a post about a tip with Office, and the truth is I have been busy, and unsure what exactly to write about. I wrote the main tips I could think of that are handy. Currently I am compiling a list of things for each program, and you should see that result of that shortly. But I stumbled across an incredibly useful part of the Microsoft Office website that I wanted to share for those of you who have upgraded to Microsoft Office 2007 and are having difficulty finding things that you once knew.

This link is what you want to click on. Then download the Interactive Guide for the program you need help with. Once you have downloaded and installed the executable file, you will have on your computer a Flash video file that you can refer to for menu commands you once knew in Office 2003, but are now unsure where it is found in Office 2007.

I would recommend downloading the installation files, install them somewhere you will remember and then use them as required. On the same link you don’t have to download the files, you can do it from the internet itself, but I find it handier if you don’t have to keep going onto the internet for it, but do it locally from your computer.

February 23, 2008

The value of Notes

Filed under: MS Office — Tags: , — Duane @ 9:44 am

It constantly amazes me that people who say they “know” how to use a program, know so little about it. And one of the big “holes” in their knowledge is the use of notes. Most people constantly keep things like information, detail, tasks and the like in their head, without writing it down. Or if they do write it down, it is stored chronologically, making it difficult to find the information that has been written down. Basically what was the point of the exercise? So today I would like to take a bit of time to look at a little used feature of Microsoft Outlook and Microsoft Project – notes.


February 20, 2008

One cool tip in Outlook – how to delete old email addresses when creating a new email

Filed under: MS Office — Tags: — Duane @ 1:45 pm

I was inspired to write this post when I explained to a colleague how to do this, and she thought she could make money from this one little tip. Ever had the problem when you are typing in somebody’s name in the To or CC field in an email and in the list that comes up, either there is an old, incorrect email address, or you get distracted seeing old colleagues who don’t work there anymore? Would it be nice to clean up the name Autocomplete, so that only names you use are in that Autocomplete area? Well here is how.


February 18, 2008

How to make average Powerpoint presentations into excellent presentations

Filed under: MS Office — Tags: , — Duane @ 1:31 pm

Following yesterday’s post, here are some pointers to make better Powerpoint presentations. The basic rule is easy to understand – less is more.

The first thing to understand with Microsoft Powerpoint is that it is a tool and will not do the presentation for you. For what reason are you using a Powerpoint presentation? This simple question will help determine what to do with your presentation. What goal/s do you have by using the Powerpoint presentation? For example, is it meant to remind you of your key points; keep your audience entertained; impart the main points, etc.


February 17, 2008

Powerpoint no-nos (or how to make a bad presentation even worse)

Filed under: MS Office — Tags: , — Duane @ 7:20 am

A year or so ago I came across a couple of funnies in regard to the use of Powerpoint, or more correctly the incorrect way of using Powerpoint. It seems like everything else Microsoft – if you don’t get some training on the program, you just do what you feel like, or do what everyone else does. So in this post I will post a list of no-nos to avoid when using Powerpoint, and then tomorrow I will post some good ways to use Powerpoint. If you are brave, why not fess up to some of the no-nos you have done before?


February 12, 2008

Microsoft Project tips and tricks

Filed under: MS Office — Tags: , , — Duane @ 6:25 pm

Last week I taught my first MS Project workshop for the year and it got me thinking to what is handy to know about Project to make life easier for oneself. I have noticed that the traffic to the blog is more when it is the tips and tricks of the various programs that people are viewing, and funny enough it is from search engines that they are coming. Anyway, here will be detailed some things about Microsoft Project that you may or may not be aware of that make my life (at least) easier when I use the program.


Older Posts »

Create a free website or blog at