The vast majority of all University computers have been updated to Windows 10 and Office 2016.
New features available in Windows 10 have been documented on the Windows 10 Moodle Page. If you would like a familiarisation session, please book a 1-2-1 tutorial, please email ITskills@chi.ac.uk...
Microsoft Wireless Display AdapterThe Wireless display adapter can be used to "stream" your screen to another monitor/TV via a HDMI connection allowing you to present from your laptop to a larger screen.
How do I set up my Microsoft Wireless Display Adapter?First, make sure you have the...
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...
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...
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...
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...
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...
Word Tutorials Below are a list of Word 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.
Formatting...
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...
Displaying hidden formattingWord has many formatting features which are not immediately obvious and can be 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...
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...
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...
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.
...
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...
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. ...
Adding a Table of FiguresWord has a feature for annotating figures/picture within your document and creating a table of page numbers.
Once you have your document open with the relevant images in place we will need to make space for the table to go in.If you have created space for...
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...
This guide will show you how you can change your name as it appears in the comments of a document, including being anonymous.
The whole Microsoft office suite will default to the name associated with the account used to authorise the usage of Office 365....
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...
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...
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...
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 SmartArt?Create a SmartArt graphic to quickly and easily make a visual representation of your information. You can choose from among many different layouts, to...
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 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'...
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...
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...
PowerPoint - Exporting a PDF
Sometimes you may need to convert your PowerPoint presentation to a PDF for various reasons including printing. This is a very easy process and will duplicate your file assuming you have also saved as a PowerPoint file to start with. But it is reasonably well...
Many of the keyboard shortcuts used in PowerPoint are also used in the rest of the Microsoft office suite.
The following table itemizes the most frequently used shortcuts in PowerPoint.
To do this...
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...
PowerPoint has a feature which allows you to remove the background from an image. Although it has limitations such as needing a high-resolution 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-out image to...
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...
Before leaving the campusBefore you leave either University campus with a University laptop you MUST ensure you have signed into the laptop once. This is to ensure that your profile is loaded onto the laptop so you can be authenticated whilst off-campus.
Signing in to the laptopSign in to...
Creating a Microsoft Team for Business Use Go to the Teams homepage/tab using the Navigation menu on the leftSelect "Join or Create team" on the top right:
Click "Create a Team":
You will then be asked what type of Team you would...
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...
PowerPoint - Inserting ImagesAdding images to a slide is one the features of Powerpoint you will use most often.
1. Inserting an Image from your computer (from the menu ribbon)Inside the 'Insert' tab of the menu ribbon, you will see 'Pictures:
This will open file...
PowerPoint TutorialsBelow is a list of PowerPoint guides currently available. If however, you have a need for a tutorial that doesn't exist yet then please email ITSkills@chi.ac.uk to request it.
BeginnerHow to Input textboxes
How to...
Connecting to our eduroam Wi-Fi network on WindowsLeft-click the network icon in the system tray. This is next to the time/date in bottom right corner and may look like a dot with a curved lines
or a compter screen with a cable
From the list of...
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...
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...
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...
Tutorial's and seminars can still be held via an online meeting in Skype for Business. Anyone wishing to arrange an online meeting will need to have Skype for Business installed on their computer and anyone attending a meeting can also join via Skype for Business if they have it installed or...
In order to reduce the file size of any Microsoft document (Word, Powerpoint or Excel) there are a few steps we can take without removing content.
Images usually make up the vast majority of a document's file size as text uses very little file space by comparison. Although removing...
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...
The Accessibility Tool in Moodle allows you to set the colour scheme, font style, readability and text size in Moodle. These settings apply only to you and do not affect how anyone else views the pages.
There are two ways to open the Accessibility Tool:
From the burger menu...
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...
The University has made high powered HP Workstations available for remote use by students and staff on selected modules.
Unfortunately, some software will not be available remotely due to licensing restrictions of the software manufacturer. The most notable exclusion is Adobe Creative...