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

Digital research and scholarship · Distance Learning · Information literacy · Searching Skills · Social Media · Top tip · Twitter

#293 Using Twitter’s Advanced Search

Did you know that Twitter has an Advanced Search function? It’s really simple to use and can be a really powerful search tool to aide your digital research and scholarship. You can find out more about the different types of search in this Twitter article. In the meantime, here is a 60 second introduction on where… Continue reading #293 Using Twitter’s Advanced Search

Base · Copyright · Core · Curation · Digital research and scholarship · Distance Learning · Searching Skills

#226 MorethanGoogle: Core and Base open-access research search engines

Thank you to JISC for introducing the #1minuteCPDers to these very useful search engines. Core and Base are both search engines that look exclusively at open access research, making them extremely useful. They are quite similar, but do have slightly different functions, which I cover in this brief introduction: Featured Image: “Research” by Leo Hidalgo  licenced… Continue reading #226 MorethanGoogle: Core and Base open-access research search engines

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

#168 If this then what? Using the IF Function 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

Communication / Collaboration · Curation · Digital collaboration · Digital research and scholarship · Distance Learning · OneNote

#154 Introducing OneNote, your online notebook

If you are a Window’s user, you’ll find OneNote is a handy tool for keeping all your research notes, meeting minutes and to do lists handy. OneNote is like a big box folder, which contains file dividers and pages within it, but unlike a box folder, it’s really easy to share and collaborate on the… Continue reading #154 Introducing OneNote, your online notebook

Curation · Digital research and scholarship · Distance Learning · Google · Searching Skills

#148 Google Scholar alerts keep you up to date with latest research

If you are interested in keeping up to date with research on your favourite topics, set up a Google Scholar alert to have all the latest research emailed to your inbox. This is really easy to set up, all you need is a (free) Google account. Don’t want your Google Scholar alerts cluttering up your… Continue reading #148 Google Scholar alerts keep you up to date with latest research