Examples of hyperlinks in Google Sheets cells

I’ll start off by saying this is a very geeky post and if you’ve landed here because you are struggling with extracting hyperlinks in Google Sheets then you might prefer to jump straight to Alexander Ivanov’s Extract URL’s Add-on or alternatively the Info Inspired post Extract URLs in Google Sheets Without Script. The problem: hyperlinks in Google Sheets can be in three different formats…

VLOOKUP in action

At the Association for Learning Technology (ALT) hosting large events is a regular activity and over the years we have developed bespoke workflows largely based in Google Sheets. In this post I’m going to share some of the tips we use for scheduling our events including drafting/publishing an event programme and how to keep in touch with your presenters.

This is a cross-post from OpenScot.net on 28 February 2020. Less than a month on and OER20 has been impacted by the global situation and has had to move online. A number of the face-to-face sessions will no longer be run but a number will be and there is now free registration available for the reduced online programme.

Moving parts

Welcome to this month’s post (cross-posted here) in which we, that is Maren Deepwell (@marendeepwell) and Martin Hawksey (@mhawksey), openly share our approach to leading a virtual team. If this […]