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 isn't suitable for a full size chart.
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.
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.
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 painter can copy the format of your existing text and then 'paint' it onto the new text you've just copied in. This can save massive amounts of time if you are not sure how the imported text has been formatted.
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 than reading off the values using colour schemes and icon sets to show the quantities or differences between values more effectively than numbers would at a glance.
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 too much room on your worksheet.
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.
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 cell/s.
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:
