Archive for April, 2010

How To Use Mail Merge.

April 25th, 2010

Most people only use mail merge every now and then. So here we are going to help you.

Mail merge is used for when you want to send the same letter to a lot of people or if you want to make labels with all your contact details on.

To make it work easy for you it would be better to have your letter in word and contact details in excel already completed and saved.

If you need to make your contact details in excel. Make six Columns with the headings: Company Name, First Name, Last Name, Address, City, Postcode.

In word click on tools then scroll down and click on letters and mailing. Then click on mail merge. Your mail merge section will then open on the right hand side.

Select the type of document you want. ie letters or lables. Then click next at the bottom of that section. Then select either current document you have opened or you select existing and you can search for the document you need. Then click next.

Select recipients. Highlight existing list then underneath click browse. This will open up your mail files. click on my documents and your contact list u saved in excel will be there. Select this and click open.

A select box will open. It will show up with three sheets. This is by default as when ever you use excel it opens 3 sheets for you. Click on the first sheet and click open. A mail merge recipients box will appear with all your contact details. Here you can unselect any of your contact you dont need to use. Then click ok. Then click next at the bottom of your mail merge column.

Here you can select and input you contact details. For example when you have selected the address. It will appear as address block. Once you have inputed each detail click next and you can then preview your work.

Then you can either print your letters or make final changes.

How To Make A Template Using Powerpoint.

April 20th, 2010

A lot of people get confused when starting to use powerpoint. As we have to become a presenter and a designer.

Here we will help you make a great presentation with minimum effort.

You can use many slides for your presentation. Here are the steps for your first one. You can do your text at any point while setting up your template.

first click on file then new.

On the right hand side of the screen you will see a column high lighted new presentation. Then click on blank presentation.

Here you can select the layout you wish to choose. Once selected the top of that column will now say slide layout. As you will find when making your choices for each section. There is many to pick from. So you can have the presentation the way you want it.

Click on slide layout and scroll down to slide design. Here you can select your background.

At the top of this selection click colour scheme. The you can pick your colours of the slide. You can also select on your high lighted colour box if you want to have this selection for just this slide or all.

Then click animation scheme. Here you can select how you want your text to appear on the presentation.

With all your great work on your slide in front of you. You can click play and watch your presentation come to life.

This process is easy and you can repeat it to make all your slide.

How To Make A Watermark In Word.

April 11th, 2010

Need your documents watermarked?

Want to let the people reading your work know that the information is a draft copy or confidential.

This is done in a few simple steps and you can do this at any point.

Select format from the tool bar at the top.

Scroll down and click on background.

Then click on watermark and a printed watermark box will open.

You can pick a picture watermark or text watermark.


To have a picture. Just click select picture and it will open your pictures for you to choose from.

Once you have clicked on your chosen picture. Click insert.

You will be back in the printed watermark box. To complete the task just click apply.

Your pictured watermark is done.

To have a text watermark. Just click the text watermark section.

1 – In the text column you can select which text you would like or you can type in what you need.

2 – Select which font you need.

3 – Select which size.

4 – The colour of the text can be changed.

5 – Select the layout of the watermark.

6 – Once you have finished setting it up. click apply.

How To Transfer A Word File To Adobe Reader / PDF.

April 11th, 2010

This can be done in just a few steps.

You can visit:

http://www.pdfonline.com/convert-pdf/

Then in 3 simple steps.

1 – Select the file you want to be converted.

2 – Select your file output name.

3 – Input your email address.

Your converted documents will be emailed back to you.

For a video showing you how to do this please click below.

See the video provided by eHow

How To Use Excel Autosum.

April 11th, 2010

A good little feature that makes excel do the work for you.

Using your cursor select and highlight all the sums you want to be calculated.

Then press the autosum buttom which is located under your window tools buttom. ( M on its side )

Simple as that. All yourlculations are done for you.

How To Spell Check.

April 7th, 2010

This is very important for your documents.

Best of all its very quick and simple to do.

When you are ready to spell check.

You can simply press F7 and instantly the spell checker will appear. Or you can click the ABC box under the format tab.

It will then select every incorrect word and incorrect grammar used.

Then you can pick the correct word from the suggestion box and just click change.

This will make your work very easy to read and look smart.