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...
Search results
Basic functions formulae (SUM, AVERAGE, COUNT, MAX & MIN)
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...
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...
Format Painter
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...
How to create a Hanging Indent on your paragraphsNote about using the automatic referencing features
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...
Sparklines
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
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...
Charts and Graphs...
Create a chart
Select the data for which you want to create a chart.
Pivot TablesIntroduction to pivot tables
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.