Trying to type out a formula that relates to a different book can be a nightmare – how do you get the file name, the exclamation mark, the apostrophes, etc, all in the right place? Well, why not let Excel do the hard work for you?
Trying to type out a formula that relates to a different sheet can be a nightmare – how do you get the exclamation mark, the apostrophes, etc, all in the right place? Well, why not let Excel do the hard work for you?
This tutorial shows you how to apply data validation using a list on a different sheet. It assumes you already know how to use data validation.
This video tutorial shows you how to categorise a list of data into groups defined by a value of ranges. The example categorises people into age bands such as 17-34,35-44, 45-50, etc.
When you first start using Excel, it seems like a good idea to break your data up as much as possible so that it’s easy to find/read. It’s not uncommon to have lots of sheets containing similar data for different departments / people / products / stores / months etc. However, as you start to [...]
There are a few things that many people struggle with. One of them is using the mouse to select a large range of data that goes off the visible screen. By combining two simple keyboard shortcuts, you can select a large range of data with two keypresses.
I try to avoid typing cell references wherever possible, because I know I’ll get them wrong. Much better to let Excel type your cell references for you. It’s quite straightforward.