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/

Data literacy · Digital communication · ICT proficiency · Word

#469 Merge & split table cells

Another “it’s only easy if you know it” tip for today. An academic asked me today how to do this and so it seems likely that this is something other people are also unsure how to merge and split cells in a table. This can really make your table much easier to read, and is… Continue reading #469 Merge & split table cells

Communication / Collaboration · Data literacy · ICT proficiency · Information literacy · Outlook · Timesavers · Top tip

#464 Create a Calendar Group in Outlook

Creating a calendar group in Outlook is a top time saving tip that I recently discovered through talking to a colleague. If you share a lot of calendars, you can organise them by group instead of having them listed alphabetically. This is great if you have a massive long list of shared calendars, but even… Continue reading #464 Create a Calendar Group in Outlook

Assessment · Communication / Collaboration · Data literacy · Digital collaboration · Digital communication · Digital creation · Digital identity management · Digital innovation · Digital participation · E-portfolios · Information literacy · Media literacy · Microsoft Office

#439 Export your Sway

Following on from our previous Sway posts (see Sway), in today’s video we look at exporting Sway to PDF or Word documents. This, in conjunction for being able to create templates, makes Sway an excellent option for people looking for a portfolio or online CV tool for students. One of the most common questions we… Continue reading #439 Export your Sway