Part 4: Advanced Microsoft Excel Course - Create First Basic Excel Worksheet in Urdu/Hindi - video Dailymotion

Tutorials Ocean

Advanced Microsoft Excel Course - Create First Basic Excel Worksheet in Urdu/Hindi  Hello Friends,  I am #SyedArshadSultan and you watching #TutorialsOcean. This is Part 04 of the Advanced Microsoft Excel Tutorial Series, in this Advanced Microsoft Excel video tutorial, we will see Create First Basic  Excel Worksheet in Urdu / Hindi 2020.  Friends, agar tutorial k samjhny main problem ho rahi ho to aap neechay comment kar saktay hain ya phir meri web site sy is post ko study kr sakty hi.  For More Video Tutorials Please visit my web site: https://tutorialsocean.com  Download Excel File: https://tipsli.com/FirstWorksheet For More Excel Examples Click here: https://tipsli.com/ExcelExamples  ------------------------------------- Please Flow Social Media: Facebook:   / tutorialsocean   Instagram:  / tutorialsocean   twitter:  / syedarshadsult1   ------------------------------------------- If you like the video, then please do like it, then subscribe to our channel for more videos, and don't forget to press the Bell Icons.  اگر آپ کو ہماری ویڈیوز پسند آ رہی ہیں، تو برائے مہربانی لائک بٹن کو پریس کرنا مت بھولئےگا۔ اور اس کے بعد چینل کو سبسکرائب بھی ضرور کی جئے گا۔ اور بیل کے بٹن کو دبانا مت بھولئےگا۔ بہت بہت شکریہ

Transcript

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

Part 4: Advanced Microsoft Excel Course - Create First Basic Excel Worksheet in Urdu/Hindi

Category

Transcript

Recommended