This is a simple tutorial on how to create and display a bar chart in a cell; a technique that works very well when creating management reports.
Steps:
1. In column A enter the values you want to display i.e. in cell A1 enter the value 10, in cell A2 20 etc.
2. In column B1 enter the [...]
Excel has an abundance of string functions that can be used to manipulate data. In this article we will look at how to convert somebody’s full name into their initial and surname. So for example Mark Doppler becomes M Doppler.
Lets say that we have a series of names like so:
It is possible to do this [...]
An introduction to Dynamic Ranges
The VLOOKUP function is often used to find information that is stored within tables in Excel. So for example if we have a list of people’s names and ages:
And then we can in a nearby cell use the function VLOOKUP to determine Paul’s age:
So far this is a fairly standard. But [...]
Tom | 
08 23rd, 2008| 
