Excel has a feature that allows you to format a cell so that it may only contain certain answers you have specified. These will be displayed as a drop-down list that displays when a cell with the formatting on is selected. This is useful for removing things such as...
Search results
When focused mailbox mode is enabled it will split your Inbox into two Tabs:
Focused & OtherHigh priority emails are directed to the Focused tab, whilst low priority emails like advertisements and generic newsletter items are directed to the "Other" Mailbox...
The following formatting options have no visibility unless the ¶ button is selected:
=Unique is a function used in Excel to find only Unique values in a range or array.
e.g. If you have a list of Departments:
We can use the unique function to identify all the unique values in this list and produce a list of them...
Excel Quick Selection Techniques
In Excel to highlight/select data you can "click and drag" around the data to select it, there are in fact several different ways you can highlight/select data a lot faster or more efficiently. Especially when you have large amounts of data.
I shall...
Find and/or replace is a powerful feature that allows you to search for a text string within your data set. It will show you all of the times that Excel can see the text string in your document, allowing you to be taken to the next word by clicking the 'next' button. If...
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...
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...
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...
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...