1 00:00:00,05 --> 00:00:02,02 - [Instructor] Let's go over a quick rundown 2 00:00:02,02 --> 00:00:04,02 of all the elements that make up Excel 3 00:00:04,02 --> 00:00:06,05 and we'll start with a ribbon. 4 00:00:06,05 --> 00:00:09,04 The ribbon is a tabbed interface across all 5 00:00:09,04 --> 00:00:10,08 Microsoft products. 6 00:00:10,08 --> 00:00:11,07 Though the tabs change, 7 00:00:11,07 --> 00:00:13,06 depending on which product you're in. 8 00:00:13,06 --> 00:00:16,04 The most commonly used apps will be in this home tab 9 00:00:16,04 --> 00:00:18,04 and you'll notice that they're grouped 10 00:00:18,04 --> 00:00:21,02 by task down here at the bottom. 11 00:00:21,02 --> 00:00:24,00 You can change tabs depending on what you're looking for. 12 00:00:24,00 --> 00:00:26,09 However, if you can't find what you're looking for in any 13 00:00:26,09 --> 00:00:29,07 of these tabs, it's often quicker just to come up here 14 00:00:29,07 --> 00:00:31,09 to the search bar and type the task 15 00:00:31,09 --> 00:00:33,04 that you're trying to do. 16 00:00:33,04 --> 00:00:36,08 For example, merge cells. 17 00:00:36,08 --> 00:00:39,04 It's going to give me the best action 18 00:00:39,04 --> 00:00:42,09 and in fact, here's some more actions that I can do. 19 00:00:42,09 --> 00:00:44,05 These are the same icons 20 00:00:44,05 --> 00:00:48,09 and actions that are found right in the ribbon tabs. 21 00:00:48,09 --> 00:00:50,06 While you're navigating the ribbon, 22 00:00:50,06 --> 00:00:54,09 you might also see these arrows and they are everywhere. 23 00:00:54,09 --> 00:00:57,02 Anytime you see an arrow, you can click on it 24 00:00:57,02 --> 00:00:58,09 and it's going to give you some more things 25 00:00:58,09 --> 00:01:00,09 that you can do in that task. 26 00:01:00,09 --> 00:01:03,02 It's going to be the same across the ribbon. 27 00:01:03,02 --> 00:01:09,06 Here's some arrows and some more arrows even. 28 00:01:09,06 --> 00:01:14,00 The only exception to this tabbed interface is the file tab. 29 00:01:14,00 --> 00:01:16,04 If I click on that, this is where I go 30 00:01:16,04 --> 00:01:20,08 to create a brand new blank workbook or file. 31 00:01:20,08 --> 00:01:22,03 I can open an existing one 32 00:01:22,03 --> 00:01:25,02 or save the one I'm currently working on. 33 00:01:25,02 --> 00:01:27,09 To get back to Excel, click the arrow pointing 34 00:01:27,09 --> 00:01:31,01 to the left all the way on the top of the screen. 35 00:01:31,01 --> 00:01:33,07 Let's move to the bottom of the screen. 36 00:01:33,07 --> 00:01:37,03 Right now, I can see the currently selected worksheet 37 00:01:37,03 --> 00:01:40,09 and there may in fact be multiple worksheets in this file. 38 00:01:40,09 --> 00:01:44,07 That is this workbook. We'll be going over that. 39 00:01:44,07 --> 00:01:47,02 All the way on the bottom right hand side of the screen, 40 00:01:47,02 --> 00:01:52,02 I can use the plus and minus signs to zoom in or out. 41 00:01:52,02 --> 00:01:54,01 I can use the minus to zoom out. 42 00:01:54,01 --> 00:01:56,07 That is make the font smaller or zoom in. 43 00:01:56,07 --> 00:01:59,07 That is make it much larger. 44 00:01:59,07 --> 00:02:00,09 I'll be zooming in a lot so 45 00:02:00,09 --> 00:02:03,09 that you can see what's going on in the middle of the screen 46 00:02:03,09 --> 00:02:05,05 and speaking of the middle of the screen, 47 00:02:05,05 --> 00:02:07,03 let's move here right now. 48 00:02:07,03 --> 00:02:09,02 I can scroll all the way down 49 00:02:09,02 --> 00:02:12,08 and keep scrolling through all of these rows. 50 00:02:12,08 --> 00:02:16,03 At the very top the columns are all alphabetical 51 00:02:16,03 --> 00:02:18,07 while the rows are numerical. 52 00:02:18,07 --> 00:02:21,03 I can click inside any of these cells 53 00:02:21,03 --> 00:02:22,08 and the currently active cell 54 00:02:22,08 --> 00:02:25,03 that I'm in is going to be outlined in green. 55 00:02:25,03 --> 00:02:27,00 We'll be going over data types 56 00:02:27,00 --> 00:02:29,09 and I'll be talking about why sometimes the text aligns 57 00:02:29,09 --> 00:02:33,01 to the left and why sometimes it aligns to the right. 58 00:02:33,01 --> 00:02:35,00 You can format all of the text 59 00:02:35,00 --> 00:02:37,02 and we'll be going over how to do that. 60 00:02:37,02 --> 00:02:39,01 You can also click the column header 61 00:02:39,01 --> 00:02:41,01 to highlight the entire column, 62 00:02:41,01 --> 00:02:44,07 and you can click a number to highlight an entire row. 63 00:02:44,07 --> 00:02:47,07 You can also hover your mouse right in between the line 64 00:02:47,07 --> 00:02:51,09 and make it wider or more narrow. 65 00:02:51,09 --> 00:02:55,02 You can also do the same thing with columns. 66 00:02:55,02 --> 00:02:59,07 You can make them small or really large. 67 00:02:59,07 --> 00:03:01,01 The the last thing I want to show you 68 00:03:01,01 --> 00:03:04,06 that you can do is undo any change you make. 69 00:03:04,06 --> 00:03:06,07 Maybe I didn't mean to widen that column. 70 00:03:06,07 --> 00:03:09,04 It happens. This was a mistake. 71 00:03:09,04 --> 00:03:12,06 To undo it all the way in the very top left hand side 72 00:03:12,06 --> 00:03:13,05 of the screen. 73 00:03:13,05 --> 00:03:16,05 I can click this back arrow pointing to the left. 74 00:03:16,05 --> 00:03:18,08 This is the undo feature 75 00:03:18,08 --> 00:03:21,03 and I'll be using it a lot in Excel. 76 00:03:21,03 --> 00:03:24,00 If you click on it, it's going to undo the last action 77 00:03:24,00 --> 00:03:26,04 that you did and you can keep clicking on it 78 00:03:26,04 --> 00:03:28,08 to keep undoing your actions. 79 00:03:28,08 --> 00:03:32,01 You can undo up to 100 actions. 80 00:03:32,01 --> 00:03:35,05 In fact, if you go too far and undo the wrong thing, 81 00:03:35,05 --> 00:03:37,04 you can click the redo button, 82 00:03:37,04 --> 00:03:39,01 which is the arrow to the right of it. 83 00:03:39,01 --> 00:03:42,00 It's going to redo that last action, 84 00:03:42,00 --> 00:03:43,09 so when I'm showing you things in Excel, 85 00:03:43,09 --> 00:03:45,09 a lot of times you'll hear me say, 86 00:03:45,09 --> 00:03:48,04 that I'm going to undo that last action. 87 00:03:48,04 --> 00:03:49,06 That's all I'm doing. 88 00:03:49,06 --> 00:03:52,05 I'm clicking this arrow on the top left hand side. 89 00:03:52,05 --> 00:03:55,02 So that's the basic navigation of Excel. 90 00:03:55,02 --> 00:03:58,07 Most of the time you can stick to the Home ribbon tab 91 00:03:58,07 --> 00:04:00,09 to use your day-to-day functions. 92 00:04:00,09 --> 00:04:03,05 We'll be going through all sorts of things like how 93 00:04:03,05 --> 00:04:06,02 to format and edit text and even work 94 00:04:06,02 --> 00:04:08,00 with formulas and functions.