IT skills and training

How to create a text box

How to create a text box

PowerPoint will generally create placeholders for text and images on each new slide unless you choose a blank slide specifically. However, sometimes you will want to create your own. The insert text-box tool is available for this situation.

GIMP image editor

GIMP (GNU Image Manipulation Program) is a free and open-source raster graphics editor used for image retouching and editing, free-form drawing, converting between different image formats, and more specialised tasks.

Outlook - Managing your Emails

Managing your emails - Outlook training videos

This video series aims to highlight the features and tools of Outlook (Desktop App) that will help you to comply with your departmental file retention policies and data protection legislation. We have all become used to having powerful search features within Outlook that seemingly removed the need to organise emails in the way we would do paper files.

Word - Track Changes

Track Changes

Track changes can be used to lock a document. Any changes made to the document after it has been locked will feature in a list of 'tracked changes' that can be approved or denied. These are similar to comments but will update the original document if approved. 

 

Excel - Vlookup & Hlookup

Vlookup & HLookup

Excel can use a function to lookup and retrieve data from a specific column or row within a table. Vlookup works to return back a column of data and Hlookup works to return a row of data instead, therefore the V stands for vertical lookup and the H, Horizontal lookup. 

Syntax

=Vlookup(Value, Table, Col_index, [Range_lookup])

Arguments

Value - The Value to look for in the first column of the table

Looping a Video or a Series of Videos on VLC media player

 

VLC media player

VLC is a free and open source cross-platform multimedia player and framework that plays most multimedia files as well as DVDs, Audio CDs, VCDs, and various streaming protocols. One of the features that VLC can provide is the option to 'loop' or replay videos once they have finished playing so that they continue without any extra input from the user.

Looping a video

To loop a video first we need to open VLC media Player:

Adding an element to a chart/Graph

Adding Chart Elements

When creating charts/graphs in Excel you may find that some labels are not added by default and must be added manually or are in an unsuitable place. Excel also allows for modification of these labels, as well as their placement. In this example i'm going to amend a pie chart. If you are not sure how to create a pie chart, you can find a guide on chart creation here.