Microsoft Office training tips and examples

This video explains how to use the Today() function and conditional formatting to automatically colur cells that require action based on the computer clock.

The following video explains how you can create a simple organisational chart in Microsoft Visio

There are several ways to format slides in PowerPoint, use a Design Template, Format the Background or add a Picture. This videos show how you can add a design to two slides and a picture to the third.

There are several pre-set animations provided by Microsoft PowerPoint but to get a real wow factor you need to customise the animation yourself. This video explains how you can do just that

This video shows users how to set overtime for a resource which will then no longer display the resource as over allocated. Other solutions to the over allocated issues are: move the task, get another resource to do the task, link the task, delay the task and level the resource.

In table design, one of the field types is a calculation field, this is a new feature and it has limitations. In older versions of Access calculation could not be done at table level except for criteria checking. The calculating field is a great addition but note the restrictions before spending too long on formulae and functions.

This video explains how to create a simple table in Access using the Ribbon options

This video explains how to create a parameter query in Microsoft Access, which is one of the more useful features.

This videos explains how to use the Vlookup function with the Rows function to automatically add rows.

This video show how to create a simple user friendly Pivot table, avoiding all the pit falls that are associated with pivot tables.

How to add a numbered list to a Word or part of Word Table