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...
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...
