Excel Essentials for Business

Excel user interface and key foundational features 7 lectures 34:31 Take charge of Excel First of all, we need to get familiar with the user interface of Excel, where things are and what we call them. Navigating and selecting in Excel It's important that we can navigate confidently but also efficiently around the Excel user interface. So, you may be kind of getting around, but let's look at some of the quicker ways of doing that and also selecting data. Use and change view options in Excel Let's take a look at how we can use and change view options, such as zoom in, zoom out, free panes, etc. Data Entry, Editing and Deleting data in Excel Are you ready to create your own worksheet? What about editting it correctly? Let's learn how to do those things today. Using Fill Handle in Excel Have you ever heard of the Fill Handle, one of the most useful tools in Excel? Let's take a look at it today. All about Copy, Cut and Paste Options in Excel Do you know how to copy, cut, and paste data across Excel and to other programs? Let's talk about it in this lesson. Essential shortcuts in Excel Using shortcuts could help you work faster and mor efficiently with Excel. I have put together some of the most commonly used ones that every Excel user should know and use every day. Please read, learn, and practice using them as much as possible. If a shortcut requires pressing two or more keys at the same time, keys are separated by a + sign. An exhaustive list of shortcuts is available on the Microsoft Office Support pages. For a list of Mac specific keyboard shortcuts see the Microsoft Office ( for Mac) Support page.Undo/RedoPossibly some of the most frequently used keyboard shortcuts ever are CTRL+Z and CTRL+Y | CMD+Z or CMD+Y. Z stands for undo and Y for redo. Both operate on multiple levels, meaning that you can go back in time a long way. As always there are of course exceptions to the rule and some actions cannot be undone. In some of these cases, Excel will give you a warning (e.g., deleting a worksheet that has content in it, cannot be undone and Excel will warn you about this) and then there are other events that you cannot undo and no warning message is displayed (e.g. using the 'Move Chart' tool - more on this in Week 6.CTRL-Y will redo your most recent action which comes in really handy if/when you want to apply a certain step more than once.New File/ New WorkbookTo create a new workbook or new file, you do not need to go into any menu's. You can simply press: CTRL+N | CMD+N Open file / Open WorkbookTo open the dialogue box and select an existing file (workbook) you can use the shortcut: CTRL+O | CMD+O Close file / Close WorkbookTo close your current Workbook, you can click on the 'x' located at the top right (Windows) or top left (Mac), But as shortcut keys are sometimes quicker, you can press: CTRL+W | CMD+W Save file / Save WorkbookSaving your work regularly should become second nature. This shortcut will help. If you haven't saved your file beforehand, Excel will ask you to assign a name and storage location to your file. If you have, this shortcut will quickly save your file. CTRL+S | CMD+S Select allThe select all shortcut actually behaves differently based on context. If you are in an empty cell and select all, you will select the entire worksheet. If the active cell contains data that is part of a group (cells containing contiguous data) select all will just select the group of cells instead. You can press it again to select the entire worksheet. The shortcut for select all is: CTRL+A | CMD+A) Enter a new line of TextSometimes when entering data into a cell, you may want to go to a new line below your current one, within the same cell. Rather than let Excel choose when this happens you can use this key press combination to force this behaviour. When editing a cell, press: ALT + Enter Moving around the worksheetYou can use the arrow keys to move a single cell in any direction. Page Up and Page Down will move one "page" (the number of rows shown on the screen) up or down. CTRL+arrow keys will move to the next blank cell in that direction. If you have a large dataset with no gaps this will move to the edges of the dataset. CTRL+Home takes you to the first cell that contains data in the top-left corner of the sheet. CTRL+End goes to the last cell in the bottom-right. On certain keyboards without a Home key, you might need to use CTRL+Fn+Home to use this shortcut.Hide and Unhide Columns and RowsOne of the amazing features of Excel is the sheer endless number of rows and columns. However, sometimes they add to the confusion more than they help. You can hide the ones you don't need. Here is how: Select the first column you don't need to see and then press the keyboard shortcut CTRL+SHIFT+right arrow (for Mac use Command+Shift+right arrow). Right-click anywhere in this new selection and select Hide. Select the first row you don't need to see and then press the keyboard shortcut CTRL+SHIFT+down arrow (for Mac use Command+Shift+down arrow). Right-click anywhere in this new selection and select Hide. Just in case you want them back, select the last visible row and drag down into the hidden area, or the last visible column and drag right, and click on Unhide. Everything is back to the way it was. Using the keyboard can make your work faster and smoother. That is all for today, guys. Thank you again for choosing my course. I will see you in the next lessons. Excel user interface and key foundational features. 7 lectures 34:31 Take charge of Excel First of all, we need to get familiar with the user interface of Excel, where things are and what we call them. Navigating and selecting in Excel It's important that we can navigate confidently but also efficiently around the Excel user interface. So, you may be kind of getting around, but let's look at some of the quicker ways of doing that and also selecting data. Use and change view options in Excel Let's take a look at how we can use and change view options, such as zoom in, zoom out, free panes, etc. Data Entry, Editing and Deleting data in Excel Are you ready to create your own worksheet? What about editting it correctly? Let's learn how to do those things today. Using Fill Handle in Excel Have you ever heard of the Fill Handle, one of the most useful tools in Excel? Let's take a look at it today. All about Copy, Cut and Paste Options in Excel Do you know how to copy, cut, and paste data across Excel and to other programs? Let's talk about it in this lesson. Essential shortcuts in Excel Using shortcuts could help you work faster and mor efficiently with Excel. I have put together some of the most commonly used ones that every Excel user should know and use every day. Please read, learn, and practice using them as much as possible. If a shortcut requires pressing two or more keys at the same time, keys are separated by a + sign. An exhaustive list of shortcuts is available on the Microsoft Office Support pages. For a list of Mac specific keyboard shortcuts see the Microsoft Office ( for Mac) Support page.Undo/RedoPossibly some of the most frequently used keyboard shortcuts ever are CTRL+Z and CTRL+Y | CMD+Z or CMD+Y. Z stands for undo and Y for redo. Both operate on multiple levels, meaning that you can go back in time a long way. As always there are of course exceptions to the rule and some actions cannot be undone. In some of these cases, Excel will give you a warning (e.g., deleting a worksheet that has content in it, cannot be undone and Excel will warn you about this) and then there are other events that you cannot undo and no warning message is displayed (e.g. using the 'Move Chart' tool - more on this in Week 6.CTRL-Y will redo your most recent action which comes in really handy if/when you want to apply a certain step more than once.New File/ New WorkbookTo create a new workbook or new file, you do not need to go into any menu's. You can simply press: CTRL+N | CMD+N Open file / Open WorkbookTo open the dialogue box and select an existing file (workbook) you can use the shortcut: CTRL+O | CMD+O Close file / Close WorkbookTo close your current Workbook, you can click on the 'x' located at the top right (Windows) or top left (Mac), But as shortcut keys are sometimes quicker, you can press: CTRL+W | CMD+W Save file / Save WorkbookSaving your work regularly should become second nature. This shortcut will help. If you haven't saved your file beforehand, Excel will ask you to assign a name and storage location to your file. If you have, this shortcut will quickly save your file. CTRL+S | CMD+S Select allThe select all shortcut actually behaves differently based on context. If you are in an empty cell and select all, you will select the entire worksheet. If the active cell contains data that is part of a group (cells containing contiguous data) select all will just select the group of cells instead. You can press it again to select the entire worksheet. The shortcut for select all is: CTRL+A | CMD+A) Enter a new line of TextSometimes when entering data into a cell, you may want to go to a new line below your current one, within the same cell. Rather than let Excel choose when this happens you can use this key press combination to force this behaviour. When editing a cell, press: ALT + Enter Moving around the worksheetYou can use the arrow keys to move a single cell in any direction. Page Up and Page Down will move one "page" (the number of rows shown on the screen) up or down. CTRL+arrow keys will move to the next blank cell in that direction. If you have a large dataset with no gaps this will move to the edges of the dataset. CTRL+Home takes you to the first cell that contains data in the top-left corner of the sheet. CTRL+End goes to the last cell in the bottom-right. On certain keyboards without a Home key, you might need to use CTRL+Fn+Home to use this shortcut.Hide and Unhide Columns and RowsOne of the amazing features of Excel is the sheer endless number of rows and columns. However, sometimes they add to the confusion more than they help. You can hide the ones you don't need. Here is how: Select the first column you don't need to see and then press the keyboard shortcut CTRL+SHIFT+right arrow (for Mac use Command+Shift+right arrow). Right-click anywhere in this new selection and select Hide. Select the first row you don't need to see and then press the keyboard shortcut CTRL+SHIFT+down arrow (for Mac use Command+Shift+down arrow). Right-click anywhere in this new selection and select Hide. Just in case you want them back, select the last visible row and drag down into the hidden area, or the last visible column and drag right, and click on Unhide. Everything is back to the way it was. Using the keyboard can make your work faster and smoother. That is all for today, guys. Thank you again for choosing my course. I will see you in the next lessons. Take charge of Excel First of all, we need to get familiar with the user interface of Excel, where things are and what we call them. Take charge of Excel First of all, we need to get familiar with the user interface of Excel, where things are and what we call them. Take charge of Excel First of all, we need to get familiar with the user interface of Excel, where things are and what we call them. Take charge of Excel First of all, we need to get familiar with the user interface of Excel, where things are and what we call them. First of all, we need to get familiar with the user interface of Excel, where things are and what we call them. First of all, we need to get familiar with the user interface of Excel, where things are and what we call them. Navigating and selecting in Excel It's important that we can navigate confidently but also efficiently around the Excel user interface. So, you may be kind of getting around, but let's look at some of the quicker ways of doing that and also selecting data. Navigating and selecting in Excel It's important that we can navigate confidently but also efficiently around the Excel user interface. So, you may be kind of getting around, but let's look at some of the quicker ways of doing that and also selecting data. Navigating and selecting in Excel It's important that we can navigate confidently but also efficiently around the Excel user interface. So, you may be kind of getting around, but let's look at some of the quicker ways of doing that and also selecting data. Navigating and selecting in Excel It's important that we can navigate confidently but also efficiently around the Excel user interface. So, you may be kind of getting around, but let's look at some of the quicker ways of doing that and also selecting data. It's important that we can navigate confidently but also efficiently around the Excel user interface. So, you may be kind of getting around, but let's look at some of the quicker ways of doing that and also selecting data. It's important that we can navigate confidently but also efficiently around the Excel user interface. So, you may be kind of getting around, but let's look at some of the quicker ways of doing that and also selecting data. Use and change view options in Excel Let's take a look at how we can use and change view options, such as zoom in, zoom out, free panes, etc. Use and change view options in Excel Let's take a look at how we can use and change view options, such as zoom in, zoom out, free panes, etc. Use and change view options in Excel Let's take a look at how we can use and change view options, such as zoom in, zoom out, free panes, etc. Use and change view options in Excel Let's take a look at how we can use and change view options, such as zoom in, zoom out, free panes, etc. Let's take a look at how we can use and change view options, such as zoom in, zoom out, free panes, etc. Let's take a look at how we can use and change view options, such as zoom in, zoom out, free panes, etc. Data Entry, Editing and Deleting data in Excel Are you ready to create your own worksheet? What about editting it correctly? Let's learn how to do those things today. Data Entry, Editing and Deleting data in Excel Are you ready to create your own worksheet? What about editting it correctly? Let's learn how to do those things today. Data Entry, Editing and Deleting data in Excel Are you ready to create your own worksheet? What about editting it correctly? Let's learn how to do those things today. Data Entry, Editing and Deleting data in Excel Are you ready to create your own worksheet? What about editting it correctly? Let's learn how to do those things today. Are you ready to create your own worksheet? What about editting it correctly? Let's learn how to do those things today. Are you ready to create your own worksheet? What about editting it correctly? Let's learn how to do those things today. Using Fill Handle in Excel Have you ever heard of the Fill Handle, one of the most useful tools in Excel? Let's take a look at it today e row and drag down into the hidden area, or the last visible column and drag right, and click on Unhide. Everything is back to the way it was. Using the keyboard can make your work faster and smoother. That is all...