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!

Author: Terry Madeley

I work with student data and enjoy reading about art and design, data, education and technology.