What are the Limitations of Excel?

Video Activity
Join over 3 million cybersecurity professionals advancing their career
Sign up with
or

Already have an account? Sign In »

Time
6 hours 3 minutes
Difficulty
Beginner
CEU/CPE
6
Video Transcription
00:00
Listen, I'm just going to mention some of the limitation to excel, so don't expect it to be a miracle, too.
00:08
So, um,
00:10
Excel can do almost anything in terms of calculation and data manipulation, but not everything. So if you're looking just the basic,
00:21
ah, functions and formulas in Excel
00:24
it is limited toe like extent.
00:28
But if you combine it with my crow's, then it becomes very powerful tool.
00:32
What Excel cannot do at the time is work like a softer, so you cannot have excel file that will do something. For example, open file on your hard drive, do something with it and save it in some other form and go out. So
00:50
you have to start excel. You have to open the file
00:55
excel file even one that is packed with very powerful macros that can do
01:02
a lot of things.
01:03
And then, ah, with the with this in mind, you can then ah ah, do something. But you have to have this to step thing. You have to open, excelled in, open the file and then
01:18
start.
01:19
What were you doing?
01:22
Also, excel cannot manipulate graphics and it cannot search the web. So it is not ultimate tool that can do everything. Of course, it can manipulate text that you have specialized programs for that as well as, like word, for example.
01:38
But let's let's start showing you what Excel can do. Although this lesson is about what I cannot do. So
01:49
if you go to excel and this is what you get basically get from excel
01:55
you see that you have cells. They are named their assorted in rows and columns and the rose earning a row. Rows are named from one to
02:07
almost
02:08
a lot, so
02:10
if you move down, it will show you what you have. But you can scroll that. And anyway, it's more than 30,000 throws that you can have in one excel sheet.
02:22
Also, when it comes to columns, you see the day go ABC the
02:27
all way to Zed, and then you have a A B, and you can scroll. I think up to says that so that's Ah, that's quite a lot.
02:37
Um,
02:39
when you want to enter something in a cell, you just click on it
02:45
and then you type,
02:46
and then you presenter and you have entered the number in the cell.
02:51
Now, if you're not using mouse, which is
02:54
highly not recommended. You need mouse with excel.
02:59
Um, you can just,
03:01
ah, move with your keys through cell
03:06
and then press
03:08
F too.
03:09
And you are in edit mode. So you don't see me pressing f too, because you're not seeing my fingers on the keyboard. But
03:16
this is it. So you can press it. D'oh!
03:20
And you can, uh,
03:22
enter data there
03:23
and then you again press, enter or click on some other cell, and you have intimidated in that cell.
03:31
You can copy cells with
03:35
clicking right button. And you get this this menu, you can say copy. And then you can click on pace than you have quite a lot of options. You have a simple based
03:47
you can paste values. Only you can paste formulas, whatever. So let me explain why.
03:53
So, for example, I'll say that this cell
03:58
has text in bold
04:01
and for example, it is red.
04:04
So if I click here on
04:08
copy
04:09
and then I pasted here,
04:12
it will
04:15
Yeah, okay. I have clicked on something wrong. So let's paste here
04:21
and you get the same contact, same color, same typeface. But you can also click, for example here and just pays the values
04:30
and until paste on lee, the value without form fitting. So this is how you copy paste sells.
04:36
You can also
04:39
grab this small
04:42
square. Here.
04:43
You see that mouse pointer changes. It's a shape. It's a little black cross here,
04:48
and you can drag it here, and it will copy it all the way.
04:54
You can also do that with the right click and then drag,
05:00
and then you can choose to
05:01
copy sells. Feel Siri's, which will give you this, which is very good for feeling some
05:09
first row first column of the table,
05:12
which has
05:14
Ordina numbers in it.
05:16
And but you can also those things like, for example,
05:21
I can do this
05:24
and I can feel for mating only. And then whatever I type here
05:30
is also keeping that former because I have copied former king of a cell all the way here. So this is how you enter simple data in excel, and with this, we're going to, ah, end this lesson
05:44
and we're going to talk more about entering data and functions and formulas later
Up Next