Step-by-step guides to making things happen
Analysing Event Feedback with Forms & Sheets
Dynamically and professionally handle your event feedback, gathered with a google form, analysed with sheets.
Monitoring Data with Google Sheets
Easily monitor data collected weekly, with formatting to highlight missing & notable values.
Using Grades in Google Sheets
Using grades in a spreadsheet doesn’t have be difficult, here is how to do it elegantly.
Sparklines with Google Sheets
Simple, quick and useful. Sparklines let you visualise your spreadsheet data as small graphs, inside a single cell.
Markbooks with Google Sheets
A start of term chore, but also an opportunity to brush up on your spreadsheet & data-handling skills to make the rest of the year easier and more productive!
Columns by header name
Columns can move, and when using complex formulas (such as importrange), this can lead to problems. Here is how to address a column by its header value, rather than it’s position. Read More …
Mac Log Off Clearing Script
How to use a logoff script to clear authenticated web sessions on a Mac Read More …
Proxies and your Chromebook
If you are using a Chromebook in a school environment, you may need to make a few small adjustments to your network settings to successfully connect via a proxy server. Read More …
Creating expanded rows from data
Like a database query join, how to denormalise tabular data to create expanded rows, ideal for mail-merges and data imports. Read More …
Finding Duplicates
How to identify duplicate values or rows in Google Sheets. Read More …
Find from a list
How to use the FIND function with an array of values to search for individual characters or words. Read More …
Aggregating data
How to aggregate data from different rows and columns for further processing. Read More …
Identifying dissimilar duplicates
How to identify duplicate rows in a sheet that have dissimilar values, such as multiple grades for the same student in the same subject from different teachers. Read More …
Making column headers from values
How to transpose values to become headers, adding extra blank columns in between the values as well. Read More …
Query using dates
Use the QUERY function to return results before, on or after a certain or relative, date. Read More …