1 00:00:04,470 --> 00:00:08,830 In this section I'll give you a quick tour of Excel so you get familiar with the terms that 2 00:00:08,970 --> 00:00:16,000 we are going to be using throughout the course and also get you feeling comfortable using the program. Let's jump in. 3 00:00:16,000 --> 00:00:21,750 The Excel program or Excel app is also sometimes referred to as a spreadsheet program. 4 00:00:21,750 --> 00:00:28,320 When you open Excel, you get to decide if you want a blank workbook, if you want to open one of Excel's 5 00:00:28,380 --> 00:00:35,010 existing templates or if you've already opened other files and saved other files in Excel, you get them 6 00:00:35,010 --> 00:00:38,860 listed under your Recent tab here. 7 00:00:38,910 --> 00:00:44,820 Under New, you also get a chance to open a blank workbook and you can select from existing templates. So, whenever 8 00:00:44,820 --> 00:00:50,130 you get a chance, have a look at the type of templates you have available here. 9 00:00:50,160 --> 00:00:53,230 These are also going to give you some design ideas. 10 00:00:53,370 --> 00:00:59,460 If you don't find what you're looking for here, you can search for online templates directly from here. 11 00:00:59,460 --> 00:01:04,420 If you go to open, you get the list of your recently used workbooks. 12 00:01:04,440 --> 00:01:11,310 You also get a list of your recently visited folders and if you don't find what you're looking for here. 13 00:01:11,310 --> 00:01:14,990 So you're looking for a file that you saved but you don't find it here. 14 00:01:15,000 --> 00:01:16,610 You can browse for it. 15 00:01:16,620 --> 00:01:20,810 This takes you through your directory, find a file and click on Open. 16 00:01:20,850 --> 00:01:24,530 In this case we're just going to go and open a blank workbook. 17 00:01:24,690 --> 00:01:32,420 Once you do that you get a new file created for you. An Excel file is also called a workbook. 18 00:01:32,430 --> 00:01:36,680 Now this workbook is not saved until you decide to do so. 19 00:01:36,960 --> 00:01:44,000 The workbook consists of at least one sheet which is generally called a worksheet or a spreadsheet. 20 00:01:44,010 --> 00:01:47,550 So think of it as a book and different sheets in that book. 21 00:01:47,550 --> 00:01:51,950 You can add more sheets to the book by clicking the plus sign here. 22 00:01:51,960 --> 00:01:53,510 You can also rename the sheets. 23 00:01:53,520 --> 00:01:54,900 Just double click. 24 00:01:54,900 --> 00:02:01,100 Start typing and press enter. A sheet contains many cells. 25 00:02:01,110 --> 00:02:08,880 So this box here is a single cell. You can input numbers here to start typing and press enter. 26 00:02:09,030 --> 00:02:14,880 You can input text here and you can input formulas here. If you want to replace something that's already 27 00:02:14,880 --> 00:02:16,040 been typed in. 28 00:02:16,110 --> 00:02:17,620 You don't have to delete it. 29 00:02:17,790 --> 00:02:20,030 You can just start directly typing. 30 00:02:20,400 --> 00:02:23,120 Each cell has an address. 31 00:02:23,160 --> 00:02:25,230 This is used to create formulas. 32 00:02:25,800 --> 00:02:28,860 So what do you think the address of this cell is? 33 00:02:28,930 --> 00:02:37,110 It's C3, which means Column C, row three. The intersection of a column and a row is a cell. 34 00:02:37,110 --> 00:02:42,890 So notice that Excel uses alphabet for the column headers and numbers for rows. 35 00:02:43,590 --> 00:02:46,020 How many rows and columns does Excel have? 36 00:02:46,410 --> 00:02:52,400 Well, it has over 16,000 columns and over a million rows. 37 00:02:52,530 --> 00:02:57,240 We can actually see it if we jump to the last cell on the spreadsheet. 38 00:02:57,480 --> 00:03:02,560 We can use a shortcut key for that, click on Control and the right arrow key. 39 00:03:02,580 --> 00:03:08,320 This takes you to the last column on your sheet. If you want to jump down to the last row. 40 00:03:08,430 --> 00:03:11,340 Use Control and the down arrow key. 41 00:03:11,400 --> 00:03:13,390 This takes you to the last cell on the spreadsheet. 42 00:03:13,500 --> 00:03:16,200 To jump back to A1. 43 00:03:16,230 --> 00:03:19,260 So, the first cell on the spreadsheet, use the shortcut key 44 00:03:19,260 --> 00:03:21,790 Control+Home. 45 00:03:21,930 --> 00:03:24,130 Up here, you have the formula bar. 46 00:03:24,240 --> 00:03:30,400 So once you input text you can actually see it basically whatever is in this active cell. 47 00:03:30,480 --> 00:03:32,810 You can see it inside the formula bar. 48 00:03:33,450 --> 00:03:37,500 If you had a formula you can see the formula in the formula bar. 49 00:03:37,500 --> 00:03:44,790 So for example, here in cell E3, I'm going to start with the equal sign and I'm just going to reference 50 00:03:44,940 --> 00:03:47,820 this cell C3. So, I'm just gonna click on C3. 51 00:03:47,820 --> 00:03:50,040 This is a reference formula. 52 00:03:50,040 --> 00:03:56,990 When I press Enter, I get back the value in C3 but notice when I click on the cell. 53 00:03:57,000 --> 00:03:59,190 What do you see in the formula bar? 54 00:03:59,310 --> 00:04:00,990 You see the formula behind it. 55 00:04:00,990 --> 00:04:04,080 You don't actually see what we see in the cell. 56 00:04:04,320 --> 00:04:07,800 In this case for cell C3 there is no formula behind it. 57 00:04:08,070 --> 00:04:14,470 So we actually see what we typed in in the formula bar. Up here on the left hand side. 58 00:04:14,640 --> 00:04:17,339 This box here is called the name box. 59 00:04:17,339 --> 00:04:21,370 This shows us the cell address of the active cell. 60 00:04:21,390 --> 00:04:27,180 So here if I go to E3 in the formula bar I see the formula. In the name box 61 00:04:27,180 --> 00:04:29,060 I see the cell address. 62 00:04:29,100 --> 00:04:34,920 Now here's a quick tip for you. If you are cruising around a large spreadsheet and you want to jump to 63 00:04:34,920 --> 00:04:39,410 a specific cell you can type the address directly in the name box. 64 00:04:39,720 --> 00:04:43,080 So let's say I wanted to jump to A1000. 65 00:04:43,170 --> 00:04:49,990 Just type it in pres enter and A1000 is found here. To jump back to cell A1. 66 00:04:50,040 --> 00:04:54,180 What was the shortcut key for that? Control+Home. 67 00:04:54,410 --> 00:05:02,260 Okay, so far we took a look at what a sheet is, what a cell is, what a column, and what a row is. 68 00:05:02,270 --> 00:05:07,430 Now let's take a look at what a range is. A range is a group of cells. 69 00:05:07,880 --> 00:05:12,200 So here I'm going to just click on the cell and drag the selection. 70 00:05:12,200 --> 00:05:14,200 This is a range of cells. 71 00:05:14,210 --> 00:05:16,400 What's the address of this range? 72 00:05:16,430 --> 00:05:19,870 It's C3 to D6. 73 00:05:19,880 --> 00:05:26,300 So basically the address of the range is defined by the cell address of the top left hand cell to the 74 00:05:26,300 --> 00:05:30,450 cell address that's on the bottom right hand side of the range. 75 00:05:30,450 --> 00:05:34,050 Now let's take a look at the different mouse icons that we have. 76 00:05:34,060 --> 00:05:36,650 So this standard mouse icon here. 77 00:05:36,650 --> 00:05:38,720 That's called the selection handle. 78 00:05:38,840 --> 00:05:44,720 When I move to the side of the cells, so to the border notice that icon changes. 79 00:05:44,720 --> 00:05:46,700 That's called the move handle. 80 00:05:46,730 --> 00:05:53,360 So if I click when I'm on the edge of the cell and I drag this, that drags the cell value to another 81 00:05:53,360 --> 00:05:53,690 cell. 82 00:05:53,690 --> 00:05:56,420 So it's similar to cutting and pasting. 83 00:05:56,870 --> 00:06:02,560 And you can use the shortcut key Control+X to cut and Control+V to paste. 84 00:06:02,570 --> 00:06:08,240 There is another type of handle and that's if you go to the bottom right hand corner of the cell. 85 00:06:08,240 --> 00:06:09,810 You get this thick cross. 86 00:06:09,980 --> 00:06:12,060 That's called the fill handle. 87 00:06:12,110 --> 00:06:17,160 If I click and drag this, this is going to copy the values down 88 00:06:17,240 --> 00:06:21,430 and if you have formulas it's going to copy the formula down. 89 00:06:21,560 --> 00:06:24,980 Cells have a default size but you can change them. 90 00:06:24,980 --> 00:06:29,310 So for example, if my text was longer it runs over to the next cell. 91 00:06:29,330 --> 00:06:35,690 The value though is sitting in this cell, the other cell has no values so look up to the formula bar. 92 00:06:35,690 --> 00:06:39,570 You don't see anything there. For me to get this to fit in one cell. 93 00:06:39,580 --> 00:06:41,000 I have different options. 94 00:06:41,150 --> 00:06:46,640 I can click on the border between the columns and I can drag this to make the column wider. 95 00:06:46,970 --> 00:06:48,650 I can also auto fit it. 96 00:06:48,680 --> 00:06:56,240 So if I just double click it's going to auto fit the column width so it matches the longest text. 97 00:06:56,240 --> 00:06:57,990 Now let's say this is too wide for me. 98 00:06:58,010 --> 00:07:00,670 I actually want my column to be like this. 99 00:07:01,160 --> 00:07:08,150 And I'm going to expand the row but the value doesn't wrap. For me to get this to fit in this cell. 100 00:07:08,300 --> 00:07:15,680 I can use Wrap Text up here and then you can double click on the border of your row to make it auto fit. 101 00:07:15,680 --> 00:07:18,020 Wrap text is a toggle. 102 00:07:18,020 --> 00:07:24,950 So, if I click it again it takes it away. Click it again, it puts it back. You'll also find a lot of widely 103 00:07:24,950 --> 00:07:27,520 used options when you right-mouse click. 104 00:07:27,530 --> 00:07:34,310 So if I right mouse click on a cell I get to insert a cell, delete a cell, or just clear its contents. 105 00:07:34,310 --> 00:07:40,070 I get to also format cells. A a lot of these we're going to look in detail throughout the course. 106 00:07:40,450 --> 00:07:45,670 And I also encourage you to play around with them to see the different options you have. 107 00:07:45,890 --> 00:07:51,550 If instead I right-mouse click in a column here I get to insert a column, I can delete a column. 108 00:07:51,560 --> 00:07:52,570 So let's just try it. 109 00:07:52,760 --> 00:07:54,100 Let's insert a column. 110 00:07:54,710 --> 00:07:56,430 I can also do it for rows. 111 00:07:56,510 --> 00:07:59,980 I can just select one row or drag my selection down. 112 00:08:00,010 --> 00:08:05,840 Select two rows, right mouse click, and insert two rows. 113 00:08:06,170 --> 00:08:12,230 Down here, I have the ability to zoom in on the cells or zoom out. You can click the plus or click the minus 114 00:08:12,500 --> 00:08:13,790 to zoom in with your mouse. 115 00:08:13,790 --> 00:08:21,770 Just hold down the control key and use the mouse wheel. To save this workbook, hit save from up here or 116 00:08:21,920 --> 00:08:25,900 use the shortcut key control+S and save it on your drive. 117 00:08:26,030 --> 00:08:30,190 If you have Office 365 you can then use auto save. 118 00:08:30,200 --> 00:08:35,220 This way you don't have to always think about hitting that save button. 119 00:08:35,240 --> 00:08:38,419 In the next lecture I'm going to give you a quick tour of the Excel ribbon.