Excel Quick Selection Techniques
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 effciently. Esspecially when you have large ammounts of data.
I...
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.
Click and drag a column or row header's boundary:To resize an individual column or row you can click...
Freeze 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...
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 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...
This page will cover the 5 basic functions found in the auto-sum drop-down menu:
SUM
AVERAGE
COUNT NUMBERS
MAX
MIN
Summation, the addition of a...
Cell 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...
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...
Change 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...
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...
A 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 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...
Create a chart
Select the data for which you want to create a chart.
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...
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.
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...
VLC media player
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...
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.
...Track 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....
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...
When focused mailbox mode is enabled it will split your Inbox into two Tabs:
Focused & OtherHigh 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 GIMPFind 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 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...
A 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...
Create a chart
Select the data for which you want to 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.
...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 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'Text to columns' is found in the 'data'...
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...
Find 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...
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...
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.
Click and drag a column or row header's boundary:To resize an individual column or row you can click...
Freeze 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...
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 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...
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.
BeginnerExcel...
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...
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 ...
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...
There 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...
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...
PowerPoint 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...
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...
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...
ChiView is the way to access information in the student records system.
Log in to ChiView at: https://chiview.chi.ac.uk
StudentsMATLAB 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:
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 startedIn 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...
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...
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:
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...
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:
iOS...
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...
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. ...
Styles 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...
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...
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...
Captions 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. ...
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...
Launch PowerPoint and open a new or existing presentation.
SupportMe 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...
Use SmartArt to quickly and easily make a visual representations of your information. You can choose from among many different layouts including: Lists...
Adding 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...
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)...
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 EditingImages 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-...
This page will cover the 5 basic functions found in the auto-sum drop-down menu:
SUM
AVERAGE
COUNT NUMBERS
MAX
MIN
Summation, the addition of a...
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...
Cell 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...
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.
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...
This workflow outlines how you can use Microsoft Teams to record your videos and how you can store and share them.
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...
Adobe Creative Cloud is available on campus computers for Student and Staff usage.
In order for it to work properly it is important that if asked you log in choosing the correct licence instance.
When you are asked to login by Creative Cloud or one of the products...
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 or from another participating university library.
The Inter-library...
Microsoft Teams allows you to set up online meetings with up to 350 people.
Note: Creating a Teams meeting may link the...
You are entitled to a free subscription to Microsoft Office for computers and mobile devices.
More information: Microsoft Office installation.
Dell Advantage offers discounts on selected products...
Layouts, Design Theme and Slide Size
Text
How to create a text box
SmartArt
Adding/editing shapes
Grouping
Adding Images
Remove background (Images)
Embedding Videos
Adding Audio
Animations/...
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...
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/Microsoft 365 then click OneDrive via the apps icon...
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...
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...