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.
=Vlookup(Value, Table, Col_index, [Range_lookup])
Value - The Value to look for in the first column of the table
Steam is a video game digital distribution platform developed by Valve Corporation. This platform is used by the university to install certain items of software from games to applications. To access this platform, you must have an account. If you already have one you may sign in with it on Campus, if you don't, however, you will need to create one.
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.
To loop a video first we need to open VLC media Player:
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.
Word has a feature to auto-recover and save documents in case of crashes or problems to the file. This area is hidden on the computer under a hidden folder and therefore accessed using a method that's different from accessing a regular file.
Images and text boxes can be shaped into more than just a square that we start with, as PowerPoint allows for custom shapes. This guide will show the steps required first generate a shape and then to edit it.
Below is a list of PowerPoint guides currently available. If however, you have a need for a tutorial that doesn't exist yet then please email ITSkills@chi.ac.uk to request it.
This guide will show you the several types of views available within Microsoft Word that will be able to help you view your document the way you'd like to.
Word has several different ways you can view documents:
