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;
Search results
Creating a TableTable data can be sorted and filtered faster and at the table...
Wrap Text & Merge and CentreWrap Text
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...
Extensions can only be granted by the Module Coordinator or Departmental Administrator.
To grant an extension to a student:
Assignments are submitted to the module's Moodle page.
The submission link will look something like this:
Assignment activity.png
Quick links:
ChiReadingLists for students
ChiReadingLists is the University's online reading list software which is used to access all core and recommended resources such as ebooks, videos, website links, and books available in our library catalogue. You can filter, search for resources, mark which ones will...
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...
Word Tutorials Styles How to show hidden formatting symbols Format Painter How to...
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 Editing IF functions
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...
Relative cell references and absolute cell references
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...