IT skills and training

Raise hand functionality (Teams)

If your participants wish to say something or ask a question in a Teams meeting, you can advise them at the beginning to unmute themselves if you want them to be able to speak as and when they choose, or if you don't want to be interrupted, you can ask them to submit questions in the chat window or use the raise your hand feature, which you can periodically check.

Chat window:

Teams Polls

Add a poll to a Teams chat

You can add a Poll in any chat window, whether you are in a meeting or if you are just using chat on its own.

If you are in a meeting and you want to set up a poll, open the Chat window and click on the ellipses (...) at the bottom of the chat

 

Welcome to the University of Chichester Physiotherapy

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Lectus nulla at volutpat diam ut venenatis tellus. Volutpat commodo sed egestas egestas fringilla phasellus faucibus scelerisque. Laoreet non curabitur gravida arcu ac tortor dignissim convallis aenean. Tempus quam pellentesque nec nam aliquam sem. Ut aliquam purus sit amet luctus venenatis lectus magna fringilla. Odio eu feugiat pretium nibh ipsum consequat. In est ante in nibh mauris cursus. Praesent tristique magna sit amet purus gravida quis.

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