Excel Quick Selection TechniquesIn 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 effciently. Esspecially when you have large ammounts of data.
I...
Resizing Columns and Rows in ExcelThere 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.
Click and drag a column or row header's boundary:To resize an individual column or row you can click...
Freeze PanesFreeze Panes can be used to lock specific columns or rows in place so that you may see them where-ever you are within the data.
In the view tab of the ribbon you will find the "freeze panes" drop down menu:
Ribbon1.png
This menu...
Creating a TableWhen 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;
Table data can be sorted and filtered faster and at the table...
What is a Mathematical operator?This page will guide you through using Excel to create basic mathematical operations. This is very similar to creating a function or formula except that we are not using the function's operative such as (=Sum) or (=Average) or...
Basic functions formulae (SUM, AVERAGE, COUNT, MAX & MIN)This page will cover the 5 basic functions found in the auto-sum drop-down menu:
SUM
AVERAGE
COUNT NUMBERS
MAX
MIN
SUMSummation, the addition of a...
Relative cell references and absolute cell referencesCell references are used in almost all functions and they interact differently with the Auto-fill handle depending on what type of reference you have used:
The fill handle is shown when a cell is selected (by left clicking it), you will...
Wrap Text & Merge and CentreWrap TextMicrosoft 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...
Format PainterChange font, style, point size and all formatting, in one go to match pre-existing text
Many times in Word you have copied and pasted something into your document only to find it is in a different font, size or is in bold or italics or some completely different format. Format...
How to create a Hanging Indent on your paragraphsNote about using the automatic referencing featuresThis 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...
SparklinesA sparkline is a small graphic designed to give a quick representation of numerical or statistical information within a piece of text, taking the form of a graph without axes. This is displayed within a single cell and can be used to visualise data when you don't have enough room or it...
IF functionsIf 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...
Charts and GraphsCreate a chart
Select the data for which you want to create a chart.
...
Pivot TablesIntroduction to pivot tablesPivot 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...
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.
Click into the start menu and begin...
Adding Chart ElementsWhen 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...
VLC media playerVLC 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...
Vlookup & HLookupExcel 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.
...
Track ChangesTrack 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.
Turning on...
There are multiple ways of highlighting or removing duplicates from an Excel worksheet.
Conditional FormattingConditional 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....
If you are concerned about the health impact of "Blue Light" (the light that comes from a PC monitor, tablet, mobile phone, TV), then there is a filter built into Windows 10 that you may wish to enable.
Windows 10 has a Night Light setting which gently reduces the monitors blue-tones,...
What is Origin?Origin is a video game digital distribution platform developed by Electronic Arts. 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...
Specialist software on University managed Windows desktops and laptops can be accessed using the ‘Managed Software Centre’, which contains a list of all the software currently licensed for you and/or your device.
In the Start Menu, scroll down to ‘Managed Software Centre’,
...
What is the Focused Mailbox?When focused mailbox mode is enabled it will split your Inbox into two Tabs:
Focused & Other 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...
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.
How to download GIMPFor University PCs, you can download GIMP from the...
Displaying hidden formattingWord has many formatting symbols which are not immediately obvious and are hidden from view by default.
The following formatting options have no visibility unless the ¶ button is selected:Section breaks,Page breaks,Soft and Hard carriage...
Excel - Find and ReplaceFind and/or replace is a powerful feature that allows you to search for a text string within your data set. It will show you all of the times that Excel can see the text string in your document, allowing you to be taken to the next word by clicking the 'next' button. If...
Conditional Formatting
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...
SparklinesA sparkline is a small graphic designed to give a quick representation of numerical or statistical information within a piece of text, taking the form of a graph without axes. This is displayed within a single cell and can be used to visualise data when you don't have enough room or it...
Charts and GraphsCreate a chart
Select the data for which you want to create a chart.
...
Vlookup & HLookupExcel 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 FormattingConditional 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 - Drop-down listsExcel 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...
Pivot TablesIntroduction to pivot tablesPivot 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...
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'Text to columns' is found in the 'data'...
Flash fill and the fill handleThe 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...
Excel - Find and ReplaceFind and/or replace is a powerful feature that allows you to search for a text string within your data set. It will show you all of the times that Excel can see the text string in your document, allowing you to be taken to the next word by clicking the 'next' button. If...
Number Formatting in ExcelExcel 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...
Resizing Columns and Rows in ExcelThere 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.
Click and drag a column or row header's boundary:To resize an individual column or row you can click...
Freeze PanesFreeze Panes can be used to lock specific columns or rows in place so that you may see them where-ever you are within the data.
In the view tab of the ribbon you will find the "freeze panes" drop down menu:
Ribbon1.png
This menu...
Creating a TableWhen 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;
Table data can be sorted and filtered faster and at the table...
What is a Mathematical operator?This page will guide you through using Excel to create basic mathematical operations. This is very similar to creating a function or formula except that we are not using the function's operative such as (=Sum) or (=Average) or...
Excel TutorialsBelow 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.
BeginnerExcel...
Wrap Text & Merge and CentreWrap TextMicrosoft 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...
Creating a Chat for instant messaging, audio or video callingYou 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.
Select the 'New chat' icon in the...
Any undergraduate or postgraduate student who believes that they have serious and unexpected short-term personal or medical circumstances which have impacted on their ability to submit, or that have seriously affected his or her performance in an assessment, and which he or she wishes a Board of...
eStream is the secure video platform for education and offers TV, radio and satellite recordings, interactive videos and quizzes and Connect, which allows access to content from lots of other institutions around the world to include in your Moodle pages.
With eStream you can:
Create...
Have you ever noticed that some website addresses have a prefix of http or https?
Well, the 's' stands for secure, so if a website has https it means that the content is encrypted, and therefore less likely to be intercepted by a third party (hackers!). When shopping or inputting any...
Microsoft To Do overviewA smart daily plannerSet yourself up for success with My Day, intelligent and personalised suggestions to update your daily or weekly to do list. With both a Microsoft to do desktop app and mobile app available, it is easy to stay on task all day long....
What is Steam?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...
How to Add Notes to your Presentation (Presenter View)While giving a PowerPoint Presentation you can make use of something called Presenter view, this mode allows the projector* to display your presentation full screen without your notes showing to the audience. The second monitor* will show a ...
Animation PaneThe 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...
Adding an audio file to your presentationThere are two ways to add audio to a presentation:
1. Adding Audio already on your PC (saved)
2. Record Audio (record live)
To add a clip from your computerHave the audio file saved to the computer locally as an MP3 file - (if you have...
How to create a text boxPowerPoint 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...
What is recording in Powerpoint?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...
PowerPoint - Zoom SlidesPowerPoint has a new feature which mimics the style of presentation of Prezzi, using one large slide to place all of the subsequent slides on. Throughout the presentation, these slides will be zoomed into when that slide is reached, giving the impression that the whole...
Slide Master '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,...
Microsoft Teams is a tool designed for team communication and collaboration, combining chat, audio/video calling, file storage, and apps. You can use Microsoft Teams either from the Teams App or by using the Teams web version.
You will get the best user experience by using the Teams...
Announcements to studentsAnnouncements to students are posted on Moodle. They are posted in either an area’s news forum, or on the ‘Student News (Other)’ page. Students navigate to the appropriate news forums to read them. Announcements are also emailed to anyone who has chosen to enrol on that...
Submitting an IT provisioning requestAny staff member can submit a request for IT provisioning, however, the departmental budget holder will need to authorise the request before it can be progressed.
1. From the Self Service Portal click on Log a Request
2. Search...
You can set Adobe Reader as the default programme for viewing pdfs on Windows computers by following these steps:
1. Click on the Start button and select the Settings cog
2. In the Windows Settings display, select Apps
3. Within the App ...
It is important that the University has an accurate record of attendance. The expectation is that students attend all timetabled sessions for each module.
Each department has a student attendance management coordinator if you have any questions
The Student Attendance and Absence...
To change time zone for your office 365 account, you must first access your emails via mail.chi.ac.uk (otherwise known as the Office 365 portal). From your emails, click on the settings cog. This is found of the top right of the screen on the menu bar and then select "view all Outlook...
Before you startThe device must be a University of Chichester laptop logged in with a staff account. The process described will only work for staff. Students connect to the RemoteApp (unless the laptop has been specifically set up for students to see the local version of SPSS).You can...
ChiView is the way to access information in the student records system.
Log in to ChiView at: https://chiview.chi.ac.uk
StudentsAn overview of ChiView for students is available on the student induction pageGuide to making module selections (available at certain times of...
MATLAB is a high-performance language for technical computing. It integrates computation, visualisation, and programming in an environment where problems and solutions are expressed in mathematical notation.
Simulink is a block diagram environment for multidomain simulation and model-based...
Browsing data includes: cookies, cache, history and saved passwords. Occasionally you may need to clear some or all of this data. Different browsers have slightly different methods. The links below take you to guides produced by the browsers.
Please note:
As new versions of the...
Calls can be logged to Estate Management via the 'Estates' link on the SupportMe home page, e.g. for reporting issues with power sockets, heating, plumbing etc.
Once your call is logged it will be forwarded to the appropriate team, and you'll receive a confirmation email with a call...
Microsoft has a great collection of help pages for how to get the most out of Microsoft Stream.
Getting startedPlay a video or audio file across Microsoft 365Record a videoManageWhere to find video and audio settingsView, edit, and manage video transcripts and...
Microsoft Stream chaptersIn most instances, creating chapters is a faster and easier way to help your viewers quickly reach the important parts of your recordings. Rather than editing out sections (where perhaps you all went off on a coffee break), it could be quicker to add a chapter for when...
Log on to chiview.chi.ac.ukFrom within the 'My details' section click 'View and Edit My Contact Information'
Click 'Home Information'
In the 'E-mail address' field type your personal email address, then 'Save'
...
If you cannot locate the book or journal article you require on the library catalogue or eResources then you can request it as an Interlibrary Loan. This enables the delivery of books or documents from the British Library.
How do I request an item?Fill in the online Interlibrary Loan form...
To use SPSS on personal devices you will need to follow installation instructions here https://help.chi.ac.uk/accessing-university-desktops-home-remote-access
Once you have completed that process you can access SPSS as if you were on campus:
If you have any difficulties...
Click the submission link on the Moodle module pageOn the submissions overview page you will see the number of submissions expected and received
Click the view all submissions button to see more informationYou can extend the page by clicking...
Extensions can only be granted by the Module Coordinator or Departmental Administrator.
To grant an extension to a student:
Identify the student using their Student No.Click the submission link on the Moodle module pageClick the view all submissions button to see...
Assignments are submitted to the module's Moodle page.
The submission link will look something like this:
Assignment activity.png
Quick links:
Submitting a video or multimedia assignmentSubmitting a written assignment...
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:
Record an in-class lecture or presentationRecord an online Teams meetingRecord a short video...
Important guidance for noise suppression in Microsoft Teams (and when you may want to turn it off)Microsoft Teams is designed, by default, to focus on one main speaker. To do this, it uses active noise suppression to remove background noise, such as music, dogs barking or colleagues talking in...
Managing your emails - Outlook training videosThis 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...
This page shows how to check which version of operating system you have for iOS (iPhone/iPad), Android, Apple Mac (OS X), and Windows.
iOS (iPhone/iPad)
How to check which iOS version you have:
Tap Settings > General > AboutThen look under VersioniOS...
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...
Media Students and Staff have access to additional storage, depending on the module and/or projects they are working on.
It can be found at the following locations:
From Windows:
Opening "This PC" and selecting "DCI Storage". If for any reason this option is not present...
This page contains the SEAtS Student Attendance Management system user guides.
SEAtS _Date Filtering.pdf
SEAtS _Date Filtering.pdf
SEAtS _Exporting Data.pdf
SEAtS _Exporting Data.pdf
SEAtS Student...
Automatic Table of ContentsWord 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. ...
StylesStyles can be quickly used to apply a formatting choice over a large area of a document. All text is initially created under the Normal style and will remain in this style unless Word is told otherwise. You can modify any existing style or create your own if there is not a pre-existing...
How to add a Section breakPage & 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...
Page numbering happens in the headers or footer of the document, making use of section breaks to indicate where page numbering will and will not be present. This guide will focus on adding page numbers from the beginning but will cover their usage afterwards.
Adding Page numbersOn the...
Creating a Table of Figures in Microsoft WordCaptions are useful for providing context to images, charts, and other illustrations in your document. A table of figures helps readers navigate these elements quickly by creating a table with all 'captions' in it as well as their page number. ...
Page View options, multiple windows and multiple page viewThis 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...
DictationThe 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...
Adding a CommentTo add a comment, first, highlight the text you want to comment on. Then, go to the "Review" tab in the ribbon and click on "New Comment." Type your comment in the box that appears:
Type out your comment and press Ctrl + Enter or click the 'Submit...
What is OneDrive?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.
How can I access my OneDrive Quickly?OneDrive can be accessed in your web...
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.
To access OneDrive login to Email/Office 365 then click OneDrive via the apps icon...
Creating New SlidesLaunch PowerPoint and open a new or existing presentation.
Go to the 'Home' tab on the Ribbon.Click on the 'New Slide' button:
The top half with create a 'Title and Content' slide, the bottom half will allow you to choose a layout: ...
PowerPoint TutorialsLayouts, Design Theme and Slide Size
Text
How to create a text box
SmartArt
Adding/editing shapes
Grouping
ImagesAdding Images
Remove background (Images)
VideoEmbedding Videos
Adding Audio
Animations/...
Microsoft Office installation - student & staffYou are entitled to a free subscription to Microsoft Office for computers and mobile devices.
More information: Microsoft Office installation.
Dell Advantage - student & staffDell Advantage offers discounts on selected products...
SupportMe OverviewSupportMe is a self-service portal for raising support calls e.g. IT Support calls, reporting lost property, requesting library books to be sent cross-campus for you etc.
Calls can also be logged to Estate Management via the 'Request Estates Support' link...
Social media tools such as Instagram, X, TikTok and Facebook are a part of everyday life. Used well, they can add to your learning experience at university, and make you more employable when you graduate. But used poorly, they can cause lasting damage to you and others.
Your responsibility...
What is SmartArt?Use SmartArt to quickly and easily make a visual representations of your information. You can choose from among many different layouts including: Lists...
Inserting ImagesAdding images to a slide is one the features of PowerPoint you will use most often. You can insert Images from multiple locations: On your computer, from the web or off of your clipboard:
Inserting an Image from your computerInside the 'Insert' tab of the menu ribbon, you...
How to Embed a YouTube Video In PowerPointThis 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)...
Word Tutorials Below are a list of Word guides currently available. If you have a need for a tutorial that doesn't exist yet then please email ITSkills@chi.ac.uk to request it.
Basic Document EditingStylesHow to show hidden formatting symbolsFormat PainterHow to...
How to add shapes and customise themImages 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.
Inserting a shape (to customise)Powerpoint...
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-...
Basic functions formulae (SUM, AVERAGE, COUNT, MAX & MIN)This page will cover the 5 basic functions found in the auto-sum drop-down menu:
SUM
AVERAGE
COUNT NUMBERS
MAX
MIN
SUMSummation, the addition of a...
Flash fill and the fill handleThe 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 functionsIf 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...
Relative cell references and absolute cell referencesCell references are used in almost all functions and they interact differently with the Auto-fill handle depending on what type of reference you have used:
The fill handle is shown when a cell is selected (by left clicking it), you will...
Excel TutorialsBelow 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.
BeginnerQuick...
You can access your timetable in Publish. You will find a link in either Moodle or ChiView.
Moodle and ChiViewIn Moodle there is a timetable option in the menu. Once expanded you will see a link to Teaching Timetables.
In ChiView, once you are logged in, you will...
Introducing the Microsoft Stream workflowThis workflow outlines how you can use Microsoft Teams to record your videos and how you can store and share them.
Uploading: you can upload previously recorded content (such as your downloaded Panopto recordings) into OneDrive, SharePoint or a...
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...
As the ESports system removes all changes upon reboot, creating local file recordings of gameplay is impractical.
Therefore, we have created an onsite streaming server, to which you can direct your OBS / Streamlabs etc output. Anything streamed to this server will then save to MP4 file on...
This guide has been setup to support you when preparing your Moodle pages for the new semester.Please review each section carefully:
*/
1. Import your content from a previous years' Moodle pageMoodle allows you to move content from one page to another. You will need to have...
Microsoft Teams allows you to set up online meetings with up to 350 people.
Set up a Meeting using your online calendarSet up a Meeting using your desktop Outlook calendarSet up a Meeting from within TeamsTip! Setting your meeting so that everyone can by...
Whether you are a student or member of University staff, many of our systems, software and services are available to access from offsite.
Useful links:When working off-campus for the first time, here are some useful links to University systems: University Links
Support for using our...