6 hours 3 minutes
Listen, I'm just going to mention some of the limitation to excel, so don't expect it to be a miracle, too.
Excel can do almost anything in terms of calculation and data manipulation, but not everything. So if you're looking just the basic,
ah, functions and formulas in Excel
it is limited toe like extent.
But if you combine it with my crow's, then it becomes very powerful tool.
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
you have to start excel. You have to open the file
excel file even one that is packed with very powerful macros that can do
a lot of things.
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
What were you doing?
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.
But let's let's start showing you what Excel can do. Although this lesson is about what I cannot do. So
if you go to excel and this is what you get basically get from excel
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
a lot, so
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.
Also, when it comes to columns, you see the day go ABC the
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.
when you want to enter something in a cell, you just click on it
and then you type,
and then you presenter and you have entered the number in the cell.
Now, if you're not using mouse, which is
highly not recommended. You need mouse with excel.
Um, you can just,
ah, move with your keys through cell
and then press
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
this is it. So you can press it. D'oh!
And you can, uh,
enter data there
and then you again press, enter or click on some other cell, and you have intimidated in that cell.
You can copy cells with
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
you can paste values. Only you can paste formulas, whatever. So let me explain why.
So, for example, I'll say that this cell
has text in bold
and for example, it is red.
So if I click here on
and then I pasted here,
Yeah, okay. I have clicked on something wrong. So let's paste here
and you get the same contact, same color, same typeface. But you can also click, for example here and just pays the values
and until paste on lee, the value without form fitting. So this is how you copy paste sells.
You can also
grab this small
You see that mouse pointer changes. It's a shape. It's a little black cross here,
and you can drag it here, and it will copy it all the way.
You can also do that with the right click and then drag,
and then you can choose to
copy sells. Feel Siri's, which will give you this, which is very good for feeling some
first row first column of the table,
Ordina numbers in it.
And but you can also those things like, for example,
I can do this
and I can feel for mating only. And then whatever I type here
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
and we're going to talk more about entering data and functions and formulas later