Here’s a small selection of videos, resources, guides and tutorials, to help you on your way. It’s a work in progress – this page will be be added to and updated over the next few months. I hope you like them.

Many thanks for your patience!

I want to see resources for – Microsoft Word, Google Docs, Libre Writer, Microsoft Excel, Google Sheets, Libre Calc, Canva, GIMP, Microsoft PowerPoint, Google Workspace, Paint.net, Mailchimp.


Microsoft Word


Google Docs


Libre Writer


Microsoft Excel

Data Validation


Google Sheets

Text Functions In Sheets

UPPER, lower and Proper

Concatenate

Split

Basic Functions In Sheets

Average Function

Min & Max Functions

SUM

More Functions in Sheets

IF Function

COUNTIF

SUMIF

VLOOKUP & HLOOKUP

Useful Tips

Introduction to Formulas

Data Validation

Data Tidying in Sheets

Adding Checkboxes / tick boxes

Sorting Data

Filtering Data


Libre Calc


Canva

JCH Canva Keyboard Shortcuts
Canva Keyboard Shortcuts

Canva Keyboard Shortcuts for Presentations

Download Canva for Windows

Canva Keyboard Shortcuts for working with Shapes

Canva Keyboard Shortcuts for working with Text

Quick Reference Guide to Creating a Brand Kit in Canva.

GIMP


Microsoft PowerPoint


GSuite


Paint.Net


MailChimp