Part – 2 – Excel Help
Transcript For The Video – Excel Help
Video on “Excel Help” : Let us now have a closer look at the EXCEL work sheet area. The excel work sheet area consist of various rows, different kind of column and intersection point between row and column is known as cell. Each cell can consist of different kind of data the data can be a numerical data or a text data some regular type of data which can be inputted in the cell can be found by right clicking and clicking on the format cell you will find these are some of the general cell types you can also input date, time, percentage, fraction scientific to extent you can also customize the cell data, we will discuss all these in very much detail later but you must understand that cell can contain different kinds of data the data can be text, number, currency, accounting, date time etc. Each cell has a name let say for example cell, cell no B2 this name is can be seen here how do we identify that this is cell B2 as you can see its highlighted, highlighted one is ‘B’ here and highlighted one is ‘2’ here you can clearly understand that you are at cell B2. For example let me click here the highlighted one is E & 7 the cell no would be E7 which is visible here. Let’s say if I want to go to particular cell say example if I want to go directly A55 there is a shortcut by which you can do it. You can press F5 which is available on the top of your F function just press F5 and type the cell number which you want to navigate. So you will be directly taken to the cell where you really want to go. So this is a utility of go to function this called as a go to function and shortcut you need to remember is F5, just press F5 the dialog button would open and you need to type whichever cell you want to go and you can press ok and you will be taken to that cell. Now there are various kind of regular shortcuts which you must know 1. Is How to navigate from left to right let us say if I want to navigate from left to right like this how I will do that. The shortcut here is to use the arrow key you must use the arrow key which helps you to go from top to bottom, bottom to left, left to right just press the right key and you will be taken on the right. You can also use the shift key to take 1 step on the right hand side so this is what you can do if you want to go navigate on right hand side. Let us say if you want to navigate on left hand side, you can simply press the left arrow button and it will take you to the left side of the column. You can also use another shortcut which is shift +tab so let us say if you are pressing shift + tab which I am doing right now you will be taken to the one which is on the immediate left. So this is what you can do in order to navigate the worksheet area. There are other shortcut which may be important one frequently used would be to use CTR+ HOME, CTR+ HOME means you are pressing HOME and you are pressing CTR. So Let see what happens when I do that CTR+ HOME you can see I am now taken to the cell A1 so this means that I’ll be taken to top of the worksheet. So this takes me to the top of the worksheet by using this shortcut. And then there are some navigation shortcuts which are really use full these would be page down or page up. Let me do page down and see what happens. A Page down means there is a clear change in the frame of the worksheet I have been taken one frame down in the excel area. like wise let me do page up, one frame up so can do page down in order to navigate from top to bottom and page up, page down and page up. So navigate from top to bottom and bottom to up. So now let me ask you a quick question how many number of cells are in sheet one. In order to calculate let say this was the question how many number of cells are there in sheet 1 what do we require? We require number the number of rows, we require number of column and we may have to multiply the rows with columns in order to find the number of cells right so approach is simple. Count the number of rows counts the number of column and multiply both of them to find the total number cells in sheet 1. So number of rows as we navigate down we find that they are Approx 1 million. Now 1.048576 million so let me write it down 1048576 i.e. total number of rows. in order to calculate number of column lets navigate on the right hand side and the since the numerical system is based on A, B, C and combination of that it may be a big difficult to count that in a second that in a second so I’ll give you that number the total number of column which there is an sheet one or normally there any sheet is 16384 this the total number of column which are there in any sheet let us quickly multiply and see how many cells are there. With the assumption that I will be explaining you the multiplication and division function in greater detail later. Let me just prove a point here without explaining how I came these formulas. I am doing a quick division so as convert this data into billions and what do we find out is that the total no. cells which are there is 17.17987 million cells in sheet 1. What about sheet2? Again 17.17+ cells like sheet 3. Can I make more sheets? Yes you can. You can click here and insert more sheets you can have multiple sheet here sheet1, sheet2, sheet3, sheet4……… and you can go on- on and on. Now I am sure you would be facing a question or you may be having a question that why do we really require so many million cells in a single sheet. You may be wondering why in this universe we may require more than 1 sheet when we have more that 17.17987 million sales. The answer actually lies in how you want to structure your work book or work sheet. What do I mean by structuring a worksheet is let us imagine that if we have a situation where you want to document the name and the email IDs of all staff in the company. Now there are two ways of doing this one is that you document name and email ID of all staff in this sheet 1 it self and they may be thousand & thousand employees in your company so that will come under single category or the other approach which may probably be better for some of you would that you can have different sheets for different departments may different sheets for HR, different sheets for Finance, different sheets of let us say marketing, different sheets of operation and may be different sheets for IT and so on so forth. So in this way you will have different sheets here let’s say this will be the sheet for HR and another sheets of marketing and you may continue like this in order to make different sheets with name and email ID of all your staff. While we use excel we find that there are so many function or command which we may not know or probably we have gone through those functions earlier but we still do not remember those function so that situation make come time and again. So in that case please remember and please be informed that you can always use help function from the menu command by typing just F1 from the top function button. So let us press F1 and understand what happens next. So there is a quick dialog box that opens which is called as excel help and you can immediately browse all excel help topics let say I may have to really find some help on a topic which is on lets say introduction to excel what is data validation let say how do a chart I can go inside and may be through it and read that detail and understand that in a very efficient way. Other approach could be that you can type the query in the search button here on the top and just press enter so I am typing RIBBON because we have just learned what is exactly is ribbon and you will find different kind of help topics associated with ribbon which are there in articles so let say I press customize the RIBBON in this article you will find how will go about customizing your Ribbon and its specification here so please make the most of excel help which is there the shortcut is F1 from the function menu.