1 00:00:00,06 --> 00:00:02,04 - [Instructor] I've created a new blank file 2 00:00:02,04 --> 00:00:03,09 and I want to talk a little bit more 3 00:00:03,09 --> 00:00:05,08 about the structure of an Excel file 4 00:00:05,08 --> 00:00:07,09 and then I'll start entering some text. 5 00:00:07,09 --> 00:00:10,02 But the first thing I'm going to do is zoom in 6 00:00:10,02 --> 00:00:11,04 just so you can see what I'm doing 7 00:00:11,04 --> 00:00:12,08 a little bit more clearly. 8 00:00:12,08 --> 00:00:15,00 And I'll do that by clicking the plus sign 9 00:00:15,00 --> 00:00:17,07 all the way on the bottom right-hand side of the screen. 10 00:00:17,07 --> 00:00:20,08 I'll click it a few times to zoom in. 11 00:00:20,08 --> 00:00:23,06 Now, you're hearing me call this an Excel file 12 00:00:23,06 --> 00:00:25,08 and usually that's what you'll call it, 13 00:00:25,08 --> 00:00:28,07 but it is important to note that the technical term 14 00:00:28,07 --> 00:00:32,01 of what this really is is an Excel workbook. 15 00:00:32,01 --> 00:00:34,05 It's a workbook made up of sheets. 16 00:00:34,05 --> 00:00:36,06 That is, worksheets. 17 00:00:36,06 --> 00:00:39,00 Right now, this is Sheet 1 18 00:00:39,00 --> 00:00:41,05 all the way down at the bottom of the screen. 19 00:00:41,05 --> 00:00:45,05 I can input my data here and I can add multiple sheets. 20 00:00:45,05 --> 00:00:47,06 I'll click the plus sign to add a new sheet. 21 00:00:47,06 --> 00:00:48,09 And all of a sudden, 22 00:00:48,09 --> 00:00:51,01 we have a completely separate worksheet 23 00:00:51,01 --> 00:00:52,04 within this workbook. 24 00:00:52,04 --> 00:00:54,05 That is the Excel file. 25 00:00:54,05 --> 00:00:56,09 I can reference these sheets differently. 26 00:00:56,09 --> 00:00:58,07 I can put formulas on one 27 00:00:58,07 --> 00:01:01,04 that references a cell on a different sheet. 28 00:01:01,04 --> 00:01:03,09 I can use them all interchangeably, 29 00:01:03,09 --> 00:01:06,04 and we'll be going over that in detail. 30 00:01:06,04 --> 00:01:09,07 But you did need to know that this is a workbook. 31 00:01:09,07 --> 00:01:12,08 I will probably go back to calling it a file, however, 32 00:01:12,08 --> 00:01:13,09 because like I said, 33 00:01:13,09 --> 00:01:16,06 that's what you are going to be calling it most of the time. 34 00:01:16,06 --> 00:01:19,01 The two terms can be used interchangeably, 35 00:01:19,01 --> 00:01:22,00 but officially it's a workbook. 36 00:01:22,00 --> 00:01:24,05 All right, so now that we have our file open, 37 00:01:24,05 --> 00:01:27,03 let's start populating it with some basic text 38 00:01:27,03 --> 00:01:29,04 and fill out some columns and rows. 39 00:01:29,04 --> 00:01:32,09 I'm going to be putting in some sales data for our products 40 00:01:32,09 --> 00:01:36,04 for our fictional company, Red 30 Tech. 41 00:01:36,04 --> 00:01:40,00 To get started, I could put my cursor in any cell 42 00:01:40,00 --> 00:01:43,04 by clicking directly on it. 43 00:01:43,04 --> 00:01:47,03 Right now, I'm in column F row eight, 44 00:01:47,03 --> 00:01:50,00 so this is cell F8. 45 00:01:50,00 --> 00:01:53,03 And if I look, if I'm ever lost and don't know where I am, 46 00:01:53,03 --> 00:01:56,05 if I lose track of this green outlined cell, 47 00:01:56,05 --> 00:01:59,00 all the way on the top left-hand side of the screen 48 00:01:59,00 --> 00:02:04,01 in the name box, I can see that this is indeed cell F8. 49 00:02:04,01 --> 00:02:08,00 For now, I'm going to put my cursor in cell A2 50 00:02:08,00 --> 00:02:13,04 and start typing. 51 00:02:13,04 --> 00:02:16,01 I will hit the Enter key to move the cursor to the next row, 52 00:02:16,01 --> 00:02:22,00 and now I can continue typing. 53 00:02:22,00 --> 00:02:24,04 Okay, now I've got some products populated. 54 00:02:24,04 --> 00:02:28,01 Now I can start filling in my column headers. 55 00:02:28,01 --> 00:02:30,03 Now, the data that I have in column A 56 00:02:30,03 --> 00:02:32,07 is taking up some of column B. 57 00:02:32,07 --> 00:02:35,09 It's not in column B, it's just too long 58 00:02:35,09 --> 00:02:39,02 and I can't see the contents of column B. 59 00:02:39,02 --> 00:02:42,03 We'll be going over how to resize these officially later. 60 00:02:42,03 --> 00:02:44,04 But for now, I'm going to hover my mouse 61 00:02:44,04 --> 00:02:47,05 right in between column A and column B 62 00:02:47,05 --> 00:02:50,04 and slide the mouse over. 63 00:02:50,04 --> 00:02:54,03 Now I have a clear line of sight to column B. 64 00:02:54,03 --> 00:02:58,08 I'll put my cursor inside cell B1 and start typing. 65 00:02:58,08 --> 00:03:01,04 This time, instead of hitting the Enter key, 66 00:03:01,04 --> 00:03:03,00 which would move me onto a new row, 67 00:03:03,00 --> 00:03:04,07 I'm going to hit the Tab key, 68 00:03:04,07 --> 00:03:12,07 which will move me to the next column. 69 00:03:12,07 --> 00:03:14,01 Now I've got some data 70 00:03:14,01 --> 00:03:15,06 and the last thing I could do 71 00:03:15,06 --> 00:03:21,02 is put in a title if I wanted to. 72 00:03:21,02 --> 00:03:24,05 Now we're ready to populate this with our sales data. 73 00:03:24,05 --> 00:03:26,02 And up next, I'm going to show you 74 00:03:26,02 --> 00:03:29,00 how to format this text for readability.