For my Excel friends, try out our new captions in 20 languages.
For YouTube Creators, here is how we are creating captions. How does this compare to your method?
We find that the Google Translate API works far better than the YouTube Automatic Subtitles. Both processes are owned by Google. Why doesn't YouTube use the better algorithm from Google?
For YouTube Creators, here is how we are creating captions. How does this compare to your method?
We find that the Google Translate API works far better than the YouTube Automatic Subtitles. Both processes are owned by Google. Why doesn't YouTube use the better algorithm from Google?
Transcript of the video:
Learn Excel From MrExcel podcast episode. It's a bonus episode.
Turn on the closed captions for my videos. Hey, welcome back to the MrExcel netcast.
I am Bill Jelen.
An invitation to you today if you're watching my videos.
Check out this CC button down here in the lower right hand corner.
Try and watch a couple of the videos with the CC turned on. CC stands for Closed Captions. Why captions?
Well most people think that captions are there for people with a hearing disability. But it's also for people with dyslexia.
Or the largest group are people who watch video with the sound off at work. That's huge.
I keep the captions on because it helps me to reinforce what I'm hearing by reading along.
It's also great for people who are speaking English as a second language.
Lots of times you can read before you can speak or understand spoken English.
So, it helps having the captions there.
I've made a commitment.
I now have 100 percent of our public videos - 2,000 videos - have curated captions in English. Not the automatic captions.
But real captions.
And a growing number of our videos have captions now in 20 languages. So look, if you're not a YouTube Creator.
Thanks for watching. Please subscribe down below.
But for those of you who are YouTube creators or just want to see some behind-the-scenes.
Let's talk about how we get captions in YouTube.
I would love to hear how other creators are doing this. We've tried a number of things over the years.
Hire a service to create the captions. That's great and it is cheap.
It's a dollar per minute. But it takes two days.
And frankly I'm not planning far enough ahead to do that.
Camtasia offers a Windows Speech to Text feature. It is horrible.
You can use the automatic transcript tool in Microsoft Stream. It is fast.
It's really good. I've used that a lot.
But, they chop things up into really short sentences of three four or five words.
There's a new dictation tool in Word from Microsoft 365.
One of the new MVPs, Nabil Mourad says he uses it all the time. I have not tried it yet.
You could use the YouTube automatic captions.
Or automatic captions and then edit them.
Or you can use the YouTube automatic captions but then edit them and add some magic.
So let's take a look at our process. So here we are in YouTube studio.
I just uploaded this video about 10 minutes ago. This is the waiting game.
So I go to subtitles here.
They say for the English video language they offer to allow me to Add captions.
If I was going to Add then I would have to type the entire text of the video. So we just wait.
We refresh and we refresh. Sometimes it's 10 minutes.
Yesterday it was eight hours. It's interesting.
Down here at the bottom, they show me that 64 percent of the audience speaks English. 15% Hindi.
Arabic, Filipino, German, Dutch.
This comes in handy later when we translate the finished subtitles.
Alright. So it's about three hours later.
We now have automatic subtitles. But let's take a look at those. [ Video replay ] Alright, so, a couple of things, Rob.
What I Tweeted back to you is my second solution.
The first solution is interesting. This should just work.
So here I have a table and there are formulas out here. We'll do control in the grave accent key [ End video replay ].
[ Bill ] Well, the automatic captions are a good starting point. But I choose to Edit on Classic Studio.
Then click Edit. This clip is 15 times normal speed.
This is how I clean up the captions.
It takes about six minutes of editing time per minute of video.
All right. That was about half an hour. Click Save Changes.
Click Return to YouTube studio.
We'll see is there's now two sets of subtitles.
The one I just created and then the Automatic. We have to get rid of the Automatic.
Okay, so now we are down to just one. But let's see how it looks.
[ Video replay ] in a table and one of the columns has a formula in it.
Is there a way to automatically include that formula when I insert a new row?
And Rob, thanks for tagging me @MrExcel.
Alright, so a couple of things, Rob.
What I tweeted back to you is my second solution. The first solution. It's interesting. This should just work.
So here I have a table and there are formulas out here.
We'll do Ctrl and the grave accent key [ End video replay ]. [ Bill ] Okay.
The words are better. But the phrasing is wrong.
You will have half a sentence and then another sentence.
And I find that if there's a long pause between when I speak.
They will try and make sure that the last word before that long pause and the first word after that pause are all in the same caption. That creates a really frustrating reading experience.
So at that point even though the captions have been edited by me, We are not done. I sent the video link off to Suat.
Suat is our database guy. He adds magic.
The magic is a combination of math Google APIs, the YouTube Studio panel, and 1200+ lines of PHP code that Suat wrote.
The result is now we have those captions in 22 languages including English.
But it's not just the translation.
Even the English captions have been reformatted so that complete sentences appear on the screen at one time.
It seems to be a huge improvement over the automatic subtitles that you get from YouTube.
[ Video Replay ] It's been Tweeted by Rob.
He says if I am using a table and one of the columns has a formula in it.
Is there a way to automatically include that formula when I insert a new row?
Rob, thanks for tagging @MrExcel. All right.
So a couple of things, Rob.
What I tweeted back to you is my second solution. The first solution, it's interesting this should just work.
So here I have a table. There are formulas out here. We'll do Ctrl and the grave accent key [ End video replay ].
[ Bill ] You know, I just look at those windows back there. It's late. It's dark outside. I started this video at 7 AM.
Because of the caption process it ends up taking the whole day. Waiting for the various steps.
However we can get really good captions turned around in 24 hours.
And while I am recording this on Monday, the video will be ready to go live Tuesday morning.
Now there was a day where I would record a video and one hour later it was it was live. But it had no captions.
And I think it's worth it to have the captions. So there you go.
That's the method we use. Hopefully you found this interesting.
For the Creators who are doing something else let me know down in the YouTube comments.
Leave me a note let me know if you have something better, faster, easier, cooler.
I would love to learn what you're doing. I want to thank everyone for stopping by.
We'll see you next time for another netcast from MrExcel.
[ ♫ ] When you're down and out, in spreadsheet hell.
Get your fix on Twitter at MrExcel[ ♫ ]
Turn on the closed captions for my videos. Hey, welcome back to the MrExcel netcast.
I am Bill Jelen.
An invitation to you today if you're watching my videos.
Check out this CC button down here in the lower right hand corner.
Try and watch a couple of the videos with the CC turned on. CC stands for Closed Captions. Why captions?
Well most people think that captions are there for people with a hearing disability. But it's also for people with dyslexia.
Or the largest group are people who watch video with the sound off at work. That's huge.
I keep the captions on because it helps me to reinforce what I'm hearing by reading along.
It's also great for people who are speaking English as a second language.
Lots of times you can read before you can speak or understand spoken English.
So, it helps having the captions there.
I've made a commitment.
I now have 100 percent of our public videos - 2,000 videos - have curated captions in English. Not the automatic captions.
But real captions.
And a growing number of our videos have captions now in 20 languages. So look, if you're not a YouTube Creator.
Thanks for watching. Please subscribe down below.
But for those of you who are YouTube creators or just want to see some behind-the-scenes.
Let's talk about how we get captions in YouTube.
I would love to hear how other creators are doing this. We've tried a number of things over the years.
Hire a service to create the captions. That's great and it is cheap.
It's a dollar per minute. But it takes two days.
And frankly I'm not planning far enough ahead to do that.
Camtasia offers a Windows Speech to Text feature. It is horrible.
You can use the automatic transcript tool in Microsoft Stream. It is fast.
It's really good. I've used that a lot.
But, they chop things up into really short sentences of three four or five words.
There's a new dictation tool in Word from Microsoft 365.
One of the new MVPs, Nabil Mourad says he uses it all the time. I have not tried it yet.
You could use the YouTube automatic captions.
Or automatic captions and then edit them.
Or you can use the YouTube automatic captions but then edit them and add some magic.
So let's take a look at our process. So here we are in YouTube studio.
I just uploaded this video about 10 minutes ago. This is the waiting game.
So I go to subtitles here.
They say for the English video language they offer to allow me to Add captions.
If I was going to Add then I would have to type the entire text of the video. So we just wait.
We refresh and we refresh. Sometimes it's 10 minutes.
Yesterday it was eight hours. It's interesting.
Down here at the bottom, they show me that 64 percent of the audience speaks English. 15% Hindi.
Arabic, Filipino, German, Dutch.
This comes in handy later when we translate the finished subtitles.
Alright. So it's about three hours later.
We now have automatic subtitles. But let's take a look at those. [ Video replay ] Alright, so, a couple of things, Rob.
What I Tweeted back to you is my second solution.
The first solution is interesting. This should just work.
So here I have a table and there are formulas out here. We'll do control in the grave accent key [ End video replay ].
[ Bill ] Well, the automatic captions are a good starting point. But I choose to Edit on Classic Studio.
Then click Edit. This clip is 15 times normal speed.
This is how I clean up the captions.
It takes about six minutes of editing time per minute of video.
All right. That was about half an hour. Click Save Changes.
Click Return to YouTube studio.
We'll see is there's now two sets of subtitles.
The one I just created and then the Automatic. We have to get rid of the Automatic.
Okay, so now we are down to just one. But let's see how it looks.
[ Video replay ] in a table and one of the columns has a formula in it.
Is there a way to automatically include that formula when I insert a new row?
And Rob, thanks for tagging me @MrExcel.
Alright, so a couple of things, Rob.
What I tweeted back to you is my second solution. The first solution. It's interesting. This should just work.
So here I have a table and there are formulas out here.
We'll do Ctrl and the grave accent key [ End video replay ]. [ Bill ] Okay.
The words are better. But the phrasing is wrong.
You will have half a sentence and then another sentence.
And I find that if there's a long pause between when I speak.
They will try and make sure that the last word before that long pause and the first word after that pause are all in the same caption. That creates a really frustrating reading experience.
So at that point even though the captions have been edited by me, We are not done. I sent the video link off to Suat.
Suat is our database guy. He adds magic.
The magic is a combination of math Google APIs, the YouTube Studio panel, and 1200+ lines of PHP code that Suat wrote.
The result is now we have those captions in 22 languages including English.
But it's not just the translation.
Even the English captions have been reformatted so that complete sentences appear on the screen at one time.
It seems to be a huge improvement over the automatic subtitles that you get from YouTube.
[ Video Replay ] It's been Tweeted by Rob.
He says if I am using a table and one of the columns has a formula in it.
Is there a way to automatically include that formula when I insert a new row?
Rob, thanks for tagging @MrExcel. All right.
So a couple of things, Rob.
What I tweeted back to you is my second solution. The first solution, it's interesting this should just work.
So here I have a table. There are formulas out here. We'll do Ctrl and the grave accent key [ End video replay ].
[ Bill ] You know, I just look at those windows back there. It's late. It's dark outside. I started this video at 7 AM.
Because of the caption process it ends up taking the whole day. Waiting for the various steps.
However we can get really good captions turned around in 24 hours.
And while I am recording this on Monday, the video will be ready to go live Tuesday morning.
Now there was a day where I would record a video and one hour later it was it was live. But it had no captions.
And I think it's worth it to have the captions. So there you go.
That's the method we use. Hopefully you found this interesting.
For the Creators who are doing something else let me know down in the YouTube comments.
Leave me a note let me know if you have something better, faster, easier, cooler.
I would love to learn what you're doing. I want to thank everyone for stopping by.
We'll see you next time for another netcast from MrExcel.
[ ♫ ] When you're down and out, in spreadsheet hell.
Get your fix on Twitter at MrExcel[ ♫ ]
