Data – How much is too much? Now if you ask me, there is no such thing as too much data – but that is if you ask me. Ask anyone else and you’ll probably get a different answer, it is afterall, one of the things that makes plane spotting so specific...
Data Filter or Find – your choice. We have seen that there are a couple of inbuilt functions in Excel that are really handy. We have seen the find function and the filter function, when to use which – is one better than the other? It should be noted that...
Freezing Panes Now it is possible to freeze panes, jolly handy it is too. If you are not familiar with the function, then a good way to think of it is like this. You pin rows and columns, forcing them to be static and not move. But everything below the row and to the...
On our way. Well, as you will be able to see from the image above – the basic spread sheet that Malcolm wanted is built. To save a bit of time I’ve cheated and populated it with a copy of the United States Civil Aircraft Registry, it saves me time in two...
Begining the process. So moving forward with these posts, we come to the actual use case for a spread sheet like Excel. To get started we need two basic things, we need to know what we are going to record and how we would like to view what we have recorded. For these...
