Excel Essentials: Screen Interface & Worksheets Navigation | Urdu – Hindi | Class 1

Music Assalamualaikum Today is our first class of Excel So first of all I would like to ask you to keep a copy of your pencil or pen with you And what you will learn in this course Write it in the form of points This will keep things in mind And you will remember And in any course, any course you are doing or learning Do try this method Insha Allah it will be very beneficial So we will cover these two parts of module 1 in this video And in the next video, these two So let's start the video Open Excel Hold the Windows key Press R So this dialog box will open And enter Excel.exe in this So Excel will open directly This was the shortcut method You can also open it directly So we will open the blank workbook first Now the Excel workbook It is divided into two parts The first part is Ribbon And the second part is Sheet or Worksheet Now don't be afraid to see so many things in Ribbon Because you will learn all these things And it will be very easy for you So we will discuss the Ribbon of Excel first In the Ribbon of Excel There are many things In the Ribbon of Excel First of all, there are tabs These are the tabs of Ribbon And there is a quick access toolbar In which you can do whatever work you want to do quickly There are some commands here You can apply them The commands you have recently applied They will also be shown here Then this is Excel Then this is Ribbon's title bar The name of your workbook will be shown here This is the save button This is the quick access tool You can undo and redo You can undo and redo In different tabs There are commands in the form of different groups Like this clipboard You can copy and paste You can copy and paste And this is the font group You can copy and paste And this is the font group There are many commands Now let's come to the sheet In the sheet There is a name box The number of your cell For example, these are the columns And these are the rows The columns are in this shape And the columns are in this shape The column letter The column is introduced With the letters And the rows are introduced with the numbers The cell you select The rectangle box The rectangle box Is called cell And the cell you click on Is the active cell The reference of the active cell Is shown in this name box For example, column A Row 1 Column D Row 6 Column D6 You can find the cell You can find the cell You can find the cell Here is the formula bar Here is the formula bar You can write the formula You can write your text You can edit it To write the formula function You can press this key There are many functions Which I will teach you later You can use them This is your status bar You can see here You can start working You can see here You can select the entire sheet You can select the entire sheet You can select the entire sheet Whatever data is there You can zoom in and out You can zoom in and out You can also change the page layout with this. For example, we use this for printing. This will show you the page layout. You can also change the page layout. This will show you how your print looks like. If you want to create or insert a new sheet, you can also do that. You can also rename the sheets. For example, this one is named WingData. And this one is named Dashboard. You can also change the name of the sheets. If you want to move these sheets, you can also do that. You can save the workbook from here. Or you can press the shortcut, CTRL S, and it will save it. And the name will be the same. We will browse. If you want, you can also save it in PDF. Or you can save it in any other format that is supported by Excel. You can also save it in that format. If you give it a name, it will be saved accordingly. So this was our today's video in which we understood the screen interface and how to navigate workbooks and worksheets. I hope you all understood this. You must have noted these points. If you practice this, you will be able to understand it better. In the next video, we will cover the next two parts. Peace be upon you.