Search results

There are several ways to re-size a column or row, each has a specific use and will benefit you in different ways depending on what you wish to accomplish.

To resize an individual column or row you can click...

When you input data into Excel it is initially a 'data array' and although it is perfectly fine to leave data in this format it is sometimes easier or better to convert it to Table for the following reasons;

This page will cover the 5 basic functions found in the auto-sum drop-down menu:

Microsoft Excel can wrap text so it appears on multiple lines in a cell. You can format the cell so the text wraps automatically, or enter a manual line break. But this will prevent you from a cell potentially taking up...

This guide will show you how you can create hanging indents that you may need to use in your referencing or simply to format your paragraphs throughout your document.

If however, you are...

If functions are used when we want to specify a criteria to limit our function to. For instance, if we were interested in values above a certain amount we could use =countIf in order to count the number of the values in a range, that are above a certain value. There are multiple...

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...

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...

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. 

There are multiple ways of highlighting or removing duplicates from an Excel worksheet. 

Conditional formatting can be used to highlight duplicates ready for manual removal. This will use any formatting you select to overlay the data and show you any duplicates....

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...

When focused mailbox mode is enabled it will split your Inbox into two Tabs:

High priority emails are directed to the Focused tab, whilst low priority emails like advertisements and generic newsletter items are directed to the "Other" Mailbox...

Used effectively for activities such as research and self-promotion, social media can dramatically enhance your employability. However, if used carelessly, social media can significantly damage your chances in the job market. This guide outlines some of the things you need to consider, and the...

Here are a number of useful features, tips and reminders for you during the online marking process

When marking assignments, please make sure that you are checking for the dyslexia icon. This appears alongside the student ID when you are viewing the submissions...

In Excel to highlight/select data you can "click and drag" around the data to select it, there are in fact several different ways you can highlight/select data a lot faster or more efficiently. Especially when you have large amounts of data. 

I shall...

Conditional formatting is a feature that has a variety of uses. Mainly surrounding different ways of displaying data corresponding to the value found within the cell or range of data. This can help you visualise the data faster...

Create a chart

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. 

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...

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: 

'Text to columns' is found in the 'data'...

Excel can handle lots of different format types of numbers, but you must regularly choose what type of number format you wish to be expressed on the cells containing those numbers. If you don't, you may suffer problem when calculating functions or expressing the data in...

The SORT function sorts the contents of a range or array.

In this example we are sorting an array of sales which currently unordered. When =SORT(B3:E51) is used we will see the array now sorted by the first column, in this case A-Z of the Item column: 

There are several ways to re-size a column or row, each has a specific use and will benefit you in different ways depending on what you wish to accomplish.

To resize an individual column or row you can click...

When you input data into Excel it is initially a 'data array' and although it is perfectly fine to leave data in this format it is sometimes easier or better to convert it to Table for the following reasons;

Below are a list of Excel guides currently available, these are a work in progress and will be added to as time goes on. If however you have a need for a tutorial that doesn't exist yet then please email ITSkills@chi.ac.uk to request it.

SharePoint sites exist in a number of different ways and therefore accessing them for the purposes of syncing with your local PC are done differently according to their type:

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

 ...

You can contact individuals via Microsoft Teams to communicate by text, voice, video and share your screen. This does not require you to join a Team and can be useful for direct communication.

If you hover over a participant and click the Ellipses that appear, you have a number of options, such as:

There are two ways to set up Breakout roomsIn Teams meetings, you can either create them on the moodle page in advance, or use the Microsoft breakout rooms feature, so which should you use?

Setting them up on the Moodle page in advance

There are a number of ways you can check and test your audio and video device settings

click on the account icon at the top of...

If you have a shared document in Teams, Office 365 groups, in SharePoint or in Onedrive, you can edit it at the same time as other people when it is opened online in a browser.  This enables you to work collaboratively on the same document, either in real time or at separate times, without the...

There are two ways that you can download submissions:

You can do this one by one by clicking on the file name

Or to download all at the same time, at the top under Grading action, choose Download all submissions.
 

To use live captions in a meeting, go to your meeting controls and click the ellipses (...) then choose Turn on live captions. 

To stop using live captions, go to the meeting controls and click the ellipses (...) then choose Turn off live captions. 

Objects in Microsoft Office (Word, Excel, Powerpoint etc) can be grouped together to perform as a singular object. This includes; images, textboxes, shapes and SmartArt.

Once grouped, the layout of each object relative to one another will stay the same even if you move or...

The Animation pane allows you to change the order objects animate in, without needing to remove and reapply animations.

The Animation pane can be found in the Animations tab of the ribbon: 

When selected the animation pane open in the sidebar and will...

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.

In the 'Insert' tab of...

In PowerPoint 2019 and onwards you can record a Presentation. This will save your narration of the slides (audio or video) and the timings of your slide changes and animation triggers. Once the presentation recording has been complete. The video/audio will be...

'Slide Masters' are the templates or layouts, which are shown in in your 'new slide' button: 

These can be modified, duplicated or created from new, so that you can include your own template slides to work from. Slide Master can also contain logos or images,...

The HEAR is a University-verified online document that records a student's broader achievements, as well as their programme and module details and results. The HEAR is added to during a student's time at the University and a final HEAR is released to applicable students when they complete their...

Information about the General Data Protection Regulation (GDPR) is available on the Data Protection area of the staff intranet (login required).

Microsoft has a great collection of help pages for how to get the most out of Microsoft Stream. 

Starting this academic year, some lead lectures will be delivered online using Microsoft Teams. These guides will help you set up these online lead lectures in advance, and show you the various things you can do once in the lecture.

If you wish to allocate certain submissions to specific markers, to do this:

There are a few different ways of making video recordings but for the moment we recommend using Microsoft Teams as this should be the most familiar to you. 

Jump to:

When you are in your Teams meeting, select the More icon at the top of the page, and select Record and transcribe > Start recording. All members of the meeting will see a message informating them that the meeting...

If you are a staff member you will be able to change your voicemail preferences within the Teams app. You will be able to change if your number simultaneously 'also rings' another group or individual or what happens when a call is unanswered and the length of time before the voicemail...

Word has a feature that allows users to automatically generate an automatic table of contents, assuming that heading styles have been used. This table of contents supports different levels of indentation to highlight chapters and sub-chapters of the document itself. ...

Page & Section breaks have multiple uses. They are most notably used to create different sections within the same document, so that you can apply a different page orientation, affect page numbers and different headers/footers per section.

You can find the...

Footnotes and endnotes are useful tools for adding citations, comments, or explanations to your text.

This guide will walk you through the steps to insert and manage footnotes and endnotes in Microsoft Word.

Footnotes and...

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:

These can all...

The Dictation feature allows you to speak into your microphone, and Word will convert your speech into text. Here’s how to use it:

Check Your Microphone: Ensure you have a working microphone connected to your computer.

Open Microsoft Word: Launch Microsoft Word and open the...

OneDrive is used to store files, folders, and photos in the 'cloud' (Online) so you can access them easily on multiple devices and share them with colleagues, or with people outside the university.

OneDrive can be accessed in your web...

Layouts, Design Theme and Slide Size

How to create a text box
SmartArt
Adding/editing shapes
Grouping

Adding Images
Remove background (Images)
 

Embedding Videos
Adding Audio

Use SmartArt to quickly and easily make a visual representations of your information. You can choose from among many different layouts including: Lists...

This page will show you how to embed an online video like YouTube in your PowerPoint Presentation.

1. Find the Youtube video you wish to embed in your Internet browser (on Youtube.com Website): 

2. Select the URL (address)...

PowerPoint has a feature which allows you to remove the background from an image.  There are limitations such as needing a high-resolution, decent quality image and a clearly defined background/foreground, It still has many uses and can allow you to bypass the need for you to search for a 'cut-...

The fill handle can be used in a variety of ways that may save you time. From repeating sequences or repeating data to repeating a formula over a large area. 

The fill handle is the name given to the green dot found on the bottom right corner of the selected...

If functions are used when we want to specify a criteria to limit our function to. For instance, if we were interested in values above a certain amount we could use =countIf in order to count the number of the values in a range, that are above a certain value. There are multiple...

Below are a list of Excel guides currently available, these are a work in progress and will be added to as time goes on. If however you have a need for a tutorial that doesn't exist yet then please email ITSkills@chi.ac.uk to request it.

External Examiners will be able to view MAF Online modules, via ChiView

This workflow outlines how you can use Microsoft Teams to record your videos and how you can store and share them. 

Whilst students like a consistent experience, we understand that staff have their own ways of marking, grading and giving feedback; we believe that our workflow allows for both. 

 Watch the video guide for Sharing your recordings on Moodle

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...