Introduction to Excel 2013 - Lecture Notes

hello and welcome to the first video lesson of the Excel course I am so mad Bunsen and in this video we will learn about getting started with Excel for the purpose of recording these videos I have used Excel 2013 but if you have earlier versions such as 2010 or 7 there is absolutely nothing to worry about almost all the features that I would cover in this course are also available in 2007 and 2010 there are however some new features introduced in 2013 and I will highlight it whenever I talk about it now let&#39;s get started the very first thing that I want to cover in this course is the Excel structure so this is what you would see when you open a new workbook in Excel 2013 as of now the title or the name of this workbook is book 1 but if you save this with some other name then that name appears here on the right I have these 5 options at the extreme right I have this cross with which which would close this workbook I have the option to restore down if I click on it this would reduce the size of this window I can click on it again to go back to the original size I have the option to minimize this workbook here is an option where you get more flexibility on how the tabs and ribbons are shown and then there is the Microsoft Excel help which can also be accessed using the keyboard shortcut f1 on the left here you have the quick access toolbar so this area is called the quick access toolbar where I have three options save as undo and redo now quick access toolbar as the name suggests gives you very quick access to a lot of options so that it is easy for a user to perform certain operation or use a feature by just clicking on it here I would show you later in this video on how to customize quick access toolbar below these options we have the tabs so I have tabs such as file home insert if you look at the file tab you would see the backstage view of excel where you get a lot of options information on the workbook opening a new workbook saving it and printing it I would go back by hitting escape and there are a lot of tabs at the right of file tab I have home insert page layout formulas data review and view this feature of tabs and ribbon was introduced in Excel in 2007 in the 2007 version and this was a major enhancement because it makes it really easy for a user to access these commands if you go to the Home tab you can see that there are groups of options so here I have the clipboard group where there are four icons that would do things related to the clipboard similarly I have the font group where all these options would pertain to the font feature in Excel similarly I have alignment number styles within home if you go to insert you would have all these options that are related to insert and within that you would have these groups such as tables illustrations apps and on you can see that these groups are divided by a vertical line below this ribbon we have the name box in the name box you would see the address of the current selected cell so for example if I go and select this cell then you would see the address of the cell which is c3 there are a lot of more things you can do using the name box which I would cover later in this video course on the right of the name box we have the formula bar in the formula bar you can either type something so for example if I type Trump Excel you can see that whatever I type in formula bar get inserted in the cell that is selected on the contrary if you type something here so for example if I type Excel is awesome it would also be visible in the formula bar and I can go and edit this text or all the data which is there in the cell using the formula bar also a formula can be inserted within a cell using the formula bar or it can be edited here below the formula bar we have this area which is called the work area and this is made up of a number of rows and columns so for example I have these columns a b c d and so on and so forth you would have a lot of columns up to x f d if you are wondering how i went to the end of this sheet I used a keyboard shortcut ctrl right arrow and you can come back by using ctrl left-arrow similarly we have a lot of rows here so for example if I go down I can see that there are 1 2 3 4 these are rows that make up the work area and we have more than 1 million rows in Excel 2013 so this would constitute the work area where you would probably spend most of your time because this holds the data in Excel and this is made up of different cells now each cell would have a unique address so for example if I select this cell this would be column B and row 7 so this cell would become b7 and as I said the address of this cell would be visible in the name box if I go here then this would be f9 because this is column F and row number 9 below the work area we have this gray strip where you would see the sheets in Excel so for example here I have only one sheet worksheet which is sheet 1 but a workbook can contain a lot of worksheets so for example here I can add another worksheet and these would get added here and you can access these worksheets from here if you have a lot of worksheets say for example 20 30 or 100 worksheets then you can use these arrow keys to access these worksheets by making them visible so for example if I had say 30 and it is not visible here I can use these arrow keys on the right I have this horizontal scrollbar that can be used for navigating in Excel similarly I have a vertical scrollbar that can be used for navigating in the rows below this grey strip I have this green strip which says it ready as of now this is the mode in which Excel is currently so for example if I go and double click on any of the cell you can see that the mode changes from ready to enter there are different modes that you would see in Excel which could be either ready enter edit or point and that would tell you instantly that if you are editing a cell then that would be in the edit mode so for example if I type here something you can see that this is now in the ready mode this is to record macros this button and we will talk about it more later in this video course also I want to show you something if I type some data here say two three now have a look at the area here when I select this data as soon as I select this data this gives me the some statistics such as average of this dataset count and sum so these are certain statistics that get populated as soon as you select a numerical database I also have these options to select the way this worksheet is being displayed as of now as of now it is in the normal mode but I can set the page layout view or the page break preview you also have this option to zoom in and zoom out in this worksheet so for example if I use this slider then I can see that I have a lot more cells visible as of now when as compared to when it was at 100% at max you can go up to 400% and you can go up to 10% on the lower side so these are all the components in Excel 2013 which you would see when you open a workbook now let&#39;s talk about how you can navigate in the work area in Excel there are various ways you can navigate in the work area in Excel one of the easiest way is using the mouse so you can just go to any of these cells and click on it and it&#39;s get selected if you want to move to the right of these columns then you can use these scroll bars and you can go and select a cell there or you can move down by using the vertical scroll bar you can also use the keyboard shortcuts so you can use the right arrow left arrow key up arrow key and down arrow key to navigate in this work area in Excel if you quickly want to move around the work area there are certain keyboard shortcuts that you can use one is page up and page down so see what happens when I hit page down it takes me to row number 24 so I was at row number 1 and it takes me to row number twenty-four which means that it skips 23 rows at a time so if I hit page down again it would again skip 23 rows and bring me to 47 so this could be one quick way to move down these rows similarly if you want to go up you can use page up key if you want to move to the right of these columns then you can use the keyboard shortcut alt page down and when I hit alt page down then it takes me to column T from column a and again if I hit page down it takes me to call him a M similarly if I want to move to the left I can use alt page up so this is a quick way to move around in Excel using keyboard shortcuts if you have to navigate through the worksheets again one of the easiest ways is to use your mouse and you can select the worksheet wherever you want to go but in case there are a lot of worksheets which are in your workbook and it&#39;s not available you can use these arrow keys so for example if you have 30 or 50 or 100 worksheets then you can use arrow key to first make them visible and then select them using the mouse you can also use the keyboard shortcut control page up and page down to move through these worksheets so for example if I hit ctrl page down then you can see that I am moving to the sheet which is to the right of the current sheet so for example if I hit ctrl page down it would move from sheet 2 to field 3 and similarly it would move to the right I can move to the left of these sheets by using the shortcut ctrl page up so it would move to the left of the current worksheet if you have a lot of data on your worksheet then you can also use the slider to zoom out which would make a lot of cells visible on the screen then you can select the data set similarly you can zoom in when you are done you can also use the keyboard shortcut control and if you have a mouse with a wheel on it then you can use that wheel while the control key is pressed so that it will zoom in and zoom out another way you can navigate in the worksheet is using the name box so for example if you want to move to cell D hundred then you can type that address here and just press ENTER and this will take you to the cell D hundred similarly if you want to go to say some cells am 120 then you can just type the address and hit that hit Enter key and it will take you to that cell so this is a very quick way to move to a cell where you may have something like a total of a table or a value that is using in a formula or something then you can quickly move to that cell by using the name box as well now let&#39;s learn more about the ribbon and taps feature in Excel one of the major enhancements that was introduced in Excel 2007 was the tabs and a ribbon feature and it makes it really easy for anyone to access these options within each tab so for example if I look at insert I would have all these options which are related to insert similarly if I look at formulas then I have all these options that are related to formulas within each tab I have these groups so for example I have function library group within formulas and it holds all these options that are related to function library similarly I have a find names group which hold all these options for defined names each of these groups are separated by vertical lines now there are different kind of options available in this ribbon there could be buttons that do something when you click on it so for example if I type one two three here and you can see this is a cell and I want to give a border through to the cell so I go to home and within home in the font group I have this option to give a border I select on it and it would give a border to this cell and this is the function of this button as soon as you select it it does something but there could also be toggle buttons which would do something and if you click on it again then it would undo itself so for example if I write one two three here and I go to home alignment and I click on Center alignment as soon as I click on it it makes my text or the number aligned to the center but it is a toggle button if I click on it again it would revert that so there could be options which does something when you click on it there could be options which are like a toggle button there are also dropdowns in this so for example I have this drop-down for formatting and here I can select a number format and as soon as I do this it gets changed and again I can have the drop-down and change this to something else another very useful feature in Excel is the quick access toolbar as I mentioned by default it has these three options the Save button the undo button and the redo button and you have a small arrow here and if you click on it you would get access to a lot more options so you can see there are many options here that I can add to the quick access toolbar as the name suggests this is very quick access that a user can get this is always available and you can click on it and it would do whatever that I can say so for example in this case it would undo whatever I have done if I click on it it would undo the formatting also you can see there are two options at the end of this drop-down which says more commands and show below the ribbon more commands has to do more with customizing this quick access toolbar where you can add more buttons I would show you later in this video how to do this but this is the option I am going to talk about which is show below the ribbon if you click on it this quick access toolbar gets displayed below the ribbon but there is no apparent reason I would want to do this because first of all this would require a lot more area in my worksheet and I would see one row less as compared to when this was at the top so for example have a look here I have row number 22 highlighted and when I select and will say show above the ribbon I have one more row visible so you can keep it here but if you want to put it down below the ribbon if you think that makes it easier for you to access options then you can use that option as well while we already have a lot of options available in the ribbon and tabs if you think that you would need more controls for a particular feature then there are two ways you can go about it first is the dialog box so for example if I am in the Home tab and I want to get more control over the font property then I can click on this dialogue box launcher and as soon as I click on it it opens the format cells dialog box this would have a lot more options as compared to the ribbon because this is the entire range of options that is available to a user to perform these actions within the format cells purview so for example if I want to talk about font and if I want to change anything these are all these options available to a user so one of the ways to get more control and more access access to more options is by using the dialog box and for each of these groups you can use this dialog box launcher these de stated arrow to display the dialog box another feature which has been used in 2013 is the task pane so for example if I go to insert and I insert a picture this picture and I want to play with this picture change it a bit I already have some options available but here but if I need more control I can right click and select format picture and as soon as I do this I have this task pane available earlier in 2010 or 2007 this would have been a dialog box but in this case in 2013 nothing changes except the fact that this task pane is available with one minor thing that this is available for the entire time you are doing in operations for example if I want to add say a shadow to this and while I am doing this this pain would be available so you do not need to click OK or do anything as soon as you make the selection it would be visible here so this gives you more control and more flexibility while working with options while a lot of options are already available using the tabs and ribbon in Excel not everything is there and you may want to add a few new functionalities to the ribbon or to the tab so let me show you how you can customize the ribbon right-click on any of the tabs go and right-click on any of the tab and you have this options where you see customize the ribbon click on this option and it opens the Excel options dialog box now on the left at the top you have these commands so it would say popular commands you can select all commands and this would display all these options that are available in Excel on the right you can see your existing your existing tab list so for example you see that I have home insert page and you can even go and edit these by their groups so for example if I have this Developer tab which is not as of knowledge is not visible I can glow go and select this and when I click OK this tab gets available and now I can see that there are a lot of options available within the Developer tab but if you want to say create your own tab then you can also do that right click again and click on customize the ribbon here select all commands and in the customize the ribbon option go and click on new tab and this would insert a new tab for you you can go and rename this tab so for example I say I want to name this Trump Excel favorites use the shorthand code and I click OK and now it has created a tab which says Trump Excel favorite now you can also go and create a new group so for example I rename this group and I can insert an icon if I want and I would say analysis and I click OK so now you can see that I have a tab which says Trump Excel favorite and I within that I have a group which says analysis and I would hit OK and as soon as I do that you can see I have Trump Excel favorite as one of the tab and within that I have these this group analysis now I can add icons to it I could again go to customize the and here within analysis I would select any of these commands so for example let me randomly select any of the command let&#39;s say copy and I add and this gets added to the analysis group similarly I can add another options I&#39;m randomly selecting any of these options and I click OK and as soon as I do this you can see that I have Trump Excel favorites and within analysis I have all these options so in case you want to create your own tab or there are some options which are either not available in the existing ribbon or you want to get together a set of options and put it in one group then you can use this customize the ribbon feature similarly you can also customize the quick access toolbar and this is really handy when you have to add options which you frequently use so for example I would show you just right click here and again go to customize quick access toolbar option it would again open the same excel option box but instead of your tabs and ribbon here now you see a list of quick access toolbar options again if you want to add anything say if I want to add cut or maybe Center so I usually keep alignment options here and I want to align Center then I would go click Add and hit OK and as soon as I do this I have this option here now wherever now whenever I have to Center a line of text I would just go and click on quick access toolbar because this would always be visible if I compare it to using it in the ribbon I would first have to go to Home tab and then go and select this option so it is really handy to add a few options in your quick access toolbar which for which you would always have access very quickly so this is how you can customize a ribbon or quick access toolbar to add options that you frequently use you would often hear the word active cell when you talk about excel and the concept is that at one point of time you can edit only one cell so for example if I want to type something here say I want to type from Excel I can only type this in one cell at a time I cannot type this at the same time in three cells so this is the concept of active cell that there would only be one cell that is active even if you have a range of cells available if you select all these cells even in this case there would only be one active cell and the address of this active cell is always visible in the name box so while I am selecting these cells you can see that in the name box it would show me how many rows and columns I am selecting but as soon as I am done selecting it would show me the address of the active cell so in this case F 4 is the active cell one last thing that I want to cover in this introductory video is how you can access the ribbon using the keyboard shortcuts as soon as you hit Alt key you can see that there are these alphabets that appear up at the tabs and in quick access toolbar so in quick access toolbar you have these numbers but in case of tabs you have these alphabets so here I have h4 home and now if I hit H I would have access to all these options and there are these alphabets again for these options so for example if I want to use the cut option then I can simply press X if I want to use the font color property then I can use FC so for example let me show you if I type shrimp XL here and I want to access the font color property I would hit alt H FC and as soon as I do this I would have these options available where I can use the keyboard shortcut to do this now this may look like a lot of effort but believe me when you start using keyboard shortcuts you would become much more efficient and fast in working with Excel that&#39;s it in this video I hope you found this useful thank you and have a nice day

hello and welcome to the first video lesson of the Excel course I am so mad Bunsen and in this video we will learn about getting started with Excel for the purpose of recording these videos I have used Excel 2013 but if you have earlier versions such as 2010 or 7 there is absolutely nothing to worry about almost all the features that I would cover in this course are also available in 2007 and 2010 there are however some new features introduced in 2013 and I will highlight it whenever I talk about it now let&amp;#39;s get started the very first thing that I want to cover in this course is the Excel structure so this is what you would see when you open a new workbook in Excel 2013 as of now the title or the name of this workbook is book 1 but if you save this with some other name then that name appears here on the right I have these 5 options at the extreme right I have this cross with which which would close this workbook I have the option to restore down if I click on it this would reduce the size of this window I can click on it again to go back to the original size I have the option to minimize this workbook here is an option where you get more flexibility on how the tabs and ribbons are shown and then there is the Microsoft Excel help which can also be accessed using the keyboard shortcut f1 on the left here you have the quick access toolbar so this area is called the quick access toolbar where I have three options save as undo and redo now quick access toolbar as the name suggests gives you very quick access to a lot of options so that it is easy for a user to perform certain operation or use a feature by just clicking on it here I would show you later in this video on how to customize quick access toolbar below these options we have the tabs so I have tabs such as file home insert if you look at the file tab you would see the backstage view of excel where you get a lot of options information on the workbook opening a new workbook saving it and printing it I would go back by hitting escape and there are a lot of tabs at the right of file tab I have home insert page layout formulas data review and view this feature of tabs and ribbon was introduced in Excel in 2007 in the 2007 version and this was a major enhancement because it makes it really easy for a user to access these commands if you go to the Home tab you can see that there are groups of options so here I have the clipboard group where there are four icons that would do things related to the clipboard similarly I have the font group where all these options would pertain to the font feature in Excel similarly I have alignment number styles within home if you go to insert you would have all these options that are related to insert and within that you would have these groups such as tables illustrations apps and on you can see that these groups are divided by a vertical line below this ribbon we have the name box in the name box you would see the address of the current selected cell so for example if I go and select this cell then you would see the address of the cell which is c3 there are a lot of more things you can do using the name box which I would cover later in this video course on the right of the name box we have the formula bar in the formula bar you can either type something so for example if I type Trump Excel you can see that whatever I type in formula bar get inserted in the cell that is selected on the contrary if you type something here so for example if I type Excel is awesome it would also be visible in the formula bar and I can go and edit this text or all the data which is there in the cell using the formula bar also a formula can be inserted within a cell using the formula bar or it can be edited here below the formula bar we have this area which is called the work area and this is made up of a number of rows and columns so for example I have these columns a b c d and so on and so forth you would have a lot of columns up to x f d if you are wondering how i went to the end of this sheet I used a keyboard shortcut ctrl right arrow and you can come back by using ctrl left-arrow similarly we have a lot of rows here so for example if I go down I can see that there are 1 2 3 4 these are rows that make up the work area and we have more than 1 million rows in Excel 2013 so this would constitute the work area where you would probably spend most of your time because this holds the data in Excel and this is made up of different cells now each cell would have a unique address so for example if I select this cell this would be column B and row 7 so this cell would become b7 and as I said the address of this cell would be visible in the name box if I go here then this would be f9 because this is column F and row number 9 below the work area we have this gray strip where you would see the sheets in Excel so for example here I have only one sheet worksheet which is sheet 1 but a workbook can contain a lot of worksheets so for example here I can add another worksheet and these would get added here and you can access these worksheets from here if you have a lot of worksheets say for example 20 30 or 100 worksheets then you can use these arrow keys to access these worksheets by making them visible so for example if I had say 30 and it is not visible here I can use these arrow keys on the right I have this horizontal scrollbar that can be used for navigating in Excel similarly I have a vertical scrollbar that can be used for navigating in the rows below this grey strip I have this green strip which says it ready as of now this is the mode in which Excel is currently so for example if I go and double click on any of the cell you can see that the mode changes from ready to enter there are different modes that you would see in Excel which could be either ready enter edit or point and that would tell you instantly that if you are editing a cell then that would be in the edit mode so for example if I type here something you can see that this is now in the ready mode this is to record macros this button and we will talk about it more later in this video course also I want to show you something if I type some data here say two three now have a look at the area here when I select this data as soon as I select this data this gives me the some statistics such as average of this dataset count and sum so these are certain statistics that get populated as soon as you select a numerical database I also have these options to select the way this worksheet is being displayed as of now as of now it is in the normal mode but I can set the page layout view or the page break preview you also have this option to zoom in and zoom out in this worksheet so for example if I use this slider then I can see that I have a lot more cells visible as of now when as compared to when it was at 100% at max you can go up to 400% and you can go up to 10% on the lower side so these are all the components in Excel 2013 which you would see when you open a workbook now let&amp;#39;s talk about how you can navigate in the work area in Excel there are various ways you can navigate in the work area in Excel one of the easiest way is using the mouse so you can just go to any of these cells and click on it and it&amp;#39;s get selected if you want to move to the right of these columns then you can use these scroll bars and you can go and select a cell there or you can move down by using the vertical scroll bar you can also use the keyboard shortcuts so you can use the right arrow left arrow key up arrow key and down arrow key to navigate in this work area in Excel if you quickly want to move around the work area there are certain keyboard shortcuts that you can use one is page up and page down so see what happens when I hit page down it takes me to row number 24 so I was at row number 1 and it takes me to row number twenty-four which means that it skips 23 rows at a time so if I hit page down again it would again skip 23 rows and bring me to 47 so this could be one quick way to move down these rows similarly if you want to go up you can use page up key if you want to move to the right of these columns then you can use the keyboard shortcut alt page down and when I hit alt page down then it takes me to column T from column a and again if I hit page down it takes me to call him a M similarly if I want to move to the left I can use alt page up so this is a quick way to move around in Excel using keyboard shortcuts if you have to navigate through the worksheets again one of the easiest ways is to use your mouse and you can select the worksheet wherever you want to go but in case there are a lot of worksheets which are in your workbook and it&amp;#39;s not available you can use these arrow keys so for example if you have 30 or 50 or 100 worksheets then you can use arrow key to first make them visible and then select them using the mouse you can also use the keyboard shortcut control page up and page down to move through these worksheets so for example if I hit ctrl page down then you can see that I am moving to the sheet which is to the right of the current sheet so for example if I hit ctrl page down it would move from sheet 2 to field 3 and similarly it would move to the right I can move to the left of these sheets by using the shortcut ctrl page up so it would move to the left of the current worksheet if you have a lot of data on your worksheet then you can also use the slider to zoom out which would make a lot of cells visible on the screen then you can select the data set similarly you can zoom in when you are done you can also use the keyboard shortcut control and if you have a mouse with a wheel on it then you can use that wheel while the control key is pressed so that it will zoom in and zoom out another way you can navigate in the worksheet is using the name box so for example if you want to move to cell D hundred then you can type that address here and just press ENTER and this will take you to the cell D hundred similarly if you want to go to say some cells am 120 then you can just type the address and hit that hit Enter key and it will take you to that cell so this is a very quick way to move to a cell where you may have something like a total of a table or a value that is using in a formula or something then you can quickly move to that cell by using the name box as well now let&amp;#39;s learn more about the ribbon and taps feature in Excel one of the major enhancements that was introduced in Excel 2007 was the tabs and a ribbon feature and it makes it really easy for anyone to access these options within each tab so for example if I look at insert I would have all these options which are related to insert similarly if I look at formulas then I have all these options that are related to formulas within each tab I have these groups so for example I have function library group within formulas and it holds all these options that are related to function library similarly I have a find names group which hold all these options for defined names each of these groups are separated by vertical lines now there are different kind of options available in this ribbon there could be buttons that do something when you click on it so for example if I type one two three here and you can see this is a cell and I want to give a border through to the cell so I go to home and within home in the font group I have this option to give a border I select on it and it would give a border to this cell and this is the function of this button as soon as you select it it does something but there could also be toggle buttons which would do something and if you click on it again then it would undo itself so for example if I write one two three here and I go to home alignment and I click on Center alignment as soon as I click on it it makes my text or the number aligned to the center but it is a toggle button if I click on it again it would revert that so there could be options which does something when you click on it there could be options which are like a toggle button there are also dropdowns in this so for example I have this drop-down for formatting and here I can select a number format and as soon as I do this it gets changed and again I can have the drop-down and change this to something else another very useful feature in Excel is the quick access toolbar as I mentioned by default it has these three options the Save button the undo button and the redo button and you have a small arrow here and if you click on it you would get access to a lot more options so you can see there are many options here that I can add to the quick access toolbar as the name suggests this is very quick access that a user can get this is always available and you can click on it and it would do whatever that I can say so for example in this case it would undo whatever I have done if I click on it it would undo the formatting also you can see there are two options at the end of this drop-down which says more commands and show below the ribbon more commands has to do more with customizing this quick access toolbar where you can add more buttons I would show you later in this video how to do this but this is the option I am going to talk about which is show below the ribbon if you click on it this quick access toolbar gets displayed below the ribbon but there is no apparent reason I would want to do this because first of all this would require a lot more area in my worksheet and I would see one row less as compared to when this was at the top so for example have a look here I have row number 22 highlighted and when I select and will say show above the ribbon I have one more row visible so you can keep it here but if you want to put it down below the ribbon if you think that makes it easier for you to access options then you can use that option as well while we already have a lot of options available in the ribbon and tabs if you think that you would need more controls for a particular feature then there are two ways you can go about it first is the dialog box so for example if I am in the Home tab and I want to get more control over the font property then I can click on this dialogue box launcher and as soon as I click on it it opens the format cells dialog box this would have a lot more options as compared to the ribbon because this is the entire range of options that is available to a user to perform these actions within the format cells purview so for example if I want to talk about font and if I want to change anything these are all these options available to a user so one of the ways to get more control and more access access to more options is by using the dialog box and for each of these groups you can use this dialog box launcher these de stated arrow to display the dialog box another feature which has been used in 2013 is the task pane so for example if I go to insert and I insert a picture this picture and I want to play with this picture change it a bit I already have some options available but here but if I need more control I can right click and select format picture and as soon as I do this I have this task pane available earlier in 2010 or 2007 this would have been a dialog box but in this case in 2013 nothing changes except the fact that this task pane is available with one minor thing that this is available for the entire time you are doing in operations for example if I want to add say a shadow to this and while I am doing this this pain would be available so you do not need to click OK or do anything as soon as you make the selection it would be visible here so this gives you more control and more flexibility while working with options while a lot of options are already available using the tabs and ribbon in Excel not everything is there and you may want to add a few new functionalities to the ribbon or to the tab so let me show you how you can customize the ribbon right-click on any of the tabs go and right-click on any of the tab and you have this options where you see customize the ribbon click on this option and it opens the Excel options dialog box now on the left at the top you have these commands so it would say popular commands you can select all commands and this would display all these options that are available in Excel on the right you can see your existing your existing tab list so for example you see that I have home insert page and you can even go and edit these by their groups so for example if I have this Developer tab which is not as of knowledge is not visible I can glow go and select this and when I click OK this tab gets available and now I can see that there are a lot of options available within the Developer tab but if you want to say create your own tab then you can also do that right click again and click on customize the ribbon here select all commands and in the customize the ribbon option go and click on new tab and this would insert a new tab for you you can go and rename this tab so for example I say I want to name this Trump Excel favorites use the shorthand code and I click OK and now it has created a tab which says Trump Excel favorite now you can also go and create a new group so for example I rename this group and I can insert an icon if I want and I would say analysis and I click OK so now you can see that I have a tab which says Trump Excel favorite and I within that I have a group which says analysis and I would hit OK and as soon as I do that you can see I have Trump Excel favorite as one of the tab and within that I have these this group analysis now I can add icons to it I could again go to customize the and here within analysis I would select any of these commands so for example let me randomly select any of the command let&amp;#39;s say copy and I add and this gets added to the analysis group similarly I can add another options I&amp;#39;m randomly selecting any of these options and I click OK and as soon as I do this you can see that I have Trump Excel favorites and within analysis I have all these options so in case you want to create your own tab or there are some options which are either not available in the existing ribbon or you want to get together a set of options and put it in one group then you can use this customize the ribbon feature similarly you can also customize the quick access toolbar and this is really handy when you have to add options which you frequently use so for example I would show you just right click here and again go to customize quick access toolbar option it would again open the same excel option box but instead of your tabs and ribbon here now you see a list of quick access toolbar options again if you want to add anything say if I want to add cut or maybe Center so I usually keep alignment options here and I want to align Center then I would go click Add and hit OK and as soon as I do this I have this option here now wherever now whenever I have to Center a line of text I would just go and click on quick access toolbar because this would always be visible if I compare it to using it in the ribbon I would first have to go to Home tab and then go and select this option so it is really handy to add a few options in your quick access toolbar which for which you would always have access very quickly so this is how you can customize a ribbon or quick access toolbar to add options that you frequently use you would often hear the word active cell when you talk about excel and the concept is that at one point of time you can edit only one cell so for example if I want to type something here say I want to type from Excel I can only type this in one cell at a time I cannot type this at the same time in three cells so this is the concept of active cell that there would only be one cell that is active even if you have a range of cells available if you select all these cells even in this case there would only be one active cell and the address of this active cell is always visible in the name box so while I am selecting these cells you can see that in the name box it would show me how many rows and columns I am selecting but as soon as I am done selecting it would show me the address of the active cell so in this case F 4 is the active cell one last thing that I want to cover in this introductory video is how you can access the ribbon using the keyboard shortcuts as soon as you hit Alt key you can see that there are these alphabets that appear up at the tabs and in quick access toolbar so in quick access toolbar you have these numbers but in case of tabs you have these alphabets so here I have h4 home and now if I hit H I would have access to all these options and there are these alphabets again for these options so for example if I want to use the cut option then I can simply press X if I want to use the font color property then I can use FC so for example let me show you if I type shrimp XL here and I want to access the font color property I would hit alt H FC and as soon as I do this I would have these options available where I can use the keyboard shortcut to do this now this may look like a lot of effort but believe me when you start using keyboard shortcuts you would become much more efficient and fast in working with Excel that&amp;#39;s it in this video I hope you found this useful thank you and have a nice day

Transcript for:Introduction to Excel 2013 - Lecture Notes

Transcript for:
Introduction to Excel 2013 - Lecture Notes