Time
6 hours 3 minutes
Difficulty
Beginner
CEU/CPE
6

Video Transcription

00:00
so welcome to model to on and in this module I will be talking about entering, dating Excel
00:09
and I will be giving you some basic ideas about how it sell works and what Excel is.
00:18
So, first of all,
00:20
um,
00:22
Excel is a part off spreadsheet, family of programs
00:27
and spread sheet is very old term in in 19 computing it.
00:33
One of the first programs that was doing things similar to Excel was called like that. Then came Lotus 123 And after that, Microsoft Excel
00:45
after some time became basically in an industrial standard,
00:49
and there are other programs on the market that do the same thing. But everybody's basically looking up to excel, and
00:57
it's, ah,
00:59
capabilities to create
01:02
their own self tour.
01:03
So
01:06
Axel is created to create, to manipulate in America and in textual data.
01:11
Mm. And it does it by using functions and for actually the user off Excel manipulates numerical and actual data by using functions and formulas and scripts, meaning Micro's
01:30
to do the manipulation of data.
01:34
Um, and also excel can be used to do look up into data. So if you have aggregated data that you have collected from, I don't know, some sales or some market research. Excel can help you
01:51
extract the information you want in the form that is understandable to you or your colleagues or wherever you want to present it to.
02:00
So it can do very complex calculations it can do called conditional calculations.
02:07
And this is what Excel is created. For
02:14
now, like every Microsoft Office program and Excel is part of Microsoft Office package, Excel has tendered IEDs. User interface, so excels. Consists off quick, quick access tool bar, which is in the top left off the XL window.
02:31
Ah, then, huh?
02:34
The next thing is Ribble, and this is basically where most of the commands in Excel that you're going to use our
02:43
some advanced uses. The XL also can use some shortcuts. But for most of the things you will
02:51
on a regular basis, use commends that they're located in the ribbon and ribbon consists off the tabs. And between each stab, you have groups off functions. These things can be customized. But this is a subject for more advanced.
03:08
Yeah, of course.
03:12
So next thing in excel user interfaces, Formula Bar eight sixed self uh, the left there is a window in which field is shown, and then you have the formula bar here.
03:29
Next thing is the work space in which you enter data and formulas functions and Malik manipulate data.
03:38
And then in the bottom, you have status bar, which cannon contains also things like sheets or tabs
03:49
within worksheets are within the within excel file. There could be quite a lot of them. So you have navigations through that.
04:00
And, uh, at the end, you have task pains, which are basically the parts that pop up onto the right off your excel window, in which you have additional
04:15
capabilities to manipulate objects that you're working in an excel. It can be if you have in certain some object,
04:23
or if you're using some things like, for example, people tables, which we're going to talk about almost very end of this course.
04:30
So when you do something that requires temporarily some some manipulation or parents, permit is to be set
04:42
that they're not part of the ribbon and you're doing that, then, ah, task pane pops up.
04:53
Well, it's now switch to excel just to see how these things look in Excel window. I have ah Of course,
05:00
maximize this window to cover the entire screen. And if you click in any cell here you see in this bar here that the coordinates are the address of the cell changes
05:15
and ah, you have there is this quick Texas toolbar. And then this is the ribbon, and this is, ah, work space. And this is
05:28
how you enter data. So you click on the cell
05:30
and you basically just enter, for example, a number,
05:34
and then again, some other number.
05:39
And then if you want to enter formula, you click in the cell you press equals, and then you enter your formal formula. In this case, it's going to be sorry.
05:49
It's going to be something like a simple as this. So this is how you do
05:57
how you enter data in Excel.

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