Archive for the ‘Excel’ category

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 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.

The difference between Save and Save As

January 11th, 2010

It’s a common question that people ask.

What is the difference between Save and Save As?

The Save option is mostly used to save your work on a regular basis, the file is saved over and over using the same file name.

The Save As option is used to save a file with a new file name, so the file that had the original file name saved1.doc, can be saved as saved2.doc, saved3.doc without affecting the any of the other files.

How to save a office document

January 11th, 2010

One of the most common tasks with any office program.

If you want to keep your work after you have closed the program you will need to save your work.

1) Select “File” from the top left hand corner of the program your working with.

2) Select “Save” from the menu,

If this is the first time you have saved this document you will be asked for a file name.

3) Type in a name that you want your document to be called

4) Select where you want to save the file normally My Documents / Documents

5) Click “Save”

Want to know the difference between “Save” and “Save as” ?

How to close a document

January 11th, 2010

If you’re finished with a document you will want to close it, but make sure it’s SAVED before you close.

There is a few different ways to close documents, I’ll just show you the easy ways.

Before you close ensure your work is saved, in most cases you will see a pop up saving “are you sure you want to close without saving”

If you have one or more documents open:

1) Move your mouse cusor over one of the tabs at the bottom of your screen

They should look like [Doc1 - Word], [Doc2 - Word], [Doc3 - Word] and so on.

2) Whilst your mouse cursor is over the tab, click the right mouse bottom

3) A little menu will pop up, select “Close”

The second easy method is done like this:

1) Select “File” from the top left side of the office program your using

2) Select “Close”, if you can’t see the close option try expanding the menu using the down arrows.

How to open a saved document

January 11th, 2010

One of the most common tasks is also the most simple.

1) Open the office program the file was saved in.

2) Click “File” in the top left corner of the program

3) Select “Open…” (if you can’t see open try clicking the expand down arrows)

4) From the Open dialog box select the file you wish to open.

If you can find what you looking for maybe your looking in the wrong folder, try changing the location at the top of the dialog box.

By default all office documents are saved in the My Documents or Documents folder depending on which version of windows you are using.

How to create a new document

January 11th, 2010

This is one of the simplest tasks you can do with any office application.

By default all office apllications open with a new blank document, but if you want to create a new document this is what you do.

1) In the top left hand corner of the application (word, excel) click “File”

2) Select “New..” If you can’t see the “New” option try expanding the list by clicking the down arrows.

3) Depending on your version of office, you may have the option to create a new blank document, new page, new template. In most cases you will want to select “Blank Document”

The same 3 step process can be used for all office programs and many other programs outside of the office family.