Home     Articles     Document Gallery     Services     About This Site     About Rafael

Monday, August 14, 2006

Creating Gantt Charts in Excel (without Microsoft Project)


 by Rafael Van Dyke
 

Those of you that have ever been involved in project management should be very familiar with Gantt charts. If not, I think it'd be good for you to learn what they are. GanttChart.com states that it's a "graphical representation of the duration of tasks against the progression of time." Gantt charts are incredible useful for graphing project schedules because you're able to glean a lot of information from them in a short amount of time. GanttChart.com has a lot of useful resources on Gantt charts, including the history of them and some examples.

Most project management application (like Microsoft Project) come with the ability to create Gantt charts easier from one click after you've mapped out your project schedule. However, when you add all of the other bells and whistles needed to do complete project management, this software is very expensive; and if you don't need the other features, why spend thousands of dollars just to generate Gantt charts?

This is where Microsoft Excel comes in. Jon Peltier has written an article demonstrates two methods for creating Gantt charts: Worksheet Formatting and Stacked Bar Charts. Worksheet Formatting method involves shading the appropriate cells to show when tasks are assigned to be done. You can either shade the cells yourself, or use conditional formatting to do the work for you. The Stacked Bar chart method, however, will give you a chart that is more professional-looking and versatile to do other things with.

For even more information, check out Jon Peltier's web page that lists other links on creating Gantt Chart using Microsoft Excel. This page also lists other tools that you can use to create them for FREE.



# Send mail to the author(s)   8/14/2006 11:02:25 PM (Eastern Standard Time, UTC-05:00) | Comments | Trackback
Article Reviews | Microsoft Excel
Friday, August 04, 2006

More Tips on Designing A Tri-Fold Brochure


 by Rafael Van Dyke
 

When businesses (especially small businesses) market their products and services, tri-fold brochures are and will remain a popular choice. They are for easy to give and to receive, effective in organizing your content into small, precise chunks of content, and they're inexpensive to create (particularly if you can make them yourself.) In a previous post about tri-fold brochures, I referenced an article that I found a long time ago that details how to create one in Microsoft Word when desktop publishing software (like Adobe Pagemaker or Microsoft Publisher) is not available.

This week, I found another article on tri-fold brochures, only this time it gives pointers on how to properly design it. It also references a sample tri-fold brochure template that you can download, along with several other links to get more help on them. Though this article focuses on "educational" brochures, the suggestions given can still be applied on all types of brochures.



# Send mail to the author(s)   8/4/2006 1:44:48 PM (Eastern Standard Time, UTC-05:00) | Comments | Trackback
Article Reviews | Document Design | Microsoft Word
Saturday, July 22, 2006

The Good Side of a Slide Presentation


 by Rafael Van Dyke
 

In the article I wrote The Bad Side of a Slide Presentation, I recalled my experience at a programming conference where I saw one bad presentation after another. For the most part, the reason for that wasn't because of the actual presentation file, but how it was presented. I believe you can have the greatest looking presentation, and it still be presented poorly by the presenter.

Darren Strange of Office Rocker! has posted some great tips on how to give a better presentation. Again, very little of this post has to do with honing your Microsoft PowerPoint skills, but more to do with making your audience comfortable and conveying your message simply and strongly. I think this quote from him really sums it up:

We've forgotten why PowerPoint was created, to help you deliver interesting and compelling presentations and get your message across to your audience. It was not designed as a way for you to bore people. Presenting is a skill and a great tool isn't all you need. Like all great tools, it is best used by a skilled practitioner - someone who knows when and how to use the tool to maximum effect.

Thanks, Darren!



# Send mail to the author(s)   7/22/2006 8:55:25 PM (Eastern Standard Time, UTC-05:00) | Comments | Trackback
Article Reviews | Microsoft Powerpoint
Saturday, June 17, 2006

Highlight Half of a Paragraph? You Can in Microsoft Word!


 by Rafael Van Dyke
 
In most word processing applications, highlighting is limited to lines of texts – meaning when you select text going down that the rest of the line of text will be highlighted with it. Of course, 99.9% of the time that’s exactly what you need. In fact, I can’t even imagine a situation where you would find it absolutely necessary to highlight the left or right half of a paragraph. But you can! Just hold down the ALT key and then click & drag a box in your paragraph and you’ll get something that looks like this:
 
 
Now that you’ve learned this cool new trick, you’re probably wondering what in the world would you use it for. There’s only one scenario that I know of where it’d be practical, and that’s when you create a list using tabs. For example, if you create a tabbed list that produces 4 columns of text and you want to make each column a different color or you want to bold the 3rd column, without ALT click & drag you’d have to format these one by one. But now you can do this:
 
 
That being said, I have never had to use this personally; simply because I don’t use tabbed lists. And though it’s a lot better than using the spacebar to line up text (and if you are guilty of this, please read this post), I will always use tables for generating lists. Using tables not overcome the obstacle of formatting a column of text, they are much easier to manipulate and have more options to make them look better.
 
That also being said, it’s still a cool trick! And who knows, maybe one day I’ll find another practical reason to use. If so, I’ll let you know as soon as possible.


# Send mail to the author(s)   6/17/2006 11:05:12 AM (Eastern Standard Time, UTC-05:00) | Comments | Trackback
Article Reviews | Microsoft Word
Thursday, June 08, 2006

Are Computers Ruining Our Children's Ability to Write?


 by Rafael Van Dyke
 

More often than not, your kids' homework is nowhere close to the kind that you used to get. My kids are no exception; in fact, it got so bad when my oldest son started middle school that we had to get him his own computer. I read an interesting article from an English teacher in Philly.com who says this:

"Students today are a product of an instant-gratification society. Writing a quality paper takes time, and most teenagers aren't willing to make that sacrifice. Like steroids in major-league baseball, technology has become a way for students to cheat - to bypass hard work and cut right to the end result."

I personally think his opinion is a bit general. Besides, in order for this to be true, all schools in our country would have to educate kids that all have easy access to a computer (which I don't think is the case just yet). However, I do believe that the possibility is great if teachers and parents aren't careful. I believe half the battle is staying involved in your child's education - which is no different than 100 years ago; the only difference is that we have the opportunity to use computers as a supplement. 

The word "cheat" is a harsh word for this teacher to use in my view. Most of the time, the child simply needs to be taught how to use a computer properly - like reminding them to use a spell checker, or teaching them the difference between typing a paper for school versus typing an e-mail to a friend. I've made my children retype and edit their schoolwork many times (much to their dismay) because it was sloppy and incomplete. On the flipside, I've been able to teach my children how to make their homework better than it would have been without a computer.

Quite frankly, I think the teacher that wrote this article is a bit too "old school" and needs a lesson on how computers have and will continue to improve our way of life, especially in the classroom. Computers are here to stay; and if we keep looking back to the past, the future will leave us behind. And I'm pretty sure you don't want your chid left behind. I know I don't!



# Send mail to the author(s)   6/8/2006 5:38:58 PM (Eastern Standard Time, UTC-05:00) | Comments | Trackback
Article Reviews | General
Friday, April 28, 2006

A Macro? What in the World is a Macro?


 by Rafael Van Dyke
 

Most of you have probably never even asked yourself this question, simply because it didn't really matter. In many cases, it's simply a virus that you're trying to get rid of; even Microsoft Word and Excel warn you when they encounter one. Below is a link to the article I wrote that explains what a macro is, what they were used for, and why it doesn't matter:

What Is A Macro? Does Anyone Really Care?

But as I state in the article, macros were quite useful before Microsoft Windows came along. That was when we used DOS instead of Windows, no mouse (that's right) and relied heavily on keystrokes to save time. In those days, WordPerfect 5.1 was the undisputed heavyweight champion of word processing programs and basically put macros on the map (man, I've really dated myself, haven't I?)

Needless to say, word processing applications (along with all office suite packages) have involved quite nicely since then - so much so that saving time isn't really an issue anymore. This makes the use of macros just about useless, with the exception to mostly programmers. In Microsoft Office Word 2007, you have to save your document as a DOCM in order to even have your document macro-enabled.

So my answer to the original question is this ... unless you're just curious, don't worry about what a macro is. Of course, I'm sure some of you are asking yourselves "DOS? What in the world is DOS?" My answer to that question is the same.



# Send mail to the author(s)   4/28/2006 10:50:27 AM (Eastern Standard Time, UTC-05:00) | Comments | Trackback
Article Reviews | Microsoft Word
Thursday, April 27, 2006

Add a Splash of Color To Your Documents Responsibly


 by Rafael Van Dyke
 

Maybe it's the little kid in me, but I always enjoy the chance to add colors to anything that I'm working - whether its Word documents, websites, walls, or even my mailbox garden. With so many colors to choose from, it's a great way to express your personality; but it's also easy to get carried away and to be irresponsible in your color selection, which results in a loss of effectiveness in what you’re doing.

It's probably the reason why I end up correcting the same mistakes whenever I look at someone's brochure, a flyer, a newsletter, or any document that has color text. The following article represents the basic guidelines I follow in regard to color documents:

The Right Way to Use Text Colors

When I wrote this article, I was tempted to add one more guideline in relation to color selection; but I decided not to at the last second. In my many years of using colors on the computer, it seems that there are certain colors that I stay away from simply because they never work in any of the documents I create; but that doesn't mean that they won't work for other documents, so I left that part out.

I sure I could submit a post on someday; for now, I think it's important to point out that just because you like a particular color that doesn't mean it's going to work for a document. As I've mentioned before (and will again), the goal is to make it work for the reader, not you. Keeping this in mind should lead you to the color scheme that's right. That, my friend, is what it means to be responsible in your document design.



# Send mail to the author(s)   4/27/2006 9:20:59 PM (Eastern Standard Time, UTC-05:00) | Comments | Trackback
Article Reviews | Document Design | Microsoft Word
Saturday, April 22, 2006

Don't You Dare Touch That Spacebar!


 by Rafael Van Dyke
 

Well, alright, that's not fair. Of course you can touch the spacebar; we all need it to insert spaces between words when we type sentences. But that's where I draw the line! If you're using the spacebar for anything else other than that, this post has your name written all over it.  You know who you are! The ones that are still using spaces to line up your text in your documents.

If this is you, then I strongly suggest that you either take a Microsoft Word class, or buy a Microsoft Word book and learn it on your own - it's definitely worth the time. However, to address your spacebar problem immediately, I'd like for you to read this article:

Why Using Spaces To Line Up Text Is A Bad Idea

Those of you that have this habit, don't despair - you're in good company! I was inspired to write this article by someone with the same habit ... my wife. For as long as we've been married, I've been the proofreader of her documents. Spaces everywhere! After about five years of replacing her unnecessary spaces with tabs or tables, I finally had enough.

So I began teaching her how to fish, instead of always giving it to her. At first, it was a tough adjustment, as I kept finding spaces where they didn't belong; but with time, that occurred less and less. Not only has she broken the habit, and she has become to be very proficient in Microsoft Word - creating her own flyers, calendar, forms, and all sorts of things.

The moral of the story (and the article) is that learning the proper way to use Microsoft Word will lead to better document design and will open the door to accomplish more with your documents. There's a lot you miss out on if you don't know how to use what you have, which applies to just about anything.

Enjoy the article (I hope it's helpful!)



# Send mail to the author(s)   4/22/2006 12:15:55 PM (Eastern Standard Time, UTC-05:00) | Comments | Trackback
Article Reviews | Document Design | Microsoft Word
Tuesday, April 18, 2006

Font Selection That Makes a Difference


 by Rafael Van Dyke
 

I can't stand Times New Roman! There, I said it. I hate Times New Roman ... habitually. I'm a habitual Times New Roman hater!

Don't get me wrong, I respect Times New Roman as a good basic font that's been around a long time; but the truth is that it's time to move on to something else. So why haven't we? Maybe because it's easier to stay with what worked in the past. The problem is ... if we stick with the past, we can never embrace the future. This article I wrote years ago attempts to address this problem:

Picking the Right Font Face for your Document

One font that has grown in popularity since I wrote this article in both documents and websites is the Georgia font. In fact, I predict that it will become the new default font. Until then, it is my new recommendation for anyone who wants there documents to stand out amongst the others.

But if you decide not to use the Georgia font to replace Times New Roman, please ... replace Times New Roman with something.



# Send mail to the author(s)   4/18/2006 7:53:27 AM (Eastern Standard Time, UTC-05:00) | Comments | Trackback
Article Reviews | Document Design | Microsoft Word
Saturday, April 15, 2006

How to Effectively Use a Powerpoint Presentation


 by Rafael Van Dyke
 

One of the best ways that I learn how to do something is by observing what not to do.  Years ago, I attended a programmers' conference in Arizona where I went to several one hour classes. The conference was good, but what bothered me were the presenters in most of the classes.  Most of them had no clue how to use a Powerpoint presentation. That experience resulted into this article I wrote as soon as I returned:

The Bad Side of a Slide Presentation

The main point I make in the article is that Powerpoint presentations are not supposed to be your actual presentation. The purpose of them are to enhance your ability to present by providing visual aids and/or an outline. So if you have poor oral communication skills (which is natural for a presenter who's a programmer) or you are unprepared for your class, reading your entire presentation from the screen is not an acceptable substitution.

In the last two days of that conference, I ended up walking out of any class of a presenter that was unprepared or was reading their presentation off the screen. There were only 4 out of dozens of presenters that I thought were good enough for me to stick around for and actually learn something from. Needless to say, it was a great lesson for the rest of my life on how to present anything to anyone ... and of course, how not to.



# Send mail to the author(s)   4/15/2006 2:38:08 PM (Eastern Standard Time, UTC-05:00) | Comments | Trackback
Article Reviews | Microsoft Powerpoint
Sunday, April 09, 2006

Tri-Fold Brochures using Microsoft Word


 by Rafael Van Dyke
 

As I was digging through my web archives, I found a link to an article I found years ago that explains how to create a tri-fold brochure using Microsoft Word. However, the article is no longer found on ZDNet's website. Luckily, my web archive still had the text for it, and is now available here:

Creating A Tri-Fold Brochure In Word

There are other desktop publishing applications (like Microsoft Publisher or Adobe Pagemaker) that makes these type of publications easier to make. But if you don't have any of them, create a tri-fold brochure is now well within your reach. Furthermore, the principles taught in this article can also help you to create other types of publications and business forms in Microsoft Word.  In fact, it could end up being easier using Microsoft Word than learning how to use another desktop publishing application.

Microsoft Word can certainly do a lot more than most people think.



# Send mail to the author(s)   4/9/2006 11:52:59 PM (Eastern Standard Time, UTC-05:00) | Comments | Trackback
Article Reviews | Desktop Publishing | Document Design | Microsoft Word
Thursday, April 06, 2006

Creating Documents "Negated of Imprecision"


 by Rafael Van Dyke
 

Another article that has been viewed quite a bit on BetterDocuments is about a Microsoft Word feature that I believe is still declining in popularity. Perhaps the fact that this article is viewed a lot is an indictor that we all need to be reminded to use it:

Thesaurus: One of the Greatest Tools Rarely Used

Two reasons come to mind that may explain the decline in use. First of all, what would you use to look up synonyms when you're not using Microsoft Word (or any word processing application?) My kids always use Thesaurus.com, or other websites with a thesaurus. Why? Because the Internet is first place we look to find anything - so why would we bother with Microsoft Word for a synonym?

The second reason has to do with not needing a thesaurus (even online) as much. You don't usually worry about how you sound in a personal e-mail message or text message, or when you're using instant messengers, chat rooms, etc. I believe this proclivity is prickling into the way we write all the time(see, doesn't that just roll off the tongue?)

I don't think it matters what thesaurus you use, even if you do it the old fashion way ... a book (yes, Roget's Thesaurus back in the day was just a book.) The point here is that there are still very appropriate and useful opportunities to take advantage of them to make our documents even better.

Luxuriate in the article!



# Send mail to the author(s)   4/6/2006 5:16:48 PM (Eastern Standard Time, UTC-05:00) | Comments | Trackback
Article Reviews | Microsoft Word
Wednesday, April 05, 2006

How to Make Your Resume Recruiter Friendly


 by Rafael Van Dyke
 

Deborah Walker, CCMC 
Alpha AdvantageFor those of you that are job searching, you’re probably running into a high level of competition for every job you apply for.  This means that you can’t afford for your resume to be lost in the shuffle because it doesn’t grab a recruiter’s attention … it has to stand out from the crowd.  To help your resume rise above the stack, read this article I received in my inbox today:

Is Your Resume Recruiter Friendly?

Deborah Walker is a nationally known Certified Career Management Coach (CCMC), resume writer, and has experience as a corporate recruiter.  She also has resumes and an employment proposal sample that definitely worth taking a look at.  The samples are all very clean, easy to ready, and have great text examples to help improve any resume. Good luck!



# Send mail to the author(s)   4/5/2006 8:17:38 PM (Eastern Standard Time, UTC-05:00) | Comments | Trackback
Article Reviews | Resumes
Monday, April 03, 2006

A Good Company Report - Revisited!


 by Rafael Van Dyke
 

Over the next few weeks, I will be submitting entries regarding the articles that I've written in the past that are included on this website (see the Articles link at the top.) I begin with the article that is by far the most viewed on this website and that has been reprinted the most on other websites: 

Characteristics of a Good Company Report

Most of the advice I give in this article is as true today than it was 5 years ago. The one exception would be the last paragraph that talks about making the report look good.  Don't get me wrong, the pointers I give in that paragraph will definitely make your report look good; I'm just not sure anymore that it's necessary to create a good report

The older I get, the more I realize that what they say is true: "Content is King!" And though this is commonly spoken of when it comes to creating websites, it most certainly applies to creating documents.  With the right software (like Microsoft Word), you'd have to put forth a lot of effort to make a document look ugly; and as long as you don't do that, the main thing to focus on is providing good information that your collegues can use (and actually providing it.)  Fortunately, the rest of the article will give you good suggestions on accomplishing that.

I'd love to hear any other suggestions or comments you might have on creating a good company report.  Don't be shy - you might save someone's job!



# Send mail to the author(s)   4/3/2006 4:32:38 PM (Eastern Standard Time, UTC-05:00) | Comments | Trackback
Article Reviews

 




   Subscribe to Feed





Subscribe in NewsGator Online

Add to Google

Subscribe in Bloglines

Add BetterDocuments to Newsburst from CNET News.com


Powered by Text-Link-Ads

Automating a Microsoft Word Mail Merge in .NET 2.0
How Much Do You Really Know About Microsoft Word?
BetterDocuments.com gives Microsoft Office 2007 Two Thumbs Way Up!
A Microsoft Access Database Pop Quiz!
Giving Thanks to Martin Luther King, Jr.
Where in the world have I been?
How Microsoft Excel 2007 Will Set You Free
Play Pacman in Microsoft Excel - Yes, PACMAN!
You Should Learn How To Share ... Your Google Spreadsheets
The Key to Great PowerPoint Slides
Heading 1, Heading 2, Heading 3. What are they good for?
Info on Zero-day PowerPoint Trojan Virus
Helpful Shortcuts For Showing PowerPoint Presentations
Creating Gantt Charts in Excel (without Microsoft Project)
How to Create Wedding Monograms in Microsoft Powerpoint



 Sign In

Computers Blog Top Sites





Blog Directory & Search engine

feedNuts Feed Profile

Blog Flux Directory