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

#ios · android · Apple · Digital collaboration · JISC: 6 elements of digital capability · Mobile · OS X · Top tip · Windows

#495 WhatsApp on a desktop [4/4]

Sometimes bigger is better! You can use Whatsapp on a desktop/laptop computer. You need to make sure that your phone is in close proximity. This screencast will take you through the process of getting whatsapp on your desktop or laptop computer. Image is CC0 and is available from Pixabay

OneNote · Timesavers · Top tip

#492 OneNote: Quickly create multiple pages from a list

In #154 we introduced you to OneNote, a great tool for keeping your notes organised. In this post, we show you how you can create multiple pages at once from a list, saving you some of your very valuable time. Featured image: CCO from Pixabay https://pixabay.com/en/alarm-clock-time-of-good-morning-2116007/ 

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  

#ios · android · Apple · Browsers · Digital communication · iPad · JISC: 6 elements of digital capability · Mobile · OS X · Windows

#485 WhatsApp: Creating a Group Chat [2/4]

In this next instalment where we look at WhatsApp we look at how to create a group chat. Group chats are great for social and work-related purposes. For the previous post about introduction to WhatsApp click here Image is CC0 and is available from Pixabay

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

#ios · android · Apple · Browsers · Creative Commons · Digital creation, innovation and scholarship (creative production) · Images · JISC: 6 elements of digital capability · Mobile · Windows

#465 Gurushots: The Photography Game – Swaps, Autofills and Keys [3/3]

In this final instalment of three posts about GuruShots (catch the first one by clicking here and the second one here) we introduce you to Swaps, Autofills and keys. Swaps allows you to replace an existing picture (that might only receive a few votes) with another picture. Autofills work in the same way as voting, except… Continue reading #465 Gurushots: The Photography Game – Swaps, Autofills and Keys [3/3]