Software and apps

Installing Adobe Creative Cloud Applications on a University Computer

University staff are licenced for the Adobe Creative Cloud suite of software to install on their office computers. This guide provides instructions on how to access and install Adobe software packages to a University computer.

Whilst all University Computers can run the Adobe Creative Cloud software there are some packages, such as After Effects and Premiere Pro which run best with specialist hardware. Specialist hardware can be purchased by departments in line with the University ICT Provisioning Policy 

How to set up call diverting in Teams

What is call diverting?

Call Diversion lets you divert your calls to almost any number, call group or mobile. It also dictates what happens should the call go unanswered and after how long. It can even be used to simultaneously ring other numbers/contacts. 

~ This feature is only available for staff that have their extension number enabled through Teams ~

ESports FAQ

At the University of Chichester, we're committed to providing as best an experience for gaming as we can, whilst remaining within the confines of a secure environment for all staff and students.

To facilitate this, we have implemented a dual boot system, where-by computers in the BRC Tech Park PC Suite, and the BRC LRC IT Study Rooms can be rebooted into an alternative copy of Windows to run games.

 

 

Text to Columns

Excel provides a feature that is intended to split a single column of data into multiple columns. For instance, if you had a column of full names (first and last) and needed to separate these out into two columns: 

Pivot tables

Pivot Tables

Introduction to pivot tables

Pivot tables can be used for many things however their best function is served by collating data for you. This is easier to create when the data is presented in log format.  What we mean by this is that you should log each transaction individually and not auto-sum or total anything as it will be done by the Pivot table for us.  

an example of a log entry with sales data could be:

Drop-down lists

Excel - Drop-down lists

Excel has a feature that allows you to format a cell so that it may only contain certain answers you have specified. These will be displayed as a drop-down list that displays when a cell with the formatting on is selected. This is useful for removing things such as spelling errors or typos and allows less chance for error whilst inputting data. 

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