Microsoft Excel Part-1 | Tutorial for Beginners

 Microsoft Excel Tutorial for Beginners

 Part-1

Excel For Beginners

Excel Tutorial Beginner To Advanced Course

Well, in this lecture, in lecture number one, we will read about Excel. Excel is a counting software and it is mostly said that it comes in that you can make budgets using Excel, calculate expenses, results etc. and any performance analysis you can do in it, you can do it in it, that is, about numbers, about budgets and other than that, about financial matters, it is mostly used for these works and apart from this, I think that it is also very good for counting automation, so we will discuss the amour of Excel, Inshallah, 

This video is helpful.

Microsoft Excel Tutorial for Beginners

I am telling you this major thing, there is a thing which we call Graphical Dashboard, it is better for Graphical Dashboard and also for diagrams etc. After diagram, there are many more It also does such tasks which are called complex tasks. So this is a mini software of a database. It is a small software. So its work is mostly related to the database. So we will see them together. So our first lecture was that we will do identification, Inshallah. It is very important that you know the basics of Excel and we will also see the depth of it together. Inshallah, we will cover the basics in the first lecture and after that we will move towards intermediate. Well, in this lecture number two, we will see the basics of Excel 2016 and 2021. We will see what is new in Equal 2016 because we know that even before this Equal has gone through many versions as major changes started from 2007 in which ribbon was introduced and ribbon was replaced by key after this 2010 2013 and now 2016 after this 202 has also come so we are studying 2016 so that's why we will see here 2016 and 2021 both are almost similar so you can write about it further what is new chance in 2021 and 2016 so first of all Gate and Transform which here we hear Gate and Transform is usually called Power Curie it is usually named Power Curie and this Equal 2021 and 16 is fully integrated so it is said that it is flexible that You have the option to import a wide variety of data in it. Data of many types can be imported in it. So, the function that comes at number two is its 3D map. 

The 3D map feature of this Excel, which is also commonly called Power Map, covers data driving and impressive data driving maps etc. So, this is a very special tool. We will discuss about it in this. Apart from this, since you understand that Excel used to make charts, new types of charts have also been introduced in it. So, new types of charts like Tree Map, Sun Bust, Waterfall, Box and Whisker etc. have been added to Excel 16. After this, a new function that has been added to it is called Tell Me What You Want to Do. This type of help has also been added to it from 2016 onwards which is continuing till date. The theme of the office has also been added to it. When the theme changes with time, we will tell you about it. So this was our second lecture in which we were seeing what new updates have come in Excel 2016. Understanding workbooks and worksheets. Next we will talk about understanding workbooks and worksheets. 

The file of Microsoft Excel is called workbook. It is not called file. If we say that I am using a File then it is wrong. The word we will use here is workbook. Workbook is a workbook. So the workbook of Excel is as you can see. I open the Excel page in front of you. The Excel slider has opened. When we clicked OK on Blank Work, it opened in front of us in black. Now this whole file is called a workbook and you can see in it that this is a worksheet. This is a worksheet. You can add more to it. Excel has no limit in opening it. You can open as many workbooks as you want. Similarly, in an Excel sheet, many sheets can be opened. Their number is fixed. We will mention it later. 

So, I want to show you here that I have opened the Excel screen in front of you. What are the major parts in it? So, you should see it first. Some parts are very major. You should see them like this name box. This formula is the active cell or the active cell. That is, the cell on which we have clicked is called the active cell. The active cell indicator. Wherever we click, a mark appears. This is the vertical scroll bar. 

And this is a horizontal scroll bar, it is used for zooming, it can zoom in, zoom out, if you don't want to zoom, it will zoom out, after that there are some things here like this status bar where you can see the current thing, then this is okay and apart from this there are row numbers and these are column letters, these are columns, these are rows, okay, further you can see that just like in a computer, we close, maximize and restore, apart from this there is a minimize button and this is a ribbon which is visible in front of us.

There are tabs in the list of these ribbons. The ribbon tabs have different names. Each one of them has a different ribbon. So whenever we say, I mean, I am telling you to open the ribbon, you should understand that it is here. Okay, so I have told you a little bit about understanding workbooks and worksheets, which has just been opened and shown to you. So the tab list also has a title bar. The file that you save will have a title bar like this. Okay, and I have told you many other things which are very useful here. Okay, in lecture number four we will talk about moving around a worksheet. When Excel is opened, it is a worksheet in the workbook. So, Sheet One is currently on Sheet One. 

So, it has different statistics and properties about which we will discuss as in every workbook. This row on the sheet, this row number, if you want to round it, then I will show you, if you press the down arrow key, it goes down, like this, arrow keys are used for left, right, up and down, it jumps one cell at a time, you can also page down, which jumps more cells, you can also jump pages, similarly, if you are present in cell number one, a1, press the end key once and press the down key once, then you will jump, the total number of rows is 10 4856, that is the total, now if you want to go back, then you will control home here, here you will press end and then up, then the up key will take you back, I have explained this to you, this is the navigation of the rows, press end and go down, 10 lakh and similarly, if you press end in the beginning and right, then you will reach in front of the maximum column, which comes at the end on the x FD, this is a B CD E F If I go to the root then A A AB A C AD starts like this and its end is press end and right and press end and left then you move here very fast,

 okay this is one way, the other way is that when we write some return at any place, we write it like this, we write it like this and also keep it below, suppose I have given some data, now I am present on A row, inside the first cell of column press end right then you will reach the end column, if there is no error press end down then you will reach the end row, on the end row of A column which is your table, if there is no error then you will reach there, now I will show you one more thing which is often difficult, if a cell is broken here, blank, then press end here right then your end will stop at the point where Is there any error?

 Now see here, the line is broken, if there is a blank space for writing, it will stop here, so this moving round happens, so the sheet which is at the end of ours, move it down, move it to the right, then the sheet number which is at the end is coming, the number of SFD, okay, this is the number of any cell, control it, it comes at the beginning, so I was telling you the methods of moving which are done with the help of keyboard in this way, left, right, up, down, to go up and down, so here they have told one more thing, which I will tell you in a little detail, if you see this sheet on the black sheet on our screen, click on the empty space, now if you page down,

 you can see that we are going page down, okay, but if you click here and turn on your scroll bar, you page down, then that scroll will not be coming with you, here at this position you have If you want to reach the same active cell then press Control Back Space and you will reach the same active cell. You can see that if the scroll button is on and you press the down arrow, it will also work for moving. Earlier when we used to work on this, the cursor used to move down or up, but now when we are moving, you can see that the screen is moving. Okay, so there are different ways of moving with the keyboard, which we will tell you in a little detail. The ways of moving in this are first of all, the arrow keys, 

that means we are writing this here, so first of all, we have to discuss what is your number of rows. The total of the number of rows is 10 and 4576. This is their total and the maximum column number is x fd. X fd. and similarly, the last cell of yours is x fd ahead. 1048 576. Your end row. So whichever cell you click on, it becomes the active cell. Everyone knows what an active cell is and in this we were moving with the keyboard. So for a few days, I am moving left and right. Since the screen is moving, I turn off my scroll lock. Now if I go down, it moves down like this. 

Well, I move here. If I do alt page down, then see alt page down, you can see that it is moving one line at a time. Okay, what happens when you do alt page up, this is down, this is up, that is, one screen cell goes forward and one goes backward. I have already seen on control space and left right, you can use this for moving. Now let's come to navigation with your mouse. When you want to move somewhere, you simply click and it will move. You can move the scroll bar down. Click anywhere and it will move. Use the scroll bar. Go down and click

 

Then it will move

 

It is easy to move with the mouse

 

It is not so difficult

 

You can turn the wheel and with the help of keyboard you can move faster. So we were reading the lecture on Moving Around a Worksheet in which I told you how to navigate with a little information. Let us move on to the next lecture. In this lecture we will talk about Using the Ribbon. As we know we have Excel, when it was launched in 2007, the menu used to open by clicking on the file in this way. 

The entire screen has changed in it. In 2007 there was a menu concept. In 2003 there was also a menu concept. From 2013 onwards this ribbon has been created. Now Abdul Raman, in their place this ribbon comes. This is the Home ribbon. This is the Start ribbon. Page Let Formula Data Review etc. All these ribbons are called ribbons. They are called ribbons with their names. So you can see the Bill order, Home Start page. D

 

Formula Data Review and Developer etc. which are here but they come to View but are not coming forward. All these ribbons have their own use. Just like Home, Home has basic commands like Bolt etc. It is usually used in Insert. If you want to insert something here, chart etc., sticker, whatever is big, written in a circle, link and such things are page settings. In Formula, all the formulas used in Excel are used in Excel. Excel functions are used in large numbers. The functions used in this are data review and view. So we will read its details as well. This is our use of ribbon tabs. One of them is contextual tab. These are such tabs which come in front of you when needed. 

When needed, when the tab comes, for example, if you click here, it comes in front of you. Chart Bar Chart has come. I have entered Bar Chart. I double clicked it and you will see that the chart design opened up separately and the format also opened up. Before this, both of these were not there but as we click on the empty space in the chart, both are gone. Then I click this and they come up again. This is called contextual tab, that is, it appears when you need it. So, I told you the second thing about using the ribbon. I told you the first thing, the name of the ribbon tab, contextual tab, which is needed. Type of command on ribbon. If we discuss how many types of commands are there in the ribbon, then this will be done. So, first of all, let me tell you, the first button is the simple button. That is, you have written the name here, fun, education, fun. 

So, here you can see the font in front of us. This is the simple button. Click on increase font size. Click on increase down. If the font is going down, then this is simple. After that, the toggle button. The toggle button is pressed once and then it goes back, just like the bold becomes bold, press it again and the bold disappears, but it was not like this here, by pressing here it only increases, by pressing the bold it becomes bold and by pressing it again it comes back, okay so what is this toggle button, 

after that comes a simple drop down, its example is given as conditional formatting comes here, a small one, I go ahead, see this, here the formatting account is here, as you see this, see the menu, see its simple drop down, it is dropped, if you click on anything then it becomes a font, similarly if we select more than this is conditional formatting, this is also a simple drop down, it is a drop down of the table, see this, okay see this, this is such a simple one, I have used a drop down menu, that's it, after that comes the next type. That is the split button. Split button. See, I have selected them here. Now Merge and Center is the split button.

 By clicking on it, it splits all of them and creates a cell. I have to collect them together and merge them. A cell will be created. We can write a big fat in it, that is, pass percentage. And we can make it bigger with a fat. So these are split buttons. We can split the cells and unmerge them again. Merge center comes next to it. 

Accessing the ribbon. Accessing the ribbon by using your keyboard. For example, I have written a new thing here. It should come on sheet one. I have to bold all of these. And I have to bold all of these using the keyboard. So first of all, with the help of arrows, come to the first one. Press Shift and hold down right down and down. All of this has been selected. Now, I have to go towards bold. Press Alt once. Leave H and go to Home and then press B. Under B, under the board, they have written one. If you press one, you can see that all the text will become bold. Here, we can also do another command. We can change its color to blue. Press A, press G, H, G. So, the color of F is C. Press F and C. 

And here, with the help of arrows, if you give it a color, press Enter on it, then you will see that it will become of the same color. Now, with the help of arrows, we will move towards data. For example, if we want to go towards data, press Alt, press A, press G. After A, I want to do it here. Suppose, Text to Columns is E, see, Text to Columns is E. Then, you will get an error towards Text to Columns. But anyway, this way, I am telling you that accessing the command using the keyboard can be accessed like this. Okay, till now, today's lecture was such that we have used five keys in it. If you read it then Insha’Allah with the next lecture.