Archive for the 'Tips and Tricks' Category

Microsoft Word Tips: How to continue numbering

Published
by
Simpson
on February 26, 2015
in Microsoft Word Tips and Tips and Tricks
. 0 Comments

Numbering in word is easy as 1, 2, 3! In word documents you are able to use either Bullet Points or Numbers to make text jump out of the page. As you can see below it makes a list easier to read and brings the reader in!
1.    Make a Blog Post
2.    Upload it  to the Blog
3.    Profit!!!

 

But what happens when you want to stop the list, type a paragraph and then continue where the previous list left off?

 

You get to your numbering section you need to go to the Home tab, Paragraph Group. And located at the top left of this group are the bullets and number command buttons.Numbering 1

 

To turn the Numbering on click on the Numbering Command button in this group and to turn it off you can click it again and this will turn off the number on that line.

If you want to then re-continue your numbering later in the document, repress the Numbering Command button.
Numbering 2

You will see next to the new number a Lightning Bolt icon, this icon is a menu that will either show you 1 of 2 options: Continue Numbering or Restart Numbering. Select the option that you need and carry on typing.

Microsoft Excel Tips: Absolute Referencing

Published
by
admin
on January 7, 2015
in Microsoft Excel Tips and Tips and Tricks
. 2 Comments

Absolute Referencing is a forgotten tool in your Toolbox called Excel. Daily you will probably find yourself using the fill handle on excel to automatically fill tables. This is called Relative Referencing and this will change the formula/function in a cell depending on which way you drag the cell.

 

So the example below we have a Product List at a made up computer company.Absolute Referencing 1

 

 

As you can see in the Total Quantity Price column I used the fill handle to drag my formula down the formula to the other rows to fill in the column. Because I dragged the fill handle down the numbers row numbers increased 1 at a time.
Absolute Referencing 2

 

 

Absolute Referencing allows us to lock a formula in a cell. Let’s see this in another example.

 

I’ve extended my table and added a Price After Tax column. This column uses the 20% (or 0.2) number in cell H1 to add the Tax onto the Price. Using the $ before both the H and the 1 you are able to “lock” this cell down. So when you use the fill handle the cell wont change.

 

Instead of typing the ‘$’ in the formula you could press the F4 key on your keyboard to automatically add the ‘$’ to that cell reference.

Microsoft Project Tips: How to Create a Milestone

Published
by
admin
on December 22, 2014
in Microsoft Project Tips and Tips and Tricks
. 0 Comments

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

Microsoft Excel Tips: How to Personalize your Table

Published
by
Simpson
on December 6, 2014
in Microsoft Excel Tips and Tips and Tricks
. 0 Comments

When you use Excel the table can look really boring and plain; however in the newer versions (2007 and

Microsoft Excel 2007 Cell Styles Menu

2010) you are able to customize your tables by using different font styles and colours as well. There are also different shades of colour and sizes of text you can use. To change you table here’s how to do it:

 

  1. Click on the Cell Styles link on the toolbar
  2. This will give you a list of all the different styles that are available to you when making your table
  3. Click on the cell you want to personalize and then choose the style you want.

 

 

Want more tips; just visit our Microsoft Excel Tips page

Microsoft Word Tips: Keyboard Shortcuts

Published
by
Shaun
on November 15, 2014
in Microsoft Word Tips and Tips and Tricks
. 0 Comments

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. 

Microsoft Outlook Tips: Redirecting Email Replies

Published
by
Shaun
on November 5, 2014
in Microsoft Outlook Tips and Tips and Tricks
. 0 Comments

When you are charged with sending e-mails for someone else in your office, you may not want the replies to be directed to you. For instance, your boss asks you to send an e-mail to a client after they have requested information about a particular service.

 

If the client sends chooses to reply to that email asking something which you have no knowledge of, you will then have to forward the e-mail to your boss and start acting as a middle-man in the conversation which could distract you from your other duties. So, to save time and resources, why not have the reply to this e-mail directed to your boss rather than you?

 

It is possible and extraordinarily easy to set up. Just follow the steps below to learn how:

 

  • Click the Options tab and select the Direct Replies To option in the More Options group.
  • From the Dialog box, set the reply to address for this e-mail.
  • Click OK.

 

Now you can send the e-mail on behalf of your boss, but the reply will go to your boss, and not you, leaving you free to get on with more important tasks.

 

If you would like to read more Outlook tips, please visit our Microsoft Outlook Tips page.

 

If you would like to learn more, you should book yourself on one of our Microsoft Outlook Training Courses

Microsoft PowerPoint Tips: Colour Options for Picture Backgrounds

Published
by
Shaun
on October 17, 2014
in Microsoft PowerPoint Tips and Tips and Tricks
. 0 Comments

Are you tired of using the same old plain backgrounds in your Microsoft PowerPoint presentations? Well now there is a way where you can use your own captured images to great effect as custom backgrounds in your slides.

In this Microsoft PowerPoint tip, I will explain how you can use a photo to its maximum potential as a background and edit it without the need for expensive photo editing software such as Adobe Photoshop, using a simple PowerPoint tool for instant effective results.

To begin, follow these simple steps:powerpoint colour

  1. Display the slide or the slide master.
  2. Insert a photograph by going to Insert and select Picture. Here you can choose to use a digital photo that you took yourself or any other image that you have saved on your machine. If, however you choose to use an image from the Clip Art collection, go to Insert and select Clip Art.
  3. With the photo selected, resize it or use the Crop button on the end of the Picture Format toolbar to crop it so that it fits the slide.
  4. With the picture still selected, select the Recolor option and select Washout from the options available, as you see here encircled.
  5. Your image will now be lighter meaning that your text will now show above it clearly. There you have it; your image will now serve as the perfect background to your slides.

 

If you think that the image is too light/dark, just use the Brightness & Contrast controls until you have it to your liking.

 Logo Before and After Change

If you would like to read more tips, visit our Microsoft PowerPoint Tips page.

 

If you would like to learn more about Microsoft PowerPoint, you ought to book yourself on one of our Microsoft PowerPoint Training Courses.

Microsoft Publisher Tips: Changing Picture Brightness

Published
by
Simpson
on October 3, 2014
in Microsoft Publisher Tips
. 0 Comments

 

In Microsoft Publisher if you want to change the brightness and the shade on any of your images look for the Icon on the toolbar.

 

  1. Click the Sun and Upward-pointed arrow icon from the toolbar to make it brighter
  2. Click the Sun and Downward-pointed arrow icon from the toolbar to make it darker.
  3. If you want to increase the image contrast, click on the icon with two half circles – one white and one black.
  4. You can decrease the contrast by clicking the image of two gray half circles.

Microsoft Publisher Toolbar

 

Visit our Microsoft Publisher Tips page to learn more useful information

Microsoft Access Tips: Adding Custom Shortcut Keys

Published
by
Shaun
on September 24, 2014
in Microsoft Access Tips and Tips and Tricks
. 0 Comments

Welcome to another Microsoft Access Tip. As we have discussed in previous articles, shortcut keys are a great way of saving time whilst working with different programs. In this tip, we will explain how you can add your own shortcuts to use to navigate your database

 

To assign a shortcut key to a field, follow these simple steps:

 

  • Edit the caption property of the label of the particular control you want to jump to, adding an ‘&‘ before the letter you want to act as the shortcut key.

 

For example, if you wish to be able to jump to a ‘Name’ field you could edit the ‘Name’ label accordingly: N&ame

 

  • In Form View the label will be displayed with the ‘a’ in name underlined: Name
  • Pressing ALT + A will switch the focus to the ‘Name’ field.

 

This technique can be used on any object that has a caption property and can make navigating your database a breeze.

 

If you would like to read about some of the keyboard shortcuts already available on Microsoft Access, take a look at our previous article: Speed up Access with Keyboard Shortcuts.

 

If you would like to read more tips, feel free to read our Microsoft Access Tip page.

 

If you would like to learn more about Microsoft Access, you should book yourself on one of our Microsoft Access Training Courses.

Microsoft Project Tips: How to Unhide Columns in a Gantt Chart

Published
by
admin
on September 9, 2014
in Microsoft Project Tips
. 16 Comments

Unlike Microsoft Excel, Project doesn’t have an unhide feature. When you hide a column in Microsoft Office Project, the column is only removed from view, not deleted from your plan. Also, hiding a column doesn’t remove any information from your plan.

 

To bring the column back again, you need to insert the column like you would with any new column. Any custom formatting that you applied to a previously hidden column will need to be re-applied to the inserted column.

 

  1. In a sheet view, select the column to the right of where you want to show the column.
  2. On the Insert menu, click Column.
  3. Select the Field name you would like to display.