Excel tips and tricks

Excel tips and tricks

Often with these kinds of training videos it’s the ‘ooh I’d forgotten you could do that‘ moments that are the most useful. The overall topic of the tutorial itself might not be what you’re after (do you really need to know how to make a Christmas Tree in Excel?), but just simple reminders about things like F9 or index match are just the ticket.

Here are some of my recent favourites:

From Exceljet‘s channel, How to fill in missing data with a simple formula

From Leila Gharani‘s channel, Excel index match advanced: lookup multiple criteria in rows or columns

From the My Online Training Hub channel, Labeling events in Excel charts

From the Excel Is Fun channel, Excel magic trick 1474: Excel twinkling Christmas Tree with star & formulas as presents!

Useful invigilator training materials

​It’s coming up to that time of year again. Time flies when you’re having fun, right?

The Exams Office: Invigilation
Exams officers are required to recruit, train and deploy invigilators. An effective team of invigilators can not only ensure that exams run smoothly, but they can also undertake a range of additional tasks which could help ease the burden placed upon exams officers during an exams series. The Exams Office has produced a series of support resources which will help our members develop the best possible team of invigilators in their centre.