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...
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
Summation, the addition of a...
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.