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

#496 Add up more than 24 hours in Excel

This top tip helped me recently when adding up the duration of a number of videos for a project. The duration of the videos were in the 24 hour clock format and when I added the duration together the result was not as I expected. The answer was to change the format of the cells… Continue reading #496 Add up more than 24 hours in Excel

Communication / Collaboration · Data literacy · Information, data and media literacy (critical use) · Microsoft Office · MMU: ISS Themes · Timesavers · Working with Data

#488 Branched Microsoft Forms

Microsoft forms allows you to create branched forms where you can direct respondents depending on there responses. This allows you to present questions based on the input of previous questions creating more sophisticated interactions. This simple example shows you how you can get started. Photo by Zach Reiner on Unsplash  

Curation · Data literacy · Digital research and scholarship · Information literacy · Working with Data · Writing

#476 Mendeley: quickly add citations to your work [2/2]

In #472 we introduced to Mendeley, a reference management tool. In this video, we will show you how to add in-text citations and a reference list to your work. Featured image: CCO from Pixabay https://pixabay.com/en/pencil-notes-chewed-paper-ball-1891732/

Curation · Data literacy · Digital research and scholarship · Information literacy · Working with Data · Writing

#472 Mendeley: store and organise your references [1/2]

Mendeley is a reference management tool that allows you to store and organise your sources. This video will show you some of the main features of the Mendeley desktop application before demonstrating how quick and easy it is to add and annotate a journal article. Featured image: CCO from Pixabay https://pixabay.com/en/books-door-entrance-culture-1655783/

Communication / Collaboration · Data literacy · Excel · Working with Data

#402 Muddled data in Excel? Sort it out!

If you are trying to move grades from one spreadsheet to another, or cross reference your data, then it can be a real pain if the data is not sorted in the same way. In this short video we cover how to sort your data alphabetically or by custom fields. Featured image: ” Sorting” by… Continue reading #402 Muddled data in Excel? Sort it out!

Digital collaboration · Digital communication · Digital creation · ICT proficiency · Images · Internet Explorer · Top tip · Working with Data

#401 Greenshot [1/3]: Free and open source tool for making screenshots on your PC or Mac

If you liked #1 Snip it! you are going to love Greenshot. Greenshot is like Snip it but has loads more features to create that perfect screenshot. Whether you are a PC or Mac user, Greenshot is completely free and open source. Some of the key features for Greenshot includes (taken from the Greenshot website): Quickly create… Continue reading #401 Greenshot [1/3]: Free and open source tool for making screenshots on your PC or Mac