Content transferred.
Search results
Displaying hidden formattingWord has many formatting symbols which are not immediately obvious and are hidden from view by default.
The following formatting options have no visibility unless the ¶ button is selected:Section breaks, Page breaks, Soft and Hard carriage...
The following formatting options have no visibility unless the ¶ button is selected:
=Unique function
=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...
Excel - Find and Replace
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...
Conditional Formatting
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...
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...
Charts and Graphs...
Create a chart
Select the data for which you want to create a chart.
Adding Chart Elements
When creating charts/graphs in Excel you may find that some labels are not added by default and must be added manually or are in an unsuitable place. Excel also allows for modification of these labels, as well as their placement. In this example i'm going to amend a pie...
Vlookup & HLookup
Excel can use a function to lookup and retrieve data from a specific column or row within a table. Vlookup works to return back a column of data and Hlookup works to return a row of data instead, therefore the V stands for vertical lookup and the H, Horizontal lookup.
...