Time
6 hours 3 minutes
Difficulty
Beginner
CEU/CPE
6

Video Transcription

00:00
in this lesson, I will try to explain to how to do proofing and translation Excel. So,
00:07
um,
00:08
let's go directly to excel. And we're in the same file where Stop before. I'm not going to change any of this. I'm just going to type something
00:18
like, um,
00:21
I'm going to do some, uh,
00:23
sorry.
00:29
Some, uh,
00:31
something wrong.
00:34
Okay.
00:35
And, uh,
00:38
I'm going to type it again. Wrong
00:42
on dhe again. I'm going to do a drunk.
00:47
So remember when I spoke to you about the elements off
00:51
Excel in to freeze
00:53
here. We have tabs
00:56
and we have home time in which your
00:58
basically most of the time
01:00
and you have insert page layout formulas data, But we're going to talk about review tab at this point.
01:07
So we have spelling here
01:10
and just click on spelling. It is the usual if seven
01:15
and you get the standard office spelling checker,
01:21
which will tell you that you typed Ah,
01:23
that I typed type with two wise, so I can do change,
01:29
and it will go on and on and on and on.
01:33
Now, this is very interesting.
01:36
You can in excel, do something like this so we can copy these cells twice
01:42
and then we conceal it. Just thes three cells
01:47
and do spelling,
01:49
and it will correct type than again to type, then again to type and it will stop. So if you sell excels and their spell checking, it will do it just for those cells. If you are familiar with using spell Chickering, Microsoft Word,
02:06
you will remember that whenever you finish
02:09
spell checking the selection and you'll offer you to go to the rest of the document here. It won't, because in excel, you have ah, quite a lot of data types which cannot be subjected to spell checking like numbers or percentages or dates, whatever.
02:29
So it won't push you to go any further. If you select, it sells and want to do
02:36
some
02:38
spell checking on it, it will stay within the selected range.
02:43
Also, you can do the same thing with Zahra's, So if you
02:47
click on it you see here
02:50
it will
02:53
give you the classical excel,
02:59
his hours
03:00
window here
03:01
So you can do that if you need to find something else. So, for example, you want to change into it front? Yeah,
03:08
or something like this. So we won't go any further. It is just the basic
03:15
functionality of office.
03:17
It didn't also give you the translation. So you can hear Click on cell type you conflict, translate.
03:25
And what happens in the cases that you need
03:30
Internet connection, because the translation will use the online service.
03:36
And then you get here in the right. Eso uh,
03:40
you wanted from English to whatever, for example,
03:45
French. Yeah.
03:46
And, uh,
03:50
you just look here
03:53
and it gives you
03:54
some, uh,
03:57
options.
03:59
And it gives you the references where you want to do
04:04
the translation from.
04:08
So you can do that and you can do the translation
04:14
from off type two. But there were French, or you can choose German,
04:19
and then you get
04:23
all the possible translations. So
04:26
Excel is a part off office program suit,
04:30
and you can use old common tools
04:34
for office in excel as well,
04:38
and descends its lesson

Up Next

Intro to Excel

This basic Excel training course will give you knowledge of Excel and the ability to use this software to do elementary calculations, file manipulation, data manipulation, to create charts, pivot tables and templates.

Instructed By

Instructor Profile Image
Milan Cetic
IT Security Consultant
Instructor