Infero Training – Business and Technical Courses

Well, we’re back again with another Microsoft Word Tip for you lucky readers.

This time we’ll look at securing Microsoft Word Documents with a password so that the only pair of eyes that read the protected documents is yours.

Having a password protected document is useful in case something happens to the device the documents are stored on such as a USB memory stick or Laptop. Now, let’s secure our documents:

1. Open Microsoft Word and click the Office button in the top left corner.

2. Scroll down to Prepare and select Encrypt Document.

3. Enter the password you want into the dialog box and click Ok.

4. Enter the password again for verification and click Ok again and now from now on, whenever somebody tries to open that document, it’ll ask for you to input the password.

This way, if the device is misplaced or stolen, you wouldn’t have to worry too much about people looking through the documents and finding out any information from the secure documents because if the person can’t access the file, they’ll most likely just delete them.

Therefore, it is also crucial to keep a separate back-up of your entire device just in case something like that happens.

Would you like more Word tips? Then visit our Microsoft Word Hints & Tips page.

If you’d like to learn more about Microsoft Word, attend one of our Microsoft Word Training Courses.

Well, here we are again with another Microsoft PowerPoint tip for you. In certain cases, PowerPoint presentations can be useful to more than just one group of people.

But what if you have already inserted some Custom Animation into the slides which wouldn’t be appropriate for the group that you will be presenting to the second time around? You will have to go through each slide to remove the animation right?

Wrong! With Microsoft PowerPoint 2007 there is a way to disable the Custom Animation without having to change anything else. Here is how you do it:

1. In the Microsoft Office ribbon, select the ‘Slideshow’ tab.

2. Select the Set up Slideshow button and wait for the ‘Set up Show’ dialog box to appear.

3. Once the dialog box appears, check the box which says ‘Show without animation’ in the ‘Show Options’ section and then click Ok.

4. To check that you have stopped the animation, press F5 to test your presentation out

It is as simple as that and takes literally no time so that you can spend more time getting ready to present the presentation itself.

Would you like more PowerPoint tips? Then visit our Microsoft PowerPoint Hints & Tips page.

If you’d like to learn more about PowerPoint, attend one of our Microsoft PowerPoint Training Courses.

Everybody loves tips which are simple to follow as well as carry out so we have compiled 5 quick tips for you to use in Microsoft Project. These tips work in any version of Microsoft Project to date so everybody should be able to follow them.

1.       Easily insert new rows/columns in your Gantt chart.

This simple tip is so easy to do. All you have to do is click the tab at the top of the column or at the end of the row to select the entire row/column. Then press the `Insert’ button on your keyboard to insert a row/column to the left of the selected column.

2.       Quickly hide columns in tables.

To hide columns in your Gantt chart table, simply click on the right edge of the column header and then drag it to the left until it disappears. If you then wish to see this column again, then click a little to the right of the column separator bar and then click and drag to the right.

3.       Changing information for multiple tasks at once.

If a few of your results share common information and you need to change them, don’t do it one at a time.  Highlight all the tasks you want to change (if the tasks aren’t next to each other then hold down the CTRL button whilst you click them) and then input the common data into one of the fields in the Multiple Task Information box.

4.       View all tasks after applying a filter.

If you have applied a filter to your data and want to see all the tasks you have again without applying the All Tasks filter, then simply pres the F3 button on your keyboard.

5.       Browse through Drop down menus quickly.

To find what you are looking for quickly in a Drop down menu, just type in the first letter of the item you are looking for and you will quickly go to that item.

While working in Outlook you may have a situation when you need to save dozens of outlook messages in a single document. Of course, you can open each message and use copy and paste to assemble them in one document. Well if you copy 12 messages, you will need to do it 12 times!!!

There is a quick way to came to the same result!

1. Select the messages that you want to save in a file using <Shift> or <Ctrl> keys when necessary
2. From the Standard Toolbar click on File and choose Save As option
3. In the Save As dialog box in File Name enter a filename you would like to use ; check that the Save as File option displays the file type as Text Only (.txt) and click on the Save button
4. Using any text editor such as Word open the saved file (for example, right click on the file and choose Open With and then Microsoft Office Word). If you get File Conversation dialog box, click OK. You will get the similar result.

If you want to comment on this tip or share your own Outlook tips, please post a comment or email us.

Want more tips? Click on Microsoft Outlook Tips & Tricks

So you are currently using Excel to store a list of information but now that list has gotten too big to keep on scrolling through and has become a time consuming chore? You should import your data into Microsoft Access which offers you powerful database tools to handle all the information.

To start importing your data, follow these steps.

Step 1: Open Access and create a blank database. Once you have done this, Access automatically brings up a table. You can close this table as it isn’t needed.

Step 2: Click the External Data tab at the top of the page and then select Excel in the Import category which will in turn bring up the Get External Data – Excel Spreadsheet wizard to help you input the data.

Step 3: Browse for the worksheet which contains the information that you would like to put in the Access database and then select the button labeled Import the source data into a new table in the current database. Click on OK to continue.

Step 4: If you have different worksheets in the same document, select which worksheet it is that you want to import and then click Next to continue.

Step 5: Next, if the spreadsheet you’re using has column heading in its first row, click the box, if not names will be generated and you’ll be able to change them later on. Then you click on Next again.

Step 6: The next screen gives you the option to leave any column that you don’t want to import out. In order to do this, you start by clicking on the first column in the preview area. If you don’t want to import that column into the table, put a check mark in the box next to Do not import field and move on to the next column. To change the name of a field, use the Field Name box to change it and then just select which type of data is in the column itself.

Step 7: Next you have to choose a Primary Key if you want one.

Step 8: Input a name for the table in the box under Import to Table and then click Finish.

Step 9: You’ll now be asked whether you want to save the import steps or not. If you are importing more than one worksheet with the same layout then you can choose this option to save you time importing future worksheets. Click close and your new table will be shown in your database.

Do you find yourself sending out regular emails such as newsletter which all use the same layout but you find yourself having to type out and spend time getting the layout right each time that you want to send the email to your subscribers?

Well then you need to set yourself up a template to make the task so much easier and save yourself possibly hours of work time. Follow these simple steps to help you create a template in Microsoft Outlook 2007.

Step 1: Open up your Outlook and start writing a new e-mail, add any contacts and a subject for your template. Then input all the content before finalizing any other formatting you choose.

Step 2: You have to then save the email as a template. Click the Microsoft Office button and then click Save As. From the Save As Type drop down list, select Outlook Template and then just give the template a name and select where you want the template to be saved to before you click on Save.

Step 3: To use your new template, go to the Tools menu and select Forms. From there, select Choose a Form. From the Look In drop-down list, select User Templates in File System. Navigate to the location where you saved the theme if it isn’t in the Templates folder. Select your template. Make any changes, such as updating the message body content or subject line, or adding or removing recipients, and then click Send.

Want more tips? Click on Microsoft Outlook Tips and Tricks

There is nothing worse than going to check your emails one day and finding out that for one reason or another that you have lost everything. If you rely heavily on emails for business, this can turn into a major drain on your company unless you spend a couple of minutes every so often to create a back-up of your Outlook folder. Here are 3 simple steps to follow which could save you hours of work time if something goes wrong.

Step 1: In your Outlook Shortcuts menu, right click on the Outlook Today icon and then select Personal Folder Properties before clicking Advanced.

Step 2: What you need now is the Path from the path menu. Copy this and then open Windows Explorer. Paste the path into the address bar and press Enter.

Step 3: Look for the Outlook.pst file which is located in that folder and copy it by right clicking it and select copy. Then paste the copy onto your back-up disc.

Using Outlook 2007? Then this article is for you! When Good E-mails Go Bad! Solution: BACK UP!

Looking for more Outlook Hints and Tips?

Whilst using Microsoft Excel, do you save all your Excel worksheets to a specific folder and are tired of searching for that folder each time you want to save a worksheet? Well in this tip, I will tell you how to set Excel up so that it saves to your designated folder each time.

First of all, click on the Microsoft Office button in the top left hand corner of the page and then scroll to the bottom to Excel Options.

You then select the Save tab at the side and look for the Default File Location box. In that box you put the folder which you want to save your Excel worksheets to which you can just copy and paste from the folder itself.

Then just click Save and you’re done.

Click to view Microsoft Excel Training Courses that Infero currently offers.

Click to view more Microsoft Excel Tips.

Whilst using Microsoft Word, there are a number of keyboard shortcuts which you can use so that your attention isn’t taken away from the keyboard to use the mouse. Here are some of the most useful ones:

Bold text: Ctrl + B

Italic text: Ctrl + i

Underlined text: Ctrl + U

To bring up the thesaurus: Shift + F7

To undo any action such as typing etc: Ctrl + Z

Select all the text in the document: Ctrl + A

There are more available for viewing through the Microsoft Office Help Menu which can be accessed by pressing the F1 button and typing in the search bar: Keyboard Shortcuts and then selecting: Keyboard Shortcuts for Microsoft Word. 

In Microsoft Word, when you make a spelling mistake in your text, Word automatically shows you that you have made a mistake by underlining the affected words with a red line.

I was asked this week to see if there was a way to get Microsoft Excel to act like Microsoft Word in the way that it recognizes spelling mistakes automatically and highlights them to bring them to your attention. After looking into this I found that unfortunately there isn’t a way to get Excel to recognize and highlight any mistakes you make whilst filling in the spreadsheet. However to correct any mistakes that you have made in Word, you can either press the F7 key on your keyboard or right click over the mistake and Word will offer you suggestions for the correct spelling.

To turn on/off this feature, follow these steps:

Click the Microsoft Office Button in the top left corner, and then click Word Options and select Proofing.

If you want to just turn the checker on for the document you are working on, do the following:

Under Exceptions for, click Name of currently open file and select or clear the Hide spelling errors in this document only and Hide grammar errors in this document only check boxes.

If you want to turn the checker on/off for all documents you create from now, do the following:

Under Exceptions for, click All New Documents and select or clear the Hide spelling errors in this document only and Hide grammar errors in this document only check boxes.

The only tool that comes close to doing this job in Excel is the Auto-correct option which can identify and correct common mistakes and typos such as replacing teh with the.

Want more tips? Click on Microsoft Word and Excel Tips.