Microsoft Office training tips and examples

Conditional formatting

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

How do you rate these videos

Are they informative

  • Yes
  • No
See results without voting

An Organisational Chart

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

Organisational charts with Microsoft Visio

How to Format slides in PowerPoint

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.

Formatting slides with Microsoft PowerPoint

Animating a slide

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

Advanced slide animation in PowerPoint

Overtime in Microsoft Project

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.

Setting overtime in Microsoft Project

Calculating in Microsoft Access

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.

Creating a calculated field in Microsoft Access

Create a table in Microsoft Access

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

Creating a simple table in Microsoft Access

A Parameter query

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

Creating a parameter query in Microsoft Access

Vlookup with the Rows Function

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

Vlookup with the Rows Function

A simple Pivot Table

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

A Pivot Table

This is how you create a basic formula in Microsoft Excel
This is how you create a basic formula in Microsoft Excel | Source
This is how you can crate a basic IF statement
This is how you can crate a basic IF statement | Source
Source
Source

Tables in Word

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

© 2013 stevesaxton

Comments

No comments yet.

    Sign in or sign up and post using a HubPages Network account.

    0 of 8192 characters used
    Post Comment

    No HTML is allowed in comments, but URLs will be hyperlinked. Comments are not for promoting your articles or other sites.


    Click to Rate This Article
    working