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 · Digital communication · Timesavers

#312 Todoist [3/3]: Sorting tasks visually

Need a quick visual sort? If you have tonnes of tasks in your Todoist schedule and need to sort them, this can be done quickly and visually using the free feature “Priorities” or if you are a super fan you might invest in the premium feature of labels. This video demonstrates assigning priorities to visually… Continue reading #312 Todoist [3/3]: Sorting tasks visually

Copyright · Data literacy · Digital research and scholarship · Distance Learning · Moodle · Moodle use, organisation and content · Searching Skills

#308 Need to share a journal article with your students? Use a stable link!

As always, it’s important that we consider copyright when we are sharing resources with our students, and this includes journal articles. If you upload a PDF version of a journal article into your Moodle area or share by email, it is highly likely that you are breaking copyright laws in doing so. Luckily for us… Continue reading #308 Need to share a journal article with your students? Use a stable link!

Classroom technologies · Communication / Collaboration · Data literacy · Distance Learning · Information, data and media literacy (critical use) · JISC: 6 elements of digital capability · MMU: ISS Themes · Timesavers

#287 JotForm [1/3]: Creating online forms quickly and easily

JotForm is a web2 tool that allows you to quickly create forms and surveys easily using either one of the 8,000 existing templates or by creating your own using the drag and drop user interface. This first video gives you an overview and other videos in the series will take you through creating a form… Continue reading #287 JotForm [1/3]: Creating online forms quickly and easily

Data literacy · Digital learning and personal/ professional development (learning) · Distance Learning · Social Media · Timesavers · Top tip · YouTube

#269 Filtering your YouTube search results

Did you know that you can filter your YouTube video search results? I didn’t until the other day! It is an excellent method to make your search more relevant and targeted – search by duration, date uploaded, views, ratings etc. Here is how you use the filter function… Feature image: “filtered” by timlewisnm is licenced under CC BY-SA… Continue reading #269 Filtering your YouTube search results