Infero Training – Business and Technical Courses

So you are using Project and you need the analysis toolbar, however it’s not showing up with the rest of the toolbars. There are a few reasons why this could be happening such as any problems which occurred during the installation of the Component Object Module add-ins. However, despite the number of problems which could be causing the toolbar to not show up, there is just one resolution to all of them.

Step 1:

To install the Analysis toolbar, you have to manually turn off the COM add-ins used by the toolbar, and then turn them back on.

To start, open Project and go to the ‘View’ tab at the top of the page, go to ‘Toolbars before selecting ‘Customize’.

Select the Commands tab and in the Categories box, click All Commands.

In the Commands box, select the ComAddInsDialog command and hold down the left mouse button to drag it to one of the toolbars currently displayed in the Project window.

A line will then appear on the toolbar, indicating where the button for the command will be placed. Release the mouse button to add the ComAddInsDialog command to the toolbar.

Click Close on the Customize dialog box.

Click COM Add-Ins on the toolbar where it was added.

Clear each of the check boxes for the Adjust Dates, Copy Picture to Office, and PERT Analysis add-ins, and then click OK.

Click COM Add-Ins again.

Select the check boxes for the Adjust Dates, Copy Picture to Office, and PERT Analysis add-ins, and then click OK.

On the View menu, point to Toolbars, and then click Analysis to display the Analysis toolbar

So, you have more than one email account relating to your website but you are fed up with having to go to different places to check for new mail? Well Microsoft Outlook has the perfect answer to your email woes, by letting you add new email accounts to it so all you have to do is add your existing email account.

To do this, follow these simple steps:

Step 1: Select the ‘Tools’ tab at the top of the page and scroll down to ‘Account Settings.

Step 2: Click the ‘New…’ tab above the list of email addresses and another box will show up asking you which Service you would like. Select ‘Microsoft Exchange, POP3, IMAP or HTTP’ and click Next.

Step 3: Once you clicked Next, a screen will show asking you to input your email details. Use the password which your Internet Service Provider has given you to gain access to your email in the password section.

Once you have put in your details, click ‘Next’ to let Outlook start configuring your details and set your account up. This could take up to several minutes to complete.

Once this process is complete, your new email account will be checkable through Outlook Express.

Want more tips? Click on Microsoft Outlook Tips and Tricks

How many times have you done it? You’ve sent an email to someone and realised that either you forgot to attach an important document or you sent it to the wrong person!

Wondering what to do? You can either just recall the original message or recall and replace it. The success or failure of a recall depends on the recipients’ settings in Microsoft Office Outlook.

Follow this procedure:

1. From Mail, in the Navigation Pane, click Sent Items.
2. Find the message that you want to recall and open it.
3. On the Message tab, in the Actions group, click Other Actions, and then click Recall This Message.
4. Click Delete unread copies of this message

 

Or

 

Click Delete unread copies and replace with a new message. Click OK, and then type a new message and/or include the attachment. Click Send.

 

You may want to clear the Tell me if recall succeeds or fails for each recipient box, if you are sending the message to a large number of people.

 

The above does not guarantee that the recall will be successful, however it is worth to try!

Want more tips? Click on Microsoft Outlook Tips and Tricks

Sometimes you may want to mark major event in a project, for example indicate the beginning and end of the project or display the end of a major phase. You can use milestones to do that. To create a milestone follow the steps:

1. In Gantt Chart View, in the Task Name column, type the name of a milestone
2. In the Duration column type 0 and press ENTER

In the Gantt Chart the task will be displayed as a black diamond symbol ¿.

Want more tips? Click on Microsoft Project Tips and Tricks

Let’s say you’ve just applied various formatting options to text, for example you might have selected bold, italic, underline; changed font and size of font; applied a different colour, added borders and shading, and even adjusted different line spacing. Now you would like to quickly reproduce this formatting in several places in your document.

You can save time by copying the format you’ve already applied to text using Format Painter. To do so follow these steps:

1. Select the text that has the formatting that you want to duplicate.
2. On the ribbon from Home tab, in Clipboard, click the Format Painter button. When you move from the Ribbon back to the document, the mouse pointer now appears as I-beam with a paint brush.
3. Select the text you want to reformat by dragging the mouse to highlight the text.
4. As soon as you release the mouse button, the text receives the format of the other text. The feature is turned off and the mouse pointer returns to the original default pointer.

If you have several pieces of the text throughout the document that you want to reformat, then follow steps 1 to 3, however in step 2, double click the Format Painter button and select text to format those pieces of text. When you’re finished, click the Format Painter button to turn it off.

Want more tips? Click on Microsoft Word Tips & Tricks

While entering data in Excel worksheet you may find yourself using the keyboard a lot. If you take your hands off the keyboard to use the mouse, it will slow you down. An alternative is to use keyboard shortcuts instead of a mouse. Below are my 10 most favoured key shortcuts in Excel 2007! To use them, simply press two keys shown in the brackets < > simultaneously.

<Ctrl> + <A> – Selects an entire worksheet

<Ctrl> + <C> – Copies the selected cells

<Ctrl> + <V> – Pastes the selected cells

<Ctrl> + <X> – Cuts the selected cells

<Ctrl> + <Z> – Undoes the previous command, if possible

<Ctrl> + <Y> (or <F4>) – Repeats the last command or action, if possible.

<Ctrl> + <S> – Saves the current work

<F2> – Enables editing within a cell

<F11> – Creates a chart from the selected data.

<Alt> + <=> Inserts the AutoSum function.

If you are working on a very important worksheet, use <Ctrl> + <S> regularly to prevent your data from being lost accidentally.

Want more tips? Click on Microsoft Excel Tips & Tricks

So, you almost finished adding your tasks to your project plan and you are willing to display a project summary task. Here is a tip on how to do that.

1. From the Menu commands, select Tools and then Options
2. Click on the View tab and in the Oultine options for ‘Project x’ select Show project summary task check box to show the project summary task

The project summary task will appear before the task list in the Task Name column. If you want to change the name of the project summary task, select it and type the desired text.

Want more tips? Click on Microsoft Project Tips & Tricks

You’ve done a great job by creating a project plan in MS Project. You’ve sent the file to your client or colleagues via email and ops – they do not have a Microsoft Office Project installed on their computer and therefore cannot read the attached file. What should you do?

It would be so much easier if Microsoft Project 2007 had an option of saving a file in a PDF format as in the case with Word or Excel. But unfortunately it does not. So what are the alternatives on how to save and view the project files in a graphical manner?

You can save MS Project 2007 files as images. It will take a snapshot of a project plan in the form of a non-editable picture.

1. Open the Project file you want to take a picture of
2. From the Standard toolbar, click the Copy Picture button, or from the Report select Copy Picture
3. In Render Image decide on either For Screen (for the image to be used on screen), For Printer (for the image to be used on printed materials), or For GIF Image File (if you will be using a file on a web page)
4. In Copy choose either the selected rows or all the rows on screen to be included in the picture
5. In Timescale indicate the time frame within which you want the project to be copied.
6. Click on OK
7. Start the application where you want to insert the picture. Just some applications to use are Paint, Word, Visio, PowerPoint, an email, or even Excel
8. Insert the picture in the desired location

Now enjoy the sharing of the project schedule.

Want more tips? Click on Microsoft Project Tips & Tricks

Have you ever opened a Word 2007 document using Microsoft Word 2007 and had your hyperlinks display

{ HYPERLINK “http://www.inferotraining.com/info.html” } instead of Info?

You try to make these hyperlinks display properly with correct links. You check different view options and they all work fine. However, you cannot get rid of this display. What can you do?

To solve the hyperlink problem here are a few options:

• use Alt+F9 to toggle between the Hyperlink display and Normal view.

• Alternatively,

1. Click on the Office button
2. At the bottom of the displayed menu, select Word Options
3. From the Word Options dialog box, on the right hand side, select Advanced
4. Scroll down until you see Show document content and turn off the Show field codes instead of their values setting

Want more tips? Click on Microsoft Word Tips & Tricks

If you find that gridlines in your Excel worksheets are distracting, make them invisible!

To turn off the gridlines in Excel 2007, follow these steps:

1. From the Ribbon, click the View tab.
2. In the Show/Hide section, clear the Gridlines check box.

Now your gridlines are hidden.

Want more tips? Click on Microsoft Excel Tips & Tricks