Data literacy · Digital research and scholarship · Excel · Timesavers · Working with Data

#350 Use SumIF in Excel to add conditions to your additions!

As we’re seen in previous posts on Excel, Excel is full of nifty little tricks to help make our lives much easier. In this post we take a look at the SumIF function. This function enables you to set conditions on what you want to add together. These conditions can come from another cell, for… Continue reading #350 Use SumIF in Excel to add conditions to your additions!

Data literacy · Excel · Working with Data

#322 Use this formula to count filtered data in Excel

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

Data literacy · Digital research and scholarship · Excel · Working with Data

#318 Excel formulas behaving weirdly? Try a fixed cell reference

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

Data literacy · Excel · Information literacy · Microsoft Office · Working with Data

#268 Excel wildcard search

In Excel we can find parts of things. So rather than looking for a chuck of text line “Jones” or “Johnson”, we can find both using wildcards. Wildcards are characters that tell Excel how to search. The asterisk (*) finds any number of characters, while the question mark (?) finds a single character. If you want to… Continue reading #268 Excel wildcard search

Digital research and scholarship · Excel · Information literacy · Working with Data

#250 Split your text into Columns in Excel

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

Data literacy · Excel · ICT proficiency · Timesavers · Top tip · Working with Data

#195 Changing direction of the Enter key 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