We saw in an earlier post just how easy it is to filter data in Excel. Filtering is a great tool, but what if you also want to count your filtered data? This is where this handy formula comes into play… Featured Image: “Counting 2” by The Shopping Sherpa licenced under CC BY-NC-ND 2.0 Advertisements
A fixed cell reference allows you to use make use of the auto-fill feature in Excel, whilst ensuring any cell references you want to keep static, remain so. So if you ever find yourself frustrated that Excel isn’t completing your formulas as you’d like, this one is for you! Featured image: ” Red Cells”by Alias… Continue reading #318 Excel formulas behaving weirdly? Try a fixed cell reference
This Excel tip is particularly handy if you are trying to tidy up a list of email addresses copied from Outlook, or if you have imported in data from another source and need to split it into separate columns. For more hints and tips with Excel, check out our other #1minuteCPD videos. Featured image: “Split… Continue reading #250 Split your text into Columns in Excel
This is a very quick tip that solves an irritating problem. If you are entering data in Excel that goes from left to right, rather than top to bottom (or any other direction for that matter), then you’ll want to change the direction that the Enter key sends your data. By default Enter in Excel… Continue reading #195 Changing direction of the Enter key in Excel
The IF function in Excel is a really useful one to be aware of as you can use it to help you to quickly analyse your data. In this example, I use the IF function to get Excel to tell me if student grades are a pass or a fail. This is a very simple… Continue reading #168 If this then what? Using the IF Function in Excel
Sometimes the data we get in Excel is not quite in the format that we need it, for example you might have a column of first names and a column of second names but for your purposes you need their full name, for a mail merge for example. You might also want to combine some… Continue reading #166 Need to combine columns in Excel? No problem!