How to trim a YouTube video and embed it into WordPress

Regular followers of my blog, will know that I have previously blogged about different ways of trimming or cropping YouTube videos to use in different situations, e.g:

Trimming videos can be really valuable, as often (in education) there may be a key message or element in a video, that we want to draw attention to, without having to show the entire video, so carefully selecting sections of the video can drastically improve the impact of using that video as a resource.

Up until recently, something that I couldn’t do was to get this to work in WordPress, I could only embed the whole video – however today I found out that I can do trim a video, if you follow these instructions exactly:

  1. Locate the video you want on YouTube.
  2. Under the video choose ‘Share’ and then ‘Embed’.
  3. Underneath the preview, there will be some tick boxes – make sure the one called ‘Show suggested videos when the video finishes‘ is unticked (this is really important).
  4. Copy the embed code that is above the preview.
  5. Go into your WordPress post, and into the HTML editor.
  6. Paste the copied embed code in the correct position.
  7. Preview your post.
  8. Go back to edit your post, and again into the HTML editor.
  9. The code that you pasted in, will have been changed, towards the end of it, locate the text rel=0.
  10. Immediately after rel=0 add &start=xxx&end=yyy (where xxx is the number of seconds you want the video to start at and yyy is the number of seconds you want the video to end at).
  11. Preview your post – if it works then publish.

So – if I have a video that I want to start at 2:35 and end at 3:15 – I convert these into seconds (2:35 = 155, 3:15 = 195) – and the end of the code will change from:

….?rel=0]

to

….?rel=0&start=155&end=195]

Below is an example of one of my YouTube videos, trimmed to start at 155 seconds and end at 195 seconds.

Advertisements

How to display the sheet name in a cell in an Excel spreadsheet

I use Excel a lot, not just for crunching numbers, but for creating teaching resources, lesson planning, managing my accounts and invoices and various other uses. One feature that I often use, is the ability to have the sheet name appearing inside a cell in the spreadsheet – so for example with my invoices – I rename the sheet name with the invoice number, this then updates the invoice within the sheet.

To do this I use the following formula below.

This may seem a complex formula, and it doesn’t matter if you don’t fully understand it (I don’t), you just need to copy and paste this into a cell in the spreadsheet, and the sheet name will appear. If you change the sheet name, the cell will change accordingly.

The only caveat is, that the workbook has to have been saved at some point for this to work – so if you do this with a new workbook, it won’t work until it has been saved.

This technique is unique to Microsoft Excel, it doesn’t work with other spreadsheet tools such as Open office, Google sheets or Apple’s Numbers.