Excel 2007 offers an oddity - an icon to do translations between 20 different languages. Episode 438 shows you how.
This blog is the video netcast companion to the upcoming book, Excel 2007 Miracles Made Easy. Download a new two minute video every Tuesday and Thursday to learn one of the tips from the book!
This blog is the video netcast companion to the upcoming book, Excel 2007 Miracles Made Easy. Download a new two minute video every Tuesday and Thursday to learn one of the tips from the book!
Transcript of the video:
Hey, it's Tuesday, February 6th 2007, welcome back to the MrExcel netcast, I'm Bill Jelen.
Well, in here in Ohio we've had the coldest snap of weather we've had in a long, long time, it's currently about 5 degrees below zero, schools are closed for the second day in a row, so here's a quick little tip for Excel 2007.
One of the strange new features that they've added, is something that really we've had on the Internet at Babel Fish for quite some time.
This is Excel 2007 and I pasted some data here from this morning's headlines in a Paris newspaper.
If we go back to the Review tab of the ribbon, there's a new option there that we've never had in Excel before, called Translate.
And the way the Translate works is that you select one cell and hit the Translate key, and we get the old task pane over on the right hand side.
Now task panes were introduced in Excel 2003 and Microsoft said that they wanted to try and get away from them, but they're still here in the Research pane and basically this is the Translation option.
We can translate from a whole series of languages, in this case I'll choose French and so we want to translate to English, and it gives us a very rough translation of the first cell we've selected.
Now of course, for me to translate this entire paragraph, I'd have to go through and use Translate again and again, and again, one for each cell.
It's using a service called WorldLingo, which must be a competitor to Babel Fish, it's kind of an oddity, it gets a big huge icon there on the Review ribbon.
It's one of those things, where you say: okay, this is kind of cool, but they didn't do a fantastic job of it.
I bet that it'll be better in the next version of Excel.
So, if you have Excel 2007 and someone send you a spreadsheet with some text in a foreign language, you can use the new Translate icon on Review ribbon to get a rough translation.
Hey, thanks for stopping by, I will see you tomorrow, hopefully it will be warmer, for another netcast from MrExcel.
Well, in here in Ohio we've had the coldest snap of weather we've had in a long, long time, it's currently about 5 degrees below zero, schools are closed for the second day in a row, so here's a quick little tip for Excel 2007.
One of the strange new features that they've added, is something that really we've had on the Internet at Babel Fish for quite some time.
This is Excel 2007 and I pasted some data here from this morning's headlines in a Paris newspaper.
If we go back to the Review tab of the ribbon, there's a new option there that we've never had in Excel before, called Translate.
And the way the Translate works is that you select one cell and hit the Translate key, and we get the old task pane over on the right hand side.
Now task panes were introduced in Excel 2003 and Microsoft said that they wanted to try and get away from them, but they're still here in the Research pane and basically this is the Translation option.
We can translate from a whole series of languages, in this case I'll choose French and so we want to translate to English, and it gives us a very rough translation of the first cell we've selected.
Now of course, for me to translate this entire paragraph, I'd have to go through and use Translate again and again, and again, one for each cell.
It's using a service called WorldLingo, which must be a competitor to Babel Fish, it's kind of an oddity, it gets a big huge icon there on the Review ribbon.
It's one of those things, where you say: okay, this is kind of cool, but they didn't do a fantastic job of it.
I bet that it'll be better in the next version of Excel.
So, if you have Excel 2007 and someone send you a spreadsheet with some text in a foreign language, you can use the new Translate icon on Review ribbon to get a rough translation.
Hey, thanks for stopping by, I will see you tomorrow, hopefully it will be warmer, for another netcast from MrExcel.
