00:00Assalamualaikum warahmatullahi wabarakatuh
00:02My name is Sayyid Arshad Sultan
00:04and you are watching Tutorializations
00:06We are discussing advanced Microsoft Excel course
00:10and this is the fourth part of our course
00:14which we will discuss
00:16Create First Excel Worksheet
00:18I will share my videos
00:20without any freelance project
00:22without any course
00:24I will share my course
00:26I will share my course
00:28but I will share my course
00:30Inshallah, I will be able to
00:32make two videos
00:34from Microsoft Excel course
00:36that will be uploaded
00:38Before I start my course
00:40if you have any requests
00:42to subscribe to my channel
00:44kindly to subscribe
00:46and press the bell icon
00:48and press the button
00:50so that your course related videos
00:52will be in time
00:54and your notifications will be available
00:56If you start your course
00:58before I start my course
01:00before I show you
01:02Microsoft Excel worksheet
01:04Inshallah, we will create
01:06the worksheet
01:08Yes, friends
01:10This is a Microsoft Excel
01:12which is a basic
01:14basic basic
01:16Microsoft Excel worksheet
01:18which I have designed
01:20and I will do
01:22inshallah
01:23step-by-step
01:24designing
01:26in today's video tutorial
01:28we will discuss
01:29the formulas
01:30we will not discuss
01:31only in Excel
01:32we will discuss
01:33what we can
01:34do
01:35in Excel
01:36we can design
01:38and work
01:39in this
01:40we can do
01:42we can do
01:44in this
01:45process
01:46we can do
01:47in this
01:48professional style
01:49in this
01:50worksheet
01:51so
01:52let's start
01:53and
01:54first
01:55we will open
01:56our new
01:57worksheet
01:58in this
01:59worksheet
02:00open
02:01in this
02:02worksheet
02:03to
02:04file
02:05to
02:07click
02:08or
02:09a simple
02:10procedure
02:11and press
02:12and
02:13you can do
02:14a new
02:15worksheet
02:16in this
02:17worksheet
02:18in this
02:19worksheet
02:20and
02:21we will
02:22design
02:23the first
02:24worksheet
02:26in this
02:28worksheet
02:29to
02:30create
02:31little
02:32things
02:33in this
02:34first
02:35you can do
02:36the
02:37worksheet
02:38to
02:39start
02:40and
02:41start
02:42from
02:43the
02:44left
02:45side
02:46of
02:47your work
02:48to
02:49start
02:50first
02:51in
02:52accounting
02:53we
02:54design
02:55first
02:56we
02:57name
02:58so
02:59in
03:00Microsoft
03:01Excel
03:02name
03:03you
03:04like
03:05you
03:06can
03:07see
03:08this
03:09worksheet
03:10in
03:11this
03:12worksheet
03:13in
03:14this
03:15worksheet
03:16is
03:17the
03:18worksheet
03:19in
03:24the
03:26worksheet
03:27limited
03:29type
03:31left side
03:33is
03:35center
03:37and
03:39here
03:41second line
03:43sheet
03:45design
03:47this
03:51third line
03:53this
03:55month
03:57this
03:59month
04:012020
04:032020
04:05here
04:07type
04:09formatting
04:11in
04:13the
04:14columns
04:15create
04:17date
04:19second
04:21column
04:23create
04:25date
04:27second column
04:29here
04:31date
04:33name of
04:35item
04:37particular
04:39description
04:41column
04:43name of
04:45item
04:47so
04:49here
04:51we can
04:53increase
04:55this
04:56name of
04:58item
05:00name of
05:01item
05:02name of
05:03item
05:04type
05:05quantity
05:06items required. Then, I have a unit price and rate. Then, I have a column called Net Amount.
05:14Net Amount and Unit Prices column to increase or decrease.
05:21In all columns, I have a center align and bold.
05:27Ctrl-B, for bold.
05:30If you want to see the net amount of text,
05:34I have a column size.
05:36The net amount of text is greater.
05:38So, there are two sources.
05:40One, I have a column size and width.
05:44But, this is the best option,
05:46because we have a numerical type of data.
05:52In the last video, we discussed the data in Microsoft Excel.
05:56We discussed one data type.
06:00Now, we have values.
06:03So, you can see all of it.
06:05its size
06:31If the text is more or less, it will be converted into two lines.
06:36If you click on the wrap, you will see that the net amount is in two lines.
06:42You can define the columns in Microsoft Excel.
06:46If you have Microsoft Word, you can use the table to deal with Microsoft Word.
06:56Now let's do this.
07:03You can see the grid lines in Microsoft Word.
07:07If you click on the preview, you will see that this worksheet has not been in printout.
07:20We will select the tables and borders to show the borders.
07:31You can click on the found option.
07:33You can click on all borders.
07:37If you have a border, you will see all the borders in the preview.
07:44You will see all the borders in the preview.
07:46Let's do this.
07:48Let's do this.
07:50Let's do this.
07:52Let's do this.
07:54The next video.
07:55First, let's explain this.
07:56This is a map.
07:57We can see that right now.
07:58You can see that on the right side of the left of the corner.
08:01The sheets you have been�elted by the left side.
08:05This is a map.
08:06We can see it in the right side.
08:09We have started.
08:10Microsoft Excel.
08:13When we first started classes,
08:14we have completed 16.000 columns.
08:18this is the best option here that we have a worksheet in the center. If you are looking at this page, you can see a dotted line with a dotted line, which is the best option to create a letter size.
08:46So, what do we do in this sheet? We will arrange our headings in the center of the sheet.
08:54So, I will select the row and select the net amount to the column.
09:02Then, I will have alignment option which is Merge & Center.
09:08So, if you click on Merge & Center, you will select all columns A, B, C, D, E, F.
09:13So, what do we do in this sheet?
09:17Then, I will select the row and select the row.
09:21So, I will select the row and select the row.
09:25So, I will select the row and select the row.
09:29So, I will remember that all of our rows will select not only one-one-one time, but only one-one time.
09:39Then, I will select the row and select the row.
09:43Then, there is third row, which I will select the row.
09:47Then, I will select the size of the row.
09:51Then, I will select the row with the row and select the row.
09:55This is our little worksheet that is ready to look at Microsoft Excel
10:01Now if you want to choose to make it more beautiful
10:04I have selected the border and headings to the worksheet
10:08and you have alignment which we call middle alignment
10:15You can use the table in Microsoft Word
10:17which you can use horizontal and vertical alignment
10:20You can use the middle alignment
10:26So you can use the middle alignment
10:28This is the center of the cell
10:30If you want to add a color on this
10:35If you want to add a color color
10:37If you want to add a color to the color
10:40You can select color
10:42You can select this option
10:45When I want to add worksheet
10:48So that this is the total amount
10:51This is the total amount
10:53I have just changes
10:56When I have total amount
10:57Now you have to change the total amount
11:07I have total and bold
11:10and the other way that it will be central.
11:13Now I just want to select two cells.
11:16I just want to select two cells.
11:18So I want to select two cells.
11:20So when I select one cell,
11:22I will select one cell.
11:24So I want to select one cell.
11:26So this is our simple worksheet of Microsoft Excel.
11:30Now I have created.
11:32Now I can select one.
11:34Then I will select one.
11:36Then I will select one.
11:38In order to install one cell,
11:42ICamini.
11:44Google-Labверts re-option
11:47AND the left programs
11:49by the excellent picture
11:50You will create an option
11:52in operation.
11:56I want you to choose the менabeljemg
11:58for such as a single cell.
12:00Now I'm going to launch a person
12:05So, you can select these two numbers and select these two numbers.
12:08I found the zoom size to increase the size of the screen so that you can use the same concept.
12:14You can select this one and two.
12:20Now, you can see that one and two are selected.
12:23When you select your cells, you can select multiple cells.
12:28The first cell will be white color and the other cells will be gray color.
12:35Now, if you want to set the numbers in the sheet,
12:39then you have a plus sign on the right side.
12:43You can select the cell and cursor to the black color.
12:49You can select it and drag it down.
12:53Then, you can generate the numbers automatically.
12:57So, you can generate the data.
12:59Now, you can use your Microsoft Excel sheet.
13:03and then, you can use your data.
13:05So, you can select the data.
13:07Let's select data, data, name of items.
13:09You can select quantity, unit file.
13:11And then, we will make it amount.
13:13Net amount, calculate for this.
13:15From the right amount, we have to use formulas.
13:17?
13:19?
13:24?
13:27?
13:42?
13:45I have said that I have added an item for a key board purchase which is 15 and one key board that I have got 6-70 rupees.
13:56Now we have net amount calculate. Net amount we will calculate in simple formulas.
14:02In the next video, we will discuss details in detail.
14:05Inshallah, we will have a very good concept in this case.
14:09I have made a basic formula for Microsoft Excel.
14:12I have made a basic formula for Microsoft Excel.
14:19We will save this information.
14:22We will save it.
14:24We will save it.
14:26We will save it.
14:28We will save it.
14:30We will save it.
14:32We will save it.
14:35I have made it for my location.
14:36I have designed the desktop.
14:38I have designed the first worksheet to save it.
14:42First Worksheet
14:44Microsoft Excel
14:46Worksheet
14:50If you download this worksheet
14:52In the description
14:54There is a link in Excel
14:56You can download it
14:58If you have any issues
15:02If you have any issues
15:04If you have any questions
15:06If you have any questions
15:08If you have any questions
15:10If you have any questions
15:12In time
15:14Thank you
15:16Next video
15:18Most important
15:20Microsoft Excel
15:22We will discuss the basics
15:24We will discuss the basics
15:26We will discuss the basics
15:28We will request
15:30My channel Tutorial Ocean
15:32Subscribe
15:34Bell icon
15:36Do not do that
15:38You can do that
15:40You can do that
15:42You can do that
15:44Assalamualaikum
15:46Thank you
15:48Thanks
15:52Thank you
15:54Thank you
15:56Thank you
15:58Thank you
Comments