1 00:00:00,000 --> 00:00:00,499 2 00:00:00,499 --> 00:00:05,780 Welcome to Office 2016, video number one. 3 00:00:05,780 --> 00:00:09,020 This is going to be an introduction to Office 2016 4 00:00:09,020 --> 00:00:12,860 and the ever important Windows Explorer. 5 00:00:12,860 --> 00:00:16,850 Now this is a high-line college business class. 6 00:00:16,850 --> 00:00:19,460 The official name is Business 216, 7 00:00:19,460 --> 00:00:22,730 and the title in the catalog is "Computer Applications 8 00:00:22,730 --> 00:00:23,960 for Business." 9 00:00:23,960 --> 00:00:28,460 I like to call it fun, and power with computers. 10 00:00:28,460 --> 00:00:31,230 Now as we talked about in the introductory video, 11 00:00:31,230 --> 00:00:33,230 we're going to cover these five programs, 12 00:00:33,230 --> 00:00:37,000 and here are the percentages for each one of the programs. 13 00:00:37,000 --> 00:00:40,040 Now, why are we going to spend so much time in Excel? 14 00:00:40,040 --> 00:00:42,020 Because in the business world, this 15 00:00:42,020 --> 00:00:45,910 is the number one program used. 16 00:00:45,910 --> 00:00:47,930 Now we're going to start out in this video, just 17 00:00:47,930 --> 00:00:49,910 an introduction to the operating system, 18 00:00:49,910 --> 00:00:52,340 and a little bit about Windows Explorer, 19 00:00:52,340 --> 00:00:55,640 and open up each one of these and talk about the ribbons, 20 00:00:55,640 --> 00:00:57,920 and the quack's, and things like that. 21 00:00:57,920 --> 00:01:02,810 Now Windows Explorer, we use it to manage files and folders. 22 00:01:02,810 --> 00:01:05,420 Word, we use it to create documents 23 00:01:05,420 --> 00:01:07,340 with words, formatting, and pictures 24 00:01:07,340 --> 00:01:10,280 like flyers, business letters, and research papers. 25 00:01:10,280 --> 00:01:11,945 PowerPoint, we create presentations 26 00:01:11,945 --> 00:01:15,620 with words, images, design movement, and sound 27 00:01:15,620 --> 00:01:17,830 to articulate some message. 28 00:01:17,830 --> 00:01:22,430 Excel, we can store data, make calculations, perform 29 00:01:22,430 --> 00:01:25,670 data analysis, and make charts. 30 00:01:25,670 --> 00:01:28,010 And Access, that's a proper database where 31 00:01:28,010 --> 00:01:30,170 we store data in related tables, and create 32 00:01:30,170 --> 00:01:34,670 information and reports from raw data using queries. 33 00:01:34,670 --> 00:01:37,790 You may not know what much of this means right now, 34 00:01:37,790 --> 00:01:40,460 but by the end of the class you will 35 00:01:40,460 --> 00:01:45,470 know about the power, and fun of each one of these programs 36 00:01:45,470 --> 00:01:47,690 to make our jobs easy. 37 00:01:47,690 --> 00:01:50,520 Now I'm going to close this file, this is the title bar. 38 00:01:50,520 --> 00:01:53,990 Here's the X up on the titlebar, I'm going to close that. 39 00:01:53,990 --> 00:01:56,470 Now as we talked about in the introductory video 40 00:01:56,470 --> 00:02:01,220 at our class, people.highline website, 41 00:02:01,220 --> 00:02:04,027 there will be class video projects. 42 00:02:04,027 --> 00:02:05,610 And sometimes it will be a start file, 43 00:02:05,610 --> 00:02:08,330 finish file, a hand-out, assigned homework, and maybe 44 00:02:08,330 --> 00:02:09,507 even some other things. 45 00:02:09,507 --> 00:02:11,090 For this video, there's none of those. 46 00:02:11,090 --> 00:02:14,600 The only thing that you want to download is this PDF. 47 00:02:14,600 --> 00:02:17,270 This has all the notes and details 48 00:02:17,270 --> 00:02:19,700 about what you saw in the video. 49 00:02:19,700 --> 00:02:22,400 You can clearly see there's no link for the video 50 00:02:22,400 --> 00:02:26,450 yet because I'm filming the first video right now. 51 00:02:26,450 --> 00:02:28,130 Now this is a browser so I'm going 52 00:02:28,130 --> 00:02:32,515 to come up in the title bar and close this using the X. 53 00:02:32,515 --> 00:02:34,250 Hey, now the very first thing since we're 54 00:02:34,250 --> 00:02:36,590 going to start at zero in this class is, hey, 55 00:02:36,590 --> 00:02:38,270 this is a desktop. 56 00:02:38,270 --> 00:02:41,330 Down below the desktop is the taskbar. 57 00:02:41,330 --> 00:02:48,230 Now notice we have icons to open Excel, Word, Windows Explorer, 58 00:02:48,230 --> 00:02:49,160 Access. 59 00:02:49,160 --> 00:02:51,620 We're missing the one for PowerPoint, 60 00:02:51,620 --> 00:02:54,240 but I'll show you how to add that in just a second. 61 00:02:54,240 --> 00:02:58,310 Now wait a second, your operating system 62 00:02:58,310 --> 00:03:00,500 may be different than the one I'm using. 63 00:03:00,500 --> 00:03:04,130 I'm using the operating system Windows 7. 64 00:03:04,130 --> 00:03:07,370 You might have Windows 10, or even Windows 8. 65 00:03:07,370 --> 00:03:10,780 Now in 7 and 10, at the end of the taskbar, 66 00:03:10,780 --> 00:03:12,890 we see the Start button. 67 00:03:12,890 --> 00:03:16,400 If you're in Windows 8, you do not see the Start button. 68 00:03:16,400 --> 00:03:20,040 So in 7 and 10, I click on this. 69 00:03:20,040 --> 00:03:21,950 I can type anything I want here. 70 00:03:21,950 --> 00:03:27,614 Like I can type Excel to find the Excel program I want. 71 00:03:27,614 --> 00:03:29,030 Now if you're using Windows 8, you 72 00:03:29,030 --> 00:03:32,390 have to get to the title screen. 73 00:03:32,390 --> 00:03:36,500 Now we're going to learn our first keyboard in this class, 74 00:03:36,500 --> 00:03:39,800 and we're going to use keyboards throughout the entire class 75 00:03:39,800 --> 00:03:42,350 because they are fast. 76 00:03:42,350 --> 00:03:45,230 You got to look all on your keyboard. 77 00:03:45,230 --> 00:03:50,570 On the left side between Control and Alt, there is a Window key, 78 00:03:50,570 --> 00:03:52,560 and we're going to use this key a lot. 79 00:03:52,560 --> 00:03:55,640 But this one all we do is hit the Window key, just 80 00:03:55,640 --> 00:03:56,820 hit it once. 81 00:03:56,820 --> 00:03:59,690 And look at that, it opens up the Start menu, 82 00:03:59,690 --> 00:04:01,220 and we could start typing. 83 00:04:01,220 --> 00:04:04,700 If you're in Windows 8 when you hit the window key, 84 00:04:04,700 --> 00:04:07,440 it opens up the tile screen. 85 00:04:07,440 --> 00:04:10,250 And you can do the same thing, you can simply 86 00:04:10,250 --> 00:04:13,010 type whatever it is you're searching for, 87 00:04:13,010 --> 00:04:14,760 and it will show up. 88 00:04:14,760 --> 00:04:16,220 Now I'm going to click escape here. 89 00:04:16,220 --> 00:04:20,709 The taskbar shows up at the bottom of our desktop, 90 00:04:20,709 --> 00:04:24,930 or all of our windows, in any one of the operating systems. 91 00:04:24,930 --> 00:04:29,390 Now remember, we didn't have a PowerPoint icon, 92 00:04:29,390 --> 00:04:33,140 which would open up PowerPoint so we want to see how 93 00:04:33,140 --> 00:04:36,110 to add a button to our taskbar. 94 00:04:36,110 --> 00:04:39,290 We can simply hit the Window key, 95 00:04:39,290 --> 00:04:44,510 and down in the search area I'm going to type, power. 96 00:04:44,510 --> 00:04:46,370 And there it is, PowerPoint. 97 00:04:46,370 --> 00:04:52,610 I simply come up and right-click, pin to taskbar. 98 00:04:52,610 --> 00:04:56,200 And just like that, I see there is PowerPoint. 99 00:04:56,200 --> 00:04:57,020 Now watch this. 100 00:04:57,020 --> 00:05:00,170 I can click and hold it, and move it. 101 00:05:00,170 --> 00:05:03,790 Notice, I'm just dragging it off to the side. 102 00:05:03,790 --> 00:05:06,730 And there it is, right next to Word. 103 00:05:06,730 --> 00:05:10,090 I can also, if you have icons you don't want, 104 00:05:10,090 --> 00:05:15,689 right-click unpin this program from the taskbar. 105 00:05:15,689 --> 00:05:17,230 Now, the next thing we're going to do 106 00:05:17,230 --> 00:05:19,146 is we're going to talk about Windows Explorer, 107 00:05:19,146 --> 00:05:21,280 and then open up each one of the programs, 108 00:05:21,280 --> 00:05:23,410 or at least a few of the programs. 109 00:05:23,410 --> 00:05:26,200 So you need to take your jump drive, 110 00:05:26,200 --> 00:05:28,500 which is required for this class, 111 00:05:28,500 --> 00:05:30,790 and put it either into the front of the computer, 112 00:05:30,790 --> 00:05:33,580 or the back of the computer, or the side of the computer 113 00:05:33,580 --> 00:05:35,270 or wherever. 114 00:05:35,270 --> 00:05:41,260 So I'm going to put mine in, and sometimes this pops up. 115 00:05:41,260 --> 00:05:45,040 If I click Open Folder to View-- notice 116 00:05:45,040 --> 00:05:47,020 it says, Using Windows Explorer. 117 00:05:47,020 --> 00:05:51,380 If I click on this, it opens Windows Explorer. 118 00:05:51,380 --> 00:05:53,900 Now I'm going to come up and close this. 119 00:05:53,900 --> 00:05:56,395 Now remember we plugged in our USB drive 120 00:05:56,395 --> 00:05:59,270 and it opened up that little window and we clicked on it, 121 00:05:59,270 --> 00:06:03,680 I also could, to open up Windows Explorer, click on this button, 122 00:06:03,680 --> 00:06:06,460 and I'm going to do that. 123 00:06:06,460 --> 00:06:09,100 The keyboard to open up Windows Explorer. 124 00:06:09,100 --> 00:06:11,480 And we will do this a lot in this class, 125 00:06:11,480 --> 00:06:13,780 especially when we're dealing with a lot of files 126 00:06:13,780 --> 00:06:14,950 we're downloading. 127 00:06:14,950 --> 00:06:18,630 You hold the window key, and then tap E. So the keyboard 128 00:06:18,630 --> 00:06:22,570 is Window, E. That opens up Windows Explorer. 129 00:06:22,570 --> 00:06:24,130 Now what is Windows Explorer? 130 00:06:24,130 --> 00:06:26,710 Well, right down the middle there 131 00:06:26,710 --> 00:06:30,440 is a bar that divides the left and the right side. 132 00:06:30,440 --> 00:06:32,680 I'm going to very carefully point to that bar, 133 00:06:32,680 --> 00:06:36,700 and sometimes it's hard to get your cursor, there it is. 134 00:06:36,700 --> 00:06:40,510 That horizontal white arrow, if I click and drag, 135 00:06:40,510 --> 00:06:44,920 now I can move and make the left side smaller or bigger. 136 00:06:44,920 --> 00:06:46,760 I'm going to stop right about there. 137 00:06:46,760 --> 00:06:48,190 Now the beauty of Windows Explorer 138 00:06:48,190 --> 00:06:50,740 is this is the whole hierarchical structure 139 00:06:50,740 --> 00:06:52,480 of our computer. 140 00:06:52,480 --> 00:06:56,890 We can click on any drive, for example the C drive, 141 00:06:56,890 --> 00:07:01,580 and as soon as I click on it, over on the right 142 00:07:01,580 --> 00:07:04,010 I can see everything inside of it. 143 00:07:04,010 --> 00:07:07,300 Now later in a little bit of this video and next video, 144 00:07:07,300 --> 00:07:10,780 we'll do a lot with managing files and folders. 145 00:07:10,780 --> 00:07:14,860 We can create folders, we can move files, delete files, 146 00:07:14,860 --> 00:07:18,130 and lots of other file management tasks. 147 00:07:18,130 --> 00:07:21,719 Now this was the C I put in my jump drive, so watch this. 148 00:07:21,719 --> 00:07:22,760 I'm going to click on it. 149 00:07:22,760 --> 00:07:27,550 150 00:07:27,550 --> 00:07:30,130 And as soon as I click on it on the left, 151 00:07:30,130 --> 00:07:33,100 I can see everything inside that drive on the right. 152 00:07:33,100 --> 00:07:36,010 Now I want to go back and click on C. Notice, 153 00:07:36,010 --> 00:07:38,440 I just see the C drive over here, 154 00:07:38,440 --> 00:07:41,560 and everything inside of it on the right. 155 00:07:41,560 --> 00:07:45,970 But watch this, there's a little triangle on its side. 156 00:07:45,970 --> 00:07:48,130 That's called an Expand and Collapse button. 157 00:07:48,130 --> 00:07:52,090 In some operating systems, you might see a plus and a minus. 158 00:07:52,090 --> 00:07:55,570 But watch this, I'm going to click on it and there it is. 159 00:07:55,570 --> 00:08:00,480 I am allowed to see everything inside C drive here. 160 00:08:00,480 --> 00:08:01,540 Well, wait a second. 161 00:08:01,540 --> 00:08:05,830 It's not everything, it's only folders. 162 00:08:05,830 --> 00:08:07,690 Notice the actual files over here, 163 00:08:07,690 --> 00:08:11,560 those are never going to show up on the left, only all 164 00:08:11,560 --> 00:08:15,190 of the other places we can drill into. 165 00:08:15,190 --> 00:08:18,400 So one great use for Windows Explorer 166 00:08:18,400 --> 00:08:21,910 is drilling down into the correct folder 167 00:08:21,910 --> 00:08:24,070 to do whatever it is you want inside that folder. 168 00:08:24,070 --> 00:08:26,140 And we'll do that a little bit in the next video, 169 00:08:26,140 --> 00:08:28,240 and a lot in the third video. 170 00:08:28,240 --> 00:08:31,450 Now I want to click on the F drive, that's 171 00:08:31,450 --> 00:08:32,679 our jump drive we've put in. 172 00:08:32,679 --> 00:08:35,380 By the way, we can come up here since it's taking up 173 00:08:35,380 --> 00:08:40,000 a lot of space and click that little triangle 174 00:08:40,000 --> 00:08:41,650 to collapse everything back up. 175 00:08:41,650 --> 00:08:44,770 One other thing, notice I can click and see 176 00:08:44,770 --> 00:08:48,520 everything inside when I use the triangle, or the pluses 177 00:08:48,520 --> 00:08:49,180 and minuses. 178 00:08:49,180 --> 00:08:53,540 Those only expose and show things over here on the left. 179 00:08:53,540 --> 00:08:56,230 Now I'm going to collapse it, and click on my 180 00:08:56,230 --> 00:08:58,250 what's called "Kingston F." 181 00:08:58,250 --> 00:09:01,760 Now that letter might be different on your computer, 182 00:09:01,760 --> 00:09:04,110 but that's the jump drive that we put in. 183 00:09:04,110 --> 00:09:07,230 184 00:09:07,230 --> 00:09:11,730 Now what I want to do is I clicked on the drive, now 185 00:09:11,730 --> 00:09:14,970 I'm going to click in the white area which means 186 00:09:14,970 --> 00:09:17,280 I'm in essence inside of here. 187 00:09:17,280 --> 00:09:21,780 Now I want to create a new folder using Windows Explorer. 188 00:09:21,780 --> 00:09:25,020 One way to do it is click the New Folder button. 189 00:09:25,020 --> 00:09:27,840 If I click that, it's very polite. 190 00:09:27,840 --> 00:09:30,360 It creates a new folder, and highlights 191 00:09:30,360 --> 00:09:33,090 in blue the name of the folder. 192 00:09:33,090 --> 00:09:35,460 Now I'm going to click escape, and now I 193 00:09:35,460 --> 00:09:38,430 want to learn that keyboard for delete 194 00:09:38,430 --> 00:09:39,640 because I want to delete it. 195 00:09:39,640 --> 00:09:40,473 What's the keyboard? 196 00:09:40,473 --> 00:09:43,960 Well, this is sort of a computer joke, it's just the Delete key. 197 00:09:43,960 --> 00:09:48,900 Now, it says delete folder, and I want you to notice something. 198 00:09:48,900 --> 00:09:53,550 It says, "Want to permanently delete this folder?" 199 00:09:53,550 --> 00:09:56,820 usually this message says, "Would 200 00:09:56,820 --> 00:10:00,210 you like me to send this to the recycling bin?" 201 00:10:00,210 --> 00:10:02,550 That's because when you do something 202 00:10:02,550 --> 00:10:05,880 on a plug-in drive like this, it is not 203 00:10:05,880 --> 00:10:07,980 going to send it to the recycling bin. 204 00:10:07,980 --> 00:10:12,510 And if you read the dialog box, it'll be polite and tell you. 205 00:10:12,510 --> 00:10:16,020 I do want to permanently delete this so I'm going to say yes. 206 00:10:16,020 --> 00:10:26,670 207 00:10:26,670 --> 00:10:31,890 Another way to create a folder is right-click New Folder. 208 00:10:31,890 --> 00:10:35,040 I'm never going to do that because that takes too long. 209 00:10:35,040 --> 00:10:38,010 Either that button up there, or later 210 00:10:38,010 --> 00:10:40,050 when we're creating a system of folders, 211 00:10:40,050 --> 00:10:45,600 the absolute fastest way is to use a keyboard, Control, Shift, 212 00:10:45,600 --> 00:10:46,810 and End. 213 00:10:46,810 --> 00:10:51,210 Now notice it's polite, it highlights the potential name. 214 00:10:51,210 --> 00:10:53,610 I do not have to hit Delete. 215 00:10:53,610 --> 00:10:55,800 Any time something's highlighted, 216 00:10:55,800 --> 00:10:59,490 whether it's in Word, or Excel, or Windows Explorer, 217 00:10:59,490 --> 00:11:03,150 or even an address bar in a browser, all you have to do 218 00:11:03,150 --> 00:11:07,740 is start typing, and it will delete it, and put the new name 219 00:11:07,740 --> 00:11:08,340 in. 220 00:11:08,340 --> 00:11:12,210 So I'm going to type, "Excel," space, "File." 221 00:11:12,210 --> 00:11:16,614 Now when I hit Enter, I have a new folder called "Excel File." 222 00:11:16,614 --> 00:11:18,780 We're going to use that folder in just a second when 223 00:11:18,780 --> 00:11:20,880 we create our first Excel file. 224 00:11:20,880 --> 00:11:23,390 Now I'm immediately going to do Control Shift 225 00:11:23,390 --> 00:11:25,440 N. I see that it's highlighted. 226 00:11:25,440 --> 00:11:29,610 I type, "Word File," and enter. 227 00:11:29,610 --> 00:11:34,830 228 00:11:34,830 --> 00:11:40,410 So I have created two folders inside my jump drive. 229 00:11:40,410 --> 00:11:43,680 Now, I'm going to come over and expose on the left. 230 00:11:43,680 --> 00:11:45,510 And look at that, there it is. 231 00:11:45,510 --> 00:11:47,510 Excel File, Word File. 232 00:11:47,510 --> 00:11:51,060 You'll notice these are alphabetically sorted. 233 00:11:51,060 --> 00:11:52,600 I don't see that over here. 234 00:11:52,600 --> 00:11:56,040 This one is reflecting more quickly than this one 235 00:11:56,040 --> 00:11:57,690 because I created them over here. 236 00:11:57,690 --> 00:12:00,750 Now we can sort in Windows Explorer, 237 00:12:00,750 --> 00:12:04,920 just like we would in iTunes, or other systems by simply 238 00:12:04,920 --> 00:12:06,820 clicking on the column header. 239 00:12:06,820 --> 00:12:09,510 So if I click on Name, it sorts it A to Z. 240 00:12:09,510 --> 00:12:13,410 If I click on Name again, Z to A, that means the later letters 241 00:12:13,410 --> 00:12:14,670 to the earlier letters. 242 00:12:14,670 --> 00:12:18,000 Now I always want the Excel file to come first, and the Word 243 00:12:18,000 --> 00:12:21,630 one to come second, and then this one can come last. 244 00:12:21,630 --> 00:12:26,630 So watch this, I'm going to click on the Excel file folder. 245 00:12:26,630 --> 00:12:28,980 And instead of right-clicking Rename, 246 00:12:28,980 --> 00:12:30,405 I'm going to use the keyboard F2. 247 00:12:30,405 --> 00:12:41,240 248 00:12:41,240 --> 00:12:44,690 Now I want to put "01" before the "Ex." 249 00:12:44,690 --> 00:12:47,490 So notice I can take my cursor, and when I move it over here, 250 00:12:47,490 --> 00:12:49,310 there's an I beam. 251 00:12:49,310 --> 00:12:55,160 I can click right before the E, and then type "01," space, 252 00:12:55,160 --> 00:12:56,150 and Enter. 253 00:12:56,150 --> 00:12:58,310 Now let's do the same thing up here. 254 00:12:58,310 --> 00:13:01,730 Now instead of taking my cursor and clicking on Word file, 255 00:13:01,730 --> 00:13:03,860 I'm actually going to use my up arrow. 256 00:13:03,860 --> 00:13:08,150 Now your arrow keys are in the navigation area 257 00:13:08,150 --> 00:13:09,865 of a standard keyboard. 258 00:13:09,865 --> 00:13:14,940 259 00:13:14,940 --> 00:13:17,640 But find your arrow keys, and I'm going up arrow. 260 00:13:17,640 --> 00:13:20,250 So I could certainly up arrow to highlight 261 00:13:20,250 --> 00:13:22,830 that Word File folder. 262 00:13:22,830 --> 00:13:26,580 Now I'm going to hit F2 to rename. 263 00:13:26,580 --> 00:13:29,100 And instead of taking my I beam cursor 264 00:13:29,100 --> 00:13:31,560 and clicking at the beginning, there's a keyboard 265 00:13:31,560 --> 00:13:33,090 that we'll use a lot. 266 00:13:33,090 --> 00:13:34,890 It's the Home key. 267 00:13:34,890 --> 00:13:38,520 The Home, and End, and Page Down, Page Up. 268 00:13:38,520 --> 00:13:43,750 Those are all above the arrow keys on a standard keyboard. 269 00:13:43,750 --> 00:13:46,780 You'll have to find the Home key on your keyboard 270 00:13:46,780 --> 00:13:48,030 because it's an important key. 271 00:13:48,030 --> 00:13:52,010 272 00:13:52,010 --> 00:13:52,770 Now watch this. 273 00:13:52,770 --> 00:13:54,510 Let's hit it and see what happens. 274 00:13:54,510 --> 00:13:58,580 It is always going to go to the front of the line. 275 00:13:58,580 --> 00:14:02,900 Here in Windows Explorer, it goes to the very beginning 276 00:14:02,900 --> 00:14:04,020 of a folder name. 277 00:14:04,020 --> 00:14:06,170 If we were in a Word document, it 278 00:14:06,170 --> 00:14:08,360 would go to the front of the sentence. 279 00:14:08,360 --> 00:14:11,000 If we were creating an Excel formula, 280 00:14:11,000 --> 00:14:13,880 it would go to the front of the formula. 281 00:14:13,880 --> 00:14:17,150 If you're in an address bar in a browser, 282 00:14:17,150 --> 00:14:20,700 it'll go to the very front of the address. 283 00:14:20,700 --> 00:14:24,190 So now I'm going to type "02," space and Enter. 284 00:14:24,190 --> 00:14:25,920 Now look at that over here on the left, 285 00:14:25,920 --> 00:14:28,460 it's already recognizing the sort, 286 00:14:28,460 --> 00:14:32,240 but over here I'm going to click on name, and there we go. 287 00:14:32,240 --> 00:14:36,920 Now we've used Windows Explorer to look through various drives. 288 00:14:36,920 --> 00:14:38,390 We looked inside on the right. 289 00:14:38,390 --> 00:14:41,330 We even created a few folders. 290 00:14:41,330 --> 00:14:44,480 Now we're going to open an Excel file, and a Word 291 00:14:44,480 --> 00:14:48,320 file, new ones, and save them to these two locations. 292 00:14:48,320 --> 00:14:50,570 And then we're going to look at some 293 00:14:50,570 --> 00:14:53,990 of the different aspects of the ribbons, 294 00:14:53,990 --> 00:14:57,650 and the quick access toolbar in Excel and Word. 295 00:14:57,650 --> 00:14:59,830 Now I'm going to come down to the taskbar, 296 00:14:59,830 --> 00:15:02,300 and I'm going to click on the Excel icon. 297 00:15:02,300 --> 00:15:07,320 This is a shortcut that opens up the executable file Excel. 298 00:15:07,320 --> 00:15:09,260 Well, look at that It opened up. 299 00:15:09,260 --> 00:15:10,670 It's trying to be polite. 300 00:15:10,670 --> 00:15:14,440 It's trying to let me-- or have the option to open up 301 00:15:14,440 --> 00:15:17,510 recent files that I've opened. 302 00:15:17,510 --> 00:15:22,010 Over on the right, there's the blank workbook. 303 00:15:22,010 --> 00:15:25,460 And in all of the programs, we'll see Word, PowerPoint. 304 00:15:25,460 --> 00:15:28,310 They'll always try to offer up these templates. 305 00:15:28,310 --> 00:15:32,030 Now I suppose some people use these templates, 306 00:15:32,030 --> 00:15:35,210 but the problem with templates is they often 307 00:15:35,210 --> 00:15:39,000 times are generic, and don't fit your specific needs. 308 00:15:39,000 --> 00:15:41,100 So we're not going to use templates in this class. 309 00:15:41,100 --> 00:15:42,560 We're always going to create things 310 00:15:42,560 --> 00:15:46,100 from scratch that match exactly the needs for whatever 311 00:15:46,100 --> 00:15:47,480 project we're working on. 312 00:15:47,480 --> 00:15:50,960 Now we can click on the blank with our cursor here, 313 00:15:50,960 --> 00:15:52,790 and it opens up a new workbook. 314 00:15:52,790 --> 00:15:55,340 Or every time you open up Excel, you 315 00:15:55,340 --> 00:15:57,500 can simply hit the Escape key. 316 00:15:57,500 --> 00:16:00,950 The Escape key is up in the upper left-hand corner. 317 00:16:00,950 --> 00:16:03,980 There it is, a brand new blank Excel workbook. 318 00:16:03,980 --> 00:16:06,920 Look at this up here, this is called the Title Bar. 319 00:16:06,920 --> 00:16:10,610 And that is a terrible name, "Book 1." 320 00:16:10,610 --> 00:16:13,490 We always want to name our files smartly, 321 00:16:13,490 --> 00:16:16,250 just like we're going to name our folders smartly. 322 00:16:16,250 --> 00:16:18,830 Now we haven't talked about the ribbons, 323 00:16:18,830 --> 00:16:20,550 we'll talk about those in just a second. 324 00:16:20,550 --> 00:16:23,330 And this up here is called a Quick Access Toolbar. 325 00:16:23,330 --> 00:16:25,820 But I want to go and click on File, 326 00:16:25,820 --> 00:16:28,640 this is called Backstage View. 327 00:16:28,640 --> 00:16:30,420 Now, there's lots of options here. 328 00:16:30,420 --> 00:16:33,710 We can click on Info, that will give you information 329 00:16:33,710 --> 00:16:36,120 about this particular file. 330 00:16:36,120 --> 00:16:37,220 New. 331 00:16:37,220 --> 00:16:41,000 We're never going to use this option here in Backstage View 332 00:16:41,000 --> 00:16:43,100 because we're going to use keyboards. 333 00:16:43,100 --> 00:16:45,380 If we want to open up a new blank file, 334 00:16:45,380 --> 00:16:48,020 we'll use the keyboard, Control, N. 335 00:16:48,020 --> 00:16:48,830 Open. 336 00:16:48,830 --> 00:16:51,170 We're never going to use this either because when 337 00:16:51,170 --> 00:16:54,560 we want to open something and we're inside a program, 338 00:16:54,560 --> 00:16:57,920 we'll use Control O. There'll be an advantage too 339 00:16:57,920 --> 00:17:00,200 because notice, I had to click on File, 340 00:17:00,200 --> 00:17:02,330 then I had to click on Open, then 341 00:17:02,330 --> 00:17:04,940 I have to come down and click Browse. 342 00:17:04,940 --> 00:17:09,118 That's three clicks to get to the Open dialog box 343 00:17:09,118 --> 00:17:11,179 so later we'll learn the keyboard. 344 00:17:11,180 --> 00:17:12,290 Same with Save. 345 00:17:12,290 --> 00:17:14,780 We're never going to use this option here. 346 00:17:14,780 --> 00:17:18,079 We're going to use Control S to save. 347 00:17:18,079 --> 00:17:21,829 Notice, it says Save As here, even though that's 348 00:17:21,829 --> 00:17:23,660 a different option down here. 349 00:17:23,660 --> 00:17:27,500 The reason that Save is saying Save As right 350 00:17:27,500 --> 00:17:30,680 here is because Excel, and Word, and the other programs 351 00:17:30,680 --> 00:17:35,450 are smart enough to know that we have never named this file here 352 00:17:35,450 --> 00:17:39,020 so it has no idea where we should save the changes. 353 00:17:39,020 --> 00:17:41,960 So currently, Save and Save As are the same. 354 00:17:41,960 --> 00:17:44,720 But again, when we have a file and we're just saving changes, 355 00:17:44,720 --> 00:17:46,220 we're never going to use this, we're 356 00:17:46,220 --> 00:17:48,740 going to use Control S. Same with this, 357 00:17:48,740 --> 00:17:52,070 if we wanted to come up to File, Save As, this, 358 00:17:52,070 --> 00:17:53,570 that's three clicks. 359 00:17:53,570 --> 00:17:58,320 We're going to use the keyboard, F12, when we're doing Save As. 360 00:17:58,320 --> 00:17:59,570 Save As PDF. 361 00:17:59,570 --> 00:18:01,070 We're never going to do that either. 362 00:18:01,070 --> 00:18:02,840 I shouldn't have even clicked on it because there's 363 00:18:02,840 --> 00:18:03,770 a better keyboard. 364 00:18:03,770 --> 00:18:05,570 We'll see how to do that later. 365 00:18:05,570 --> 00:18:09,330 Same with Print, Control P is what we'll use. 366 00:18:09,330 --> 00:18:10,257 Share. 367 00:18:10,257 --> 00:18:12,090 We're never going to use this in this class, 368 00:18:12,090 --> 00:18:14,630 but if you ever want to share you might use this. 369 00:18:14,630 --> 00:18:15,140 Export. 370 00:18:15,140 --> 00:18:19,510 We're never to use that because we know how to use Save As. 371 00:18:19,510 --> 00:18:20,090 Publish. 372 00:18:20,090 --> 00:18:21,660 We're never going to use that. 373 00:18:21,660 --> 00:18:24,530 Well actually, in an advanced Excel class, 374 00:18:24,530 --> 00:18:26,480 we'd learn how to Publish to Power BI, 375 00:18:26,480 --> 00:18:27,920 but not in this class. 376 00:18:27,920 --> 00:18:28,640 Close. 377 00:18:28,640 --> 00:18:30,680 We're never going to use that because we'll 378 00:18:30,680 --> 00:18:33,140 use Alt F4, or the red X, or something like this. 379 00:18:33,140 --> 00:18:36,560 Here's an option that is useful, Account this tells you 380 00:18:36,560 --> 00:18:38,750 things about your account. 381 00:18:38,750 --> 00:18:41,870 You could actually change the background and the Office theme 382 00:18:41,870 --> 00:18:43,330 if you wanted to. 383 00:18:43,330 --> 00:18:45,470 Over here, this is very important 384 00:18:45,470 --> 00:18:47,690 because in this day and age there 385 00:18:47,690 --> 00:18:52,050 are all sorts of different versions of Office, 386 00:18:52,050 --> 00:18:54,840 or different versions of Excel, or Word. 387 00:18:54,840 --> 00:18:57,720 So this gives you good information; version, 388 00:18:57,720 --> 00:19:00,030 so and so, build, so and so. 389 00:19:00,030 --> 00:19:02,860 You can even go online and manage your account. 390 00:19:02,860 --> 00:19:06,570 And if you're signed up for Office 365, 391 00:19:06,570 --> 00:19:09,180 they change things periodically. 392 00:19:09,180 --> 00:19:11,040 So you might come here to update, 393 00:19:11,040 --> 00:19:13,200 or you might even come here to say, "Hey, what's 394 00:19:13,200 --> 00:19:15,040 new in the latest version?" 395 00:19:15,040 --> 00:19:15,540 Feedback. 396 00:19:15,540 --> 00:19:16,560 We're never going to use that. 397 00:19:16,560 --> 00:19:17,220 Options. 398 00:19:17,220 --> 00:19:20,940 We will use Options in whatever program you're in; 399 00:19:20,940 --> 00:19:22,920 PowerPoint, Word, or Excel. 400 00:19:22,920 --> 00:19:24,990 There's a bunch of important options. 401 00:19:24,990 --> 00:19:28,050 They change default settings, and we'll get to do that a lot 402 00:19:28,050 --> 00:19:28,800 in this class. 403 00:19:28,800 --> 00:19:30,480 Now I'm going to close that. 404 00:19:30,480 --> 00:19:32,400 So that was Backstage View. 405 00:19:32,400 --> 00:19:34,770 Escape, and the Backstage View is 406 00:19:34,770 --> 00:19:37,110 very similar in all the different programs. 407 00:19:37,110 --> 00:19:40,560 Also, the ribbon structure is similar in all 408 00:19:40,560 --> 00:19:41,970 the different programs. 409 00:19:41,970 --> 00:19:43,830 This is the Home Ribbon tab. 410 00:19:43,830 --> 00:19:48,210 These are where standard things are that are used most often. 411 00:19:48,210 --> 00:19:50,190 Now the first part, and second part, 412 00:19:50,190 --> 00:19:54,390 sort of look the same when we get to Word and PowerPoint. 413 00:19:54,390 --> 00:19:56,250 Access is a whole different animal, 414 00:19:56,250 --> 00:19:58,590 but they still have a ribbon there. 415 00:19:58,590 --> 00:20:00,450 But here is some things that have 416 00:20:00,450 --> 00:20:03,180 to do with Copy, Cut, Paste. 417 00:20:03,180 --> 00:20:05,090 We'll see a lot of tricks with those. 418 00:20:05,090 --> 00:20:06,570 Font, Alignment. 419 00:20:06,570 --> 00:20:09,430 That starts to get much different here in Excel. 420 00:20:09,430 --> 00:20:12,780 Now each one of these, Clipboard Font, and Alignment, 421 00:20:12,780 --> 00:20:14,760 those are called groups. 422 00:20:14,760 --> 00:20:17,550 And then within a group, we have a particular button 423 00:20:17,550 --> 00:20:19,050 like Warp Text. 424 00:20:19,050 --> 00:20:22,140 We use number group, and these buttons, a lot 425 00:20:22,140 --> 00:20:23,760 when we get to Excel. 426 00:20:23,760 --> 00:20:27,270 Now so that's the Home ribbon tab. 427 00:20:27,270 --> 00:20:29,340 This whole thing is considered the Ribbon. 428 00:20:29,340 --> 00:20:32,550 That's the Home tab in the Ribbon. 429 00:20:32,550 --> 00:20:35,940 Over here, there's the Insert Ribbon tab. 430 00:20:35,940 --> 00:20:38,700 Each one of the versions will have different things 431 00:20:38,700 --> 00:20:41,220 that we can insert into the file. 432 00:20:41,220 --> 00:20:43,980 They all pretty much have pictures. 433 00:20:43,980 --> 00:20:46,400 Excel here has charts. 434 00:20:46,400 --> 00:20:50,400 Other programs don't have these types of charts. 435 00:20:50,400 --> 00:20:51,360 Page Layout. 436 00:20:51,360 --> 00:20:55,560 That's where we determine what it looks like when we print. 437 00:20:55,560 --> 00:20:59,520 This ribbon tab is in all the different programs. 438 00:20:59,520 --> 00:21:02,610 Each one has their different groups. 439 00:21:02,610 --> 00:21:03,330 Formulas. 440 00:21:03,330 --> 00:21:04,920 Well that one's just in Excel. 441 00:21:04,920 --> 00:21:05,500 Data. 442 00:21:05,500 --> 00:21:07,260 That one's just in Excel. 443 00:21:07,260 --> 00:21:08,130 Review. 444 00:21:08,130 --> 00:21:09,960 That's like where you find spell check, 445 00:21:09,960 --> 00:21:12,210 although we'll learn a keyboard for that. 446 00:21:12,210 --> 00:21:12,840 View. 447 00:21:12,840 --> 00:21:15,720 That's where you can go to View different things. 448 00:21:15,720 --> 00:21:19,020 In Excel we can uncheck grid lines 449 00:21:19,020 --> 00:21:20,850 to not show the grid lines. 450 00:21:20,850 --> 00:21:23,670 Each one of the programs has a View. 451 00:21:23,670 --> 00:21:27,580 And PowerPoint, we can view the PowerPoint in different ways. 452 00:21:27,580 --> 00:21:29,550 Now Developer, that is not one you probably 453 00:21:29,550 --> 00:21:31,320 see on your computer. 454 00:21:31,320 --> 00:21:33,690 We're not going to use that in this class. 455 00:21:33,690 --> 00:21:36,210 Add-ins, Acrobat, Power Pivot, those 456 00:21:36,210 --> 00:21:39,310 are not ones you see probably on your home computer. 457 00:21:39,310 --> 00:21:41,400 Those are all added in special. 458 00:21:41,400 --> 00:21:45,000 So those are the ribbon tabs, there's the tab. 459 00:21:45,000 --> 00:21:48,880 Each one of these is called a group, and these are buttons. 460 00:21:48,880 --> 00:21:54,540 461 00:21:54,540 --> 00:21:57,730 Now I want to click in cell A1, and I'm 462 00:21:57,730 --> 00:22:01,290 going to use my Control key, and the wheel 463 00:22:01,290 --> 00:22:04,470 on my mouse to zoom in. 464 00:22:04,470 --> 00:22:05,550 That's a great keyboard. 465 00:22:05,550 --> 00:22:06,540 It works in Word. 466 00:22:06,540 --> 00:22:07,840 It works in browsers. 467 00:22:07,840 --> 00:22:10,450 It works in lots of different programs. 468 00:22:10,450 --> 00:22:14,460 The other way to do this is down here, there's a Zoom bar. 469 00:22:14,460 --> 00:22:17,310 Now, this Zoom bar right here is actually 470 00:22:17,310 --> 00:22:20,470 part of what's called the status bar, 471 00:22:20,470 --> 00:22:22,050 and we'll see this in each program. 472 00:22:22,050 --> 00:22:25,697 There'll be different options in the status bar. 473 00:22:25,697 --> 00:22:27,030 But right here, that's the zoom. 474 00:22:27,030 --> 00:22:30,490 You can slide it like that. 475 00:22:30,490 --> 00:22:32,320 as an alternative method. 476 00:22:32,320 --> 00:22:35,260 For me, it just takes too long to come down 477 00:22:35,260 --> 00:22:39,430 here and try and grab it when you have Control 478 00:22:39,430 --> 00:22:41,150 and roll the wheel. 479 00:22:41,150 --> 00:22:44,900 I'm just going to type something, "Excel is fun," 480 00:22:44,900 --> 00:22:46,120 and Enter. 481 00:22:46,120 --> 00:22:50,410 Now I'm going to come down here, and double-click the sheet 482 00:22:50,410 --> 00:22:54,700 to rename it, and I'm going to type, "Excel is fun," 483 00:22:54,700 --> 00:22:56,260 and Enter. 484 00:22:56,260 --> 00:22:59,200 So that's all I've done, I named this sheet. 485 00:22:59,200 --> 00:23:03,770 I put something in cell A1, and now I want to save it. 486 00:23:03,770 --> 00:23:08,010 Now we've got to talk about Save and Save As, 487 00:23:08,010 --> 00:23:10,000 and the fundamental difference between each. 488 00:23:10,000 --> 00:23:14,280 489 00:23:14,280 --> 00:23:17,790 Now as I mentioned, we're going to use keyboard. 490 00:23:17,790 --> 00:23:23,640 So let's just try Control S. That is the keyboard 491 00:23:23,640 --> 00:23:28,530 to save changes to a file that's already been saved somewhere 492 00:23:28,530 --> 00:23:29,520 and has a name. 493 00:23:29,520 --> 00:23:32,580 But notice what it does, it opens up Save As. 494 00:23:32,580 --> 00:23:34,230 So I'm going to click escape because I 495 00:23:34,230 --> 00:23:36,750 don't want to have to click all these times to get 496 00:23:36,750 --> 00:23:38,880 to the dialog box to save it. 497 00:23:38,880 --> 00:23:42,480 The keyboard we're going to use when we're saving it 498 00:23:42,480 --> 00:23:46,800 for the first time, or every time we want to do Save As-- 499 00:23:46,800 --> 00:23:50,700 which is we want to change the location, or the file name, 500 00:23:50,700 --> 00:23:52,050 or the extension. 501 00:23:52,050 --> 00:23:56,490 Any time we do Save As, we're going to use the F12 key. 502 00:23:56,490 --> 00:24:00,096 That is a huge time saver. 503 00:24:00,096 --> 00:24:01,470 Every time you do Save As, if you 504 00:24:01,470 --> 00:24:04,770 do that the long way, you'd be clicking three times. 505 00:24:04,770 --> 00:24:06,690 All right, here's save as. 506 00:24:06,690 --> 00:24:10,680 We can see up in the upper corner this is a window. 507 00:24:10,680 --> 00:24:15,360 Now you could point to one of the corners of this window, 508 00:24:15,360 --> 00:24:18,210 and you see right there, there's a diagonal white arrow. 509 00:24:18,210 --> 00:24:22,110 You can click and drag, and resize this. 510 00:24:22,110 --> 00:24:26,250 Now there's three parts to Save As. 511 00:24:26,250 --> 00:24:28,820 Notice, left, right. 512 00:24:28,820 --> 00:24:30,630 That looks just like Windows Explorer. 513 00:24:30,630 --> 00:24:34,870 The first part to Save As is, where do you want to save it? 514 00:24:34,870 --> 00:24:38,517 So I could scroll down, and I could click on Kingston. 515 00:24:38,517 --> 00:24:40,350 We're going to change that in just a second, 516 00:24:40,350 --> 00:24:43,560 but right now I'm using Save As to save 517 00:24:43,560 --> 00:24:46,140 this file to that drive. 518 00:24:46,140 --> 00:24:49,530 Now the second part is filename so I'm 519 00:24:49,530 --> 00:24:51,090 very carefully going to click. 520 00:24:51,090 --> 00:24:54,690 Notice I just clicked once with my I beam cursor, 521 00:24:54,690 --> 00:24:55,800 and it was polite. 522 00:24:55,800 --> 00:24:57,540 It highlighted the whole thing. 523 00:24:57,540 --> 00:25:02,250 Now I'm going to type, "My First Excel File." 524 00:25:02,250 --> 00:25:04,150 That's the second step. 525 00:25:04,150 --> 00:25:07,410 The third step is Save As Type. 526 00:25:07,410 --> 00:25:10,630 This is also known as the extension. 527 00:25:10,630 --> 00:25:16,140 Now your computer might not show the .XLSX, 528 00:25:16,140 --> 00:25:19,660 but I'm going to show you how to change that right after we save 529 00:25:19,660 --> 00:25:20,640 this file. 530 00:25:20,640 --> 00:25:24,060 Your file might not have the settings set correctly 531 00:25:24,060 --> 00:25:27,000 to show the file extension, and that file extension 532 00:25:27,000 --> 00:25:27,990 is very important. 533 00:25:27,990 --> 00:25:30,870 Your computer might just say, "Excel Workbook." 534 00:25:30,870 --> 00:25:35,370 Now I want to click in the Save As type text box, 535 00:25:35,370 --> 00:25:39,150 and notice there's all sorts of different file types 536 00:25:39,150 --> 00:25:42,990 that we can use when saving an Excel file. 537 00:25:42,990 --> 00:25:46,100 Now because we haven't changed the file extension, 538 00:25:46,100 --> 00:25:49,080 I will show you that in our next example. 539 00:25:49,080 --> 00:25:52,230 I'm just going to accept the default, but here it is. 540 00:25:52,230 --> 00:25:55,200 There's three things-- where do you want to save it, 541 00:25:55,200 --> 00:25:56,880 what do you want to call it, what's 542 00:25:56,880 --> 00:25:58,830 the file type or extension? 543 00:25:58,830 --> 00:26:00,330 Now I can already tell you that it's 544 00:26:00,330 --> 00:26:01,890 going to be a quiz question. 545 00:26:01,890 --> 00:26:04,780 I'm going to say one of the three parts of Save As. 546 00:26:04,780 --> 00:26:06,660 Now I actually want to change something. 547 00:26:06,660 --> 00:26:10,320 I don't want to save it exactly to Kingston 548 00:26:10,320 --> 00:26:13,710 so I'm going to click the triangle to expose. 549 00:26:13,710 --> 00:26:16,180 Now I can either use the scroll bar here, 550 00:26:16,180 --> 00:26:19,860 or I can use the wheel on my mouse. 551 00:26:19,860 --> 00:26:25,770 Now I'm going to click on the folder inside of Kingston. 552 00:26:25,770 --> 00:26:28,710 This is smart file management. 553 00:26:28,710 --> 00:26:33,060 I have created a folder, and I'm going to save this file exactly 554 00:26:33,060 --> 00:26:34,800 to the location I want. 555 00:26:34,800 --> 00:26:35,700 All right, you ready? 556 00:26:35,700 --> 00:26:37,140 Where do you want to save it? 557 00:26:37,140 --> 00:26:38,760 What do you want to call it? 558 00:26:38,760 --> 00:26:40,440 What's the file extension? 559 00:26:40,440 --> 00:26:44,340 1, 2, 3, now I can click Save. 560 00:26:44,340 --> 00:26:46,620 Now immediately look up to the Title Bar. 561 00:26:46,620 --> 00:26:48,600 There's the filename. 562 00:26:48,600 --> 00:26:51,600 Filenames are also important in this class. 563 00:26:51,600 --> 00:26:54,700 Now I'm going to change something in this file 564 00:26:54,700 --> 00:26:57,390 so I'm going to click in cell C1. 565 00:26:57,390 --> 00:27:01,410 And I'm going to type, "Sales," and Enter. 566 00:27:01,410 --> 00:27:07,380 Then I'm going to type "23.52" Enter. 567 00:27:07,380 --> 00:27:11,120 "36.99" Enter. 568 00:27:11,120 --> 00:27:13,620 Now guess what, I changed the file. 569 00:27:13,620 --> 00:27:15,220 The content is different. 570 00:27:15,220 --> 00:27:18,540 So now we're going to use the keyboard Control S. 571 00:27:18,540 --> 00:27:19,530 Nothing happened. 572 00:27:19,530 --> 00:27:20,430 Well, what? 573 00:27:20,430 --> 00:27:22,590 I thought it was supposed to open Save As. 574 00:27:22,590 --> 00:27:25,860 No, we've already saved this file someplace 575 00:27:25,860 --> 00:27:30,260 so when I click Control S, it just saves the changes. 576 00:27:30,260 --> 00:27:32,310 Now let's prove this to ourself. 577 00:27:32,310 --> 00:27:36,450 Either click the X in the upper right-hand corner, 578 00:27:36,450 --> 00:27:37,890 or use Alt F4. 579 00:27:37,890 --> 00:27:43,910 580 00:27:43,910 --> 00:27:46,730 Now notice the only other window I have open, 581 00:27:46,730 --> 00:27:49,566 actually I have a video recorder window open, 582 00:27:49,566 --> 00:27:51,440 but the only other window we should have open 583 00:27:51,440 --> 00:27:53,970 is Windows Explorer so when I closed it, 584 00:27:53,970 --> 00:27:55,610 it let us see in here. 585 00:27:55,610 --> 00:27:59,360 Now we're going to use Windows Explorer to verify 586 00:27:59,360 --> 00:28:01,790 that the file is saved in the correct location. 587 00:28:01,790 --> 00:28:06,920 So I click on 01 Excel File, and sure enough when I click 588 00:28:06,920 --> 00:28:10,680 on the left, I can see on the right there is the file. 589 00:28:10,680 --> 00:28:12,830 Now let's double-click. 590 00:28:12,830 --> 00:28:16,060 We're going to use Windows Explorer to open our file, 591 00:28:16,060 --> 00:28:20,270 and actually that's how we will open files in this class most 592 00:28:20,270 --> 00:28:21,110 of the time. 593 00:28:21,110 --> 00:28:24,200 I'm going to double-click. 594 00:28:24,200 --> 00:28:27,550 Now I'm going to close this because I should have done-- 595 00:28:27,550 --> 00:28:30,320 because I know this is a basic class, 596 00:28:30,320 --> 00:28:32,900 sometimes when you're learning how to double-click, 597 00:28:32,900 --> 00:28:36,260 you do a slow double-click. 598 00:28:36,260 --> 00:28:38,075 If you double-click really slowly, 599 00:28:38,075 --> 00:28:41,210 it tries to put it in "please rename me" mode. 600 00:28:41,210 --> 00:28:44,180 Now as soon as that happens, hit the Escape key 601 00:28:44,180 --> 00:28:46,960 in the upper-left hand corner. 602 00:28:46,960 --> 00:28:51,180 And now if you want to make sure, double-click the icon. 603 00:28:51,180 --> 00:28:54,350 Then even if you slow double-click, 604 00:28:54,350 --> 00:28:55,970 it won't put it in Edit mode. 605 00:28:55,970 --> 00:28:59,030 And sure enough, Control S totally worked. 606 00:28:59,030 --> 00:29:02,720 When we changed something, it simply saved the changes 607 00:29:02,720 --> 00:29:04,170 to that location. 608 00:29:04,170 --> 00:29:06,126 Now I want to use Save As. 609 00:29:06,126 --> 00:29:07,250 So what are we going to do? 610 00:29:07,250 --> 00:29:12,920 We're not going to go to File, Save As, Browse. 611 00:29:12,920 --> 00:29:14,210 That's too many clicks. 612 00:29:14,210 --> 00:29:14,720 Escape. 613 00:29:14,720 --> 00:29:15,410 Escape. 614 00:29:15,410 --> 00:29:18,020 I'm just immediately going to hit F12. 615 00:29:18,020 --> 00:29:19,940 Now remember if there's three parts 616 00:29:19,940 --> 00:29:24,860 to Save As, that means we can change three things; 617 00:29:24,860 --> 00:29:29,060 we can change the location, we can change the file name, 618 00:29:29,060 --> 00:29:31,160 or we can change the extension. 619 00:29:31,160 --> 00:29:33,620 Now as soon as we do one of those things, 620 00:29:33,620 --> 00:29:38,210 we actually are creating a new file and this is common. 621 00:29:38,210 --> 00:29:41,420 We have our file, and we're happy with our file, 622 00:29:41,420 --> 00:29:44,990 but maybe we want to change the name, or change the location. 623 00:29:44,990 --> 00:29:49,685 In this case, I want to change the file type, or extension 624 00:29:49,685 --> 00:29:51,380 so I'm going to click the dropdown, 625 00:29:51,380 --> 00:29:58,010 and I'm going to choose this one, Excel 97-2003 workbook. 626 00:29:58,010 --> 00:30:00,020 Now, why in the world would I do that? 627 00:30:00,020 --> 00:30:03,020 Although the vast majority of people 628 00:30:03,020 --> 00:30:05,780 who use Excel on the planet Earth 629 00:30:05,780 --> 00:30:12,740 have one of the newer versions, either Excel 2007, 2010, 2013, 630 00:30:12,740 --> 00:30:15,170 or 2016, there is still a proportion 631 00:30:15,170 --> 00:30:17,870 of people that have this older version. 632 00:30:17,870 --> 00:30:22,490 And the newer versions that we create with any one 633 00:30:22,490 --> 00:30:25,220 of the versions, we're using Excel 2016, 634 00:30:25,220 --> 00:30:28,320 that older computer cannot read our file. 635 00:30:28,320 --> 00:30:31,880 So if we're going to email this to someone who does not 636 00:30:31,880 --> 00:30:35,030 have the proper version, we can simply 637 00:30:35,030 --> 00:30:37,040 use this dropdown to select it. 638 00:30:37,040 --> 00:30:40,070 And then when we send this workbook to this person, 639 00:30:40,070 --> 00:30:41,270 they can read it. 640 00:30:41,270 --> 00:30:42,570 Now what did we do? 641 00:30:42,570 --> 00:30:44,270 We did not change the location. 642 00:30:44,270 --> 00:30:47,990 If I click the triangle, I can still see it's highlighted, 643 00:30:47,990 --> 00:30:49,220 01 Excel File. 644 00:30:49,220 --> 00:30:51,500 I didn't change the name, I changed the extension. 645 00:30:51,500 --> 00:30:57,200 Now when I click Save, and close this, Alt F4, guess what? 646 00:30:57,200 --> 00:30:58,670 There's two files. 647 00:30:58,670 --> 00:31:03,590 Every time you use Save As, it will create a new file. 648 00:31:03,590 --> 00:31:06,860 Now I'm going to double-click and open up my first Excel 649 00:31:06,860 --> 00:31:07,610 file. 650 00:31:07,610 --> 00:31:10,460 I'm immediately going to hit the F12 key, 651 00:31:10,460 --> 00:31:12,620 and I'm going to change the name. 652 00:31:12,620 --> 00:31:15,890 Now watch this, I'm going to come to the filename 653 00:31:15,890 --> 00:31:18,800 and double-click the word "first." 654 00:31:18,800 --> 00:31:23,810 We will see that in Word, PowerPoint, filenames, 655 00:31:23,810 --> 00:31:27,020 if you double click a word, it highlights the word. 656 00:31:27,020 --> 00:31:28,520 I don't have to hit Delete, I'm just 657 00:31:28,520 --> 00:31:31,640 going to type, "Second" and a space. 658 00:31:31,640 --> 00:31:34,150 Now notice if I click the triangle, 659 00:31:34,150 --> 00:31:35,780 I'm still in the same location. 660 00:31:35,780 --> 00:31:39,170 The file extension is the same, but I've changed the name. 661 00:31:39,170 --> 00:31:44,470 So when I click Save, Alt F4, there it is, three files. 662 00:31:44,470 --> 00:31:47,990 And notice we're using Windows Explorer to look and verify 663 00:31:47,990 --> 00:31:51,290 that the files we created are actually there. 664 00:31:51,290 --> 00:31:55,130 Now before we create our next Word file, 665 00:31:55,130 --> 00:31:58,490 I actually want to show you how to show these extensions. 666 00:31:58,490 --> 00:32:02,420 I mentioned that your computer might not be showing you 667 00:32:02,420 --> 00:32:04,454 these extensions, and these extensions 668 00:32:04,454 --> 00:32:05,870 are important because they tell us 669 00:32:05,870 --> 00:32:08,460 important things about the file. 670 00:32:08,460 --> 00:32:11,510 Now we need to get to folder options. 671 00:32:11,510 --> 00:32:17,080 Now in Windows Explorer up in this menu bar under Organize, 672 00:32:17,080 --> 00:32:22,490 I can click and come down to Folder and Search Options. 673 00:32:22,490 --> 00:32:26,630 And when I click this, that's the dialog box we want. 674 00:32:26,630 --> 00:32:29,060 Now your particular-- I'm going to click escape. 675 00:32:29,060 --> 00:32:31,820 Your particular Windows Explorer might not 676 00:32:31,820 --> 00:32:35,930 have that organize so here's a more universal way 677 00:32:35,930 --> 00:32:37,730 to get to that Folders options. 678 00:32:37,730 --> 00:32:40,440 Folders options have been around forever. 679 00:32:40,440 --> 00:32:42,990 You have to get to the Control Panel 680 00:32:42,990 --> 00:32:44,890 if you don't have this button up here. 681 00:32:44,890 --> 00:32:50,500 Now, remember you might have Windows 8, Windows 7, windows 682 00:32:50,500 --> 00:32:55,960 10 so I need to get to either the Start Menu, or the tile 683 00:32:55,960 --> 00:32:56,480 screen. 684 00:32:56,480 --> 00:32:58,900 So I'm going to hit the Window key, 685 00:32:58,900 --> 00:33:01,630 and you might immediately see Control Panel, 686 00:33:01,630 --> 00:33:04,330 but you can simply type. 687 00:33:04,330 --> 00:33:08,800 I typed, "Cont," C-O-N-T, and I already have it in my list. 688 00:33:08,800 --> 00:33:11,730 So when I click Control Panel-- 689 00:33:11,730 --> 00:33:14,730 and your Control Panel might look different too depending 690 00:33:14,730 --> 00:33:16,650 on which version you have. 691 00:33:16,650 --> 00:33:19,590 But all you gotta do is search through Folders Options. 692 00:33:19,590 --> 00:33:21,330 Again, have been around forever so 693 00:33:21,330 --> 00:33:25,880 this is on every one of our computers in the Control Panel. 694 00:33:25,880 --> 00:33:28,440 So I'm going to click Folder Options, 695 00:33:28,440 --> 00:33:31,050 and there is our dialog box. 696 00:33:31,050 --> 00:33:34,050 Now we have some tabs; General, View, Search. 697 00:33:34,050 --> 00:33:36,300 We want View. 698 00:33:36,300 --> 00:33:40,140 And down here, almost all computers 699 00:33:40,140 --> 00:33:43,800 when you first get them, the operating system 700 00:33:43,800 --> 00:33:46,380 is set up with this button checked, 701 00:33:46,380 --> 00:33:49,800 Hide Extensions for Known File Types. 702 00:33:49,800 --> 00:33:52,620 If I click OK, look at that. 703 00:33:52,620 --> 00:33:56,880 Now, I can come over here and see the type and read it. 704 00:33:56,880 --> 00:33:59,580 We definitely need important information 705 00:33:59,580 --> 00:34:00,900 about our file types. 706 00:34:00,900 --> 00:34:03,120 Now just for Excel, it's important to see 707 00:34:03,120 --> 00:34:06,030 the different file types, but you might have a Word document. 708 00:34:06,030 --> 00:34:10,956 You might have an MOV, which is a video file, or a AVI, 709 00:34:10,956 --> 00:34:12,600 or a PDF. 710 00:34:12,600 --> 00:34:16,679 So we want to turn those extensions on. 711 00:34:16,679 --> 00:34:17,810 Window key. 712 00:34:17,810 --> 00:34:19,760 I'm going to type "Control." 713 00:34:19,760 --> 00:34:22,409 I'm clicking on Control here. 714 00:34:22,409 --> 00:34:28,590 Folder Options, and there it is, View, uncheck, Hide Extensions 715 00:34:28,590 --> 00:34:29,940 for Known File Types. 716 00:34:29,940 --> 00:34:34,960 Now in your notes that you can download for each video-- 717 00:34:34,960 --> 00:34:37,260 this video, when you download the notes, 718 00:34:37,260 --> 00:34:40,914 there's a picture of this because that's very important 719 00:34:40,914 --> 00:34:42,330 that on your computer you're going 720 00:34:42,330 --> 00:34:45,150 to be working on in this class, you need to uncheck that. 721 00:34:45,150 --> 00:34:48,989 Click OK, or Alt F4, I can close that, 722 00:34:48,989 --> 00:34:51,210 and there's the file extensions. 723 00:34:51,210 --> 00:34:55,199 Now I want to go down and open a Word document, a blank one, 724 00:34:55,199 --> 00:34:57,630 so I'm going to click on the blue W. 725 00:34:57,630 --> 00:35:02,400 And just like in Excel, we have a list of recent files. 726 00:35:02,400 --> 00:35:05,640 We also have our blank, and our templates. 727 00:35:05,640 --> 00:35:09,240 We can either click on blank, or click Escape, 728 00:35:09,240 --> 00:35:12,130 and there's our new blank Word document. 729 00:35:12,130 --> 00:35:12,630 There it is. 730 00:35:12,630 --> 00:35:16,020 That's a terrible name up there, "Document1." 731 00:35:16,020 --> 00:35:18,720 So we want to immediately name it. 732 00:35:18,720 --> 00:35:21,150 Even before we do anything, we're always 733 00:35:21,150 --> 00:35:22,570 going to do that in this class. 734 00:35:22,570 --> 00:35:24,650 We're always going to open up a blank Excel 735 00:35:24,650 --> 00:35:26,970 workbook, PowerPoint, Word. 736 00:35:26,970 --> 00:35:28,590 And the first thing we're going to do, 737 00:35:28,590 --> 00:35:30,506 or what we're going to try to do in the first, 738 00:35:30,506 --> 00:35:34,860 is to save it with a good name in the right location. 739 00:35:34,860 --> 00:35:38,550 Now I don't want to go up to File, Save 740 00:35:38,550 --> 00:35:42,270 and I don't want to do Control S because that opens up Save As 741 00:35:42,270 --> 00:35:44,220 and I have to click all these times. 742 00:35:44,220 --> 00:35:47,070 We're going to use F12 every time we 743 00:35:47,070 --> 00:35:49,380 save a file for the first time. 744 00:35:49,380 --> 00:35:50,042 Now here it is. 745 00:35:50,042 --> 00:35:51,250 Where do you want to save it? 746 00:35:51,250 --> 00:35:53,340 I'm going to click the triangle in Kingston, 747 00:35:53,340 --> 00:35:55,230 or whatever your jump drive is. 748 00:35:55,230 --> 00:35:58,860 And we're going to click on 02 Word File. 749 00:35:58,860 --> 00:36:01,080 Now once you've changed the extension, 750 00:36:01,080 --> 00:36:04,950 all of us should be able to see .DOC I'm going to click, 751 00:36:04,950 --> 00:36:09,450 it highlights everything, and I'm going to call this "My 752 00:36:09,450 --> 00:36:10,770 First Document." 753 00:36:10,770 --> 00:36:13,620 Now I'm going to click the drop down here. 754 00:36:13,620 --> 00:36:19,370 And the most common file extension for us in Word, 755 00:36:19,370 --> 00:36:21,730 it's going to say DOCX. 756 00:36:21,730 --> 00:36:25,140 In Excel, it's going to say XLSX. 757 00:36:25,140 --> 00:36:28,740 In PowerPoint, it'll say PPTX. 758 00:36:28,740 --> 00:36:33,750 But right below the X version is an M version. 759 00:36:33,750 --> 00:36:38,670 If you ever see an M version, especially emailed to you 760 00:36:38,670 --> 00:36:40,620 from someone you don't know, you've 761 00:36:40,620 --> 00:36:45,000 got to be suspicious because M means macro. 762 00:36:45,000 --> 00:36:46,140 I clicked it. 763 00:36:46,140 --> 00:36:51,240 Macro means that this file has the ability 764 00:36:51,240 --> 00:36:55,010 to have code behind the scenes. 765 00:36:55,010 --> 00:36:57,480 Now in our Excel portion of this class, 766 00:36:57,480 --> 00:37:02,100 we're not going to write code, but we are going to use files, 767 00:37:02,100 --> 00:37:06,030 .XLSM, that have the ability to have code in them. 768 00:37:06,030 --> 00:37:09,270 It's more so because the files are from our class, 769 00:37:09,270 --> 00:37:10,550 we're going to trust it. 770 00:37:10,550 --> 00:37:15,240 But that's the M so that's an important part of file 771 00:37:15,240 --> 00:37:20,310 management, knowing that that M means macro, or code. 772 00:37:20,310 --> 00:37:22,800 That's in the notes in your handout too. 773 00:37:22,800 --> 00:37:27,190 The X, that's our standard file type in Office 774 00:37:27,190 --> 00:37:32,090 so I'm going to change this to DOCM. 775 00:37:32,090 --> 00:37:33,550 Where do you want to save it? 776 00:37:33,550 --> 00:37:35,614 Oh, to Word File folder. 777 00:37:35,614 --> 00:37:36,780 What do you want to call it? 778 00:37:36,780 --> 00:37:41,000 "My First Word Document," and the file extension is .DOCM. 779 00:37:41,000 --> 00:37:42,170 I'm going to click Save. 780 00:37:42,170 --> 00:37:48,290 Or, here's a great keyboard, any dialog box that we open-- 781 00:37:48,290 --> 00:37:51,440 and there are a lot of them in all the different programs. 782 00:37:51,440 --> 00:37:54,590 If there is a button that is highlighted, 783 00:37:54,590 --> 00:37:59,720 that means the Enter key will enact that button almost 784 00:37:59,720 --> 00:38:00,590 always. 785 00:38:00,590 --> 00:38:04,000 The Save button, or the Close button, 786 00:38:04,000 --> 00:38:06,890 you will see it highlighted in some color, in our case 787 00:38:06,890 --> 00:38:08,000 it's this blue. 788 00:38:08,000 --> 00:38:10,440 Now watch this, I'm going to hit Enter. 789 00:38:10,440 --> 00:38:15,590 And that clicked Save button, and we Saved As. 790 00:38:15,590 --> 00:38:18,720 Now I got to show you a great trick in Word just to be silly. 791 00:38:18,720 --> 00:38:20,910 Type an equal sign, that's the key 792 00:38:20,910 --> 00:38:22,710 to the left of the Backspace. 793 00:38:22,710 --> 00:38:30,030 And then type "RAND()" and watch this. 794 00:38:30,030 --> 00:38:33,360 When I hit Enter-- this is a secret trick in Word. 795 00:38:33,360 --> 00:38:34,260 Enter. 796 00:38:34,260 --> 00:38:38,010 It adds a bunch of written text. 797 00:38:38,010 --> 00:38:40,950 Now the reason that that's there is oftentimes people 798 00:38:40,950 --> 00:38:45,270 want to teach certain formatting tricks so that's a quick way 799 00:38:45,270 --> 00:38:46,710 to add a bunch of text. 800 00:38:46,710 --> 00:38:49,350 For us, I just wanted some text there 801 00:38:49,350 --> 00:38:52,350 because now I'm going to Control S. Now, 802 00:38:52,350 --> 00:38:55,800 I'm going to either use the S up here, or Alt F4, 803 00:38:55,800 --> 00:39:00,000 and we're going to use Windows Explorer to verify 804 00:39:00,000 --> 00:39:03,330 that our file got saved to the right location. 805 00:39:03,330 --> 00:39:06,150 And sure enough, it did. 806 00:39:06,150 --> 00:39:09,060 Now I'm going to double-click and open this, 807 00:39:09,060 --> 00:39:13,260 and we got to talk about one last thing in this first video. 808 00:39:13,260 --> 00:39:19,000 These are Ribbon Tabs, so each one of these. 809 00:39:19,000 --> 00:39:22,600 If I click the Insert, I can see everything pretty clearly, 810 00:39:22,600 --> 00:39:24,220 but watch what happens. 811 00:39:24,220 --> 00:39:26,590 This is called the Titlebar. 812 00:39:26,590 --> 00:39:29,500 Over in the Titlebar that's the Minimize button. 813 00:39:29,500 --> 00:39:32,170 Now Minimize doesn't close it. 814 00:39:32,170 --> 00:39:35,020 It just minimizes it down to the Taskbar 815 00:39:35,020 --> 00:39:37,060 so I'm going to click on this again. 816 00:39:37,060 --> 00:39:39,310 That un-minimizes it. 817 00:39:39,310 --> 00:39:42,610 This one right here is called Restore Down. 818 00:39:42,610 --> 00:39:44,900 Now, let's click Restore Down. 819 00:39:44,900 --> 00:39:48,370 Oh, it makes it a much smaller size. 820 00:39:48,370 --> 00:39:52,000 Now, you have control over this Restore Down. 821 00:39:52,000 --> 00:39:54,120 You can point to one of the edges, 822 00:39:54,120 --> 00:39:56,080 and when you see your horizontal arrow, 823 00:39:56,080 --> 00:39:59,010 you can move it in, or move it back. 824 00:39:59,010 --> 00:40:01,860 You can point to the corner, and click and drag, 825 00:40:01,860 --> 00:40:06,780 but the important thing is our Ribbon Tabs are totally 826 00:40:06,780 --> 00:40:09,480 changing, and they will always change 827 00:40:09,480 --> 00:40:14,310 depending on the size of the window or the screen 828 00:40:14,310 --> 00:40:16,000 resolution. 829 00:40:16,000 --> 00:40:17,880 Now I'm going to maximize this. 830 00:40:17,880 --> 00:40:21,150 There's actually a keyboard for maximizing, 831 00:40:21,150 --> 00:40:23,130 and restoring windows. 832 00:40:23,130 --> 00:40:26,580 If you find the Window key, Window Down Arrow, 833 00:40:26,580 --> 00:40:28,890 and Window Up Arrow. 834 00:40:28,890 --> 00:40:31,710 Window Down Arrow restores it down 835 00:40:31,710 --> 00:40:34,410 to whatever size you last had, and Window Up Arrow 836 00:40:34,410 --> 00:40:36,090 maximizes it. 837 00:40:36,090 --> 00:40:38,790 All right, I'm going to close this, Alt F4. 838 00:40:38,790 --> 00:40:42,750 Go over to the Excel file, double-click this My First 839 00:40:42,750 --> 00:40:46,320 Excel file, and I'm going to click Restore Down, 840 00:40:46,320 --> 00:40:48,820 or use Window Down Arrow. 841 00:40:48,820 --> 00:40:53,320 Now if I come over and squeeze this way in, 842 00:40:53,320 --> 00:40:57,750 the buttons just totally change so 843 00:40:57,750 --> 00:40:59,640 be aware that sometimes you might 844 00:40:59,640 --> 00:41:02,190 have to hunt around for things. 845 00:41:02,190 --> 00:41:05,370 All of the buttons are still there under Editing, 846 00:41:05,370 --> 00:41:07,980 they were just-- you have to click the little drop down. 847 00:41:07,980 --> 00:41:13,380 So now if I Window Up Arrow, notice Editing, 848 00:41:13,380 --> 00:41:15,150 that's the name of the group. 849 00:41:15,150 --> 00:41:20,190 So when I either Restore Down, or Window Down Arrow, 850 00:41:20,190 --> 00:41:22,320 editing is what will show up. 851 00:41:22,320 --> 00:41:26,370 Window up arrow to maximize up, Alt F4. 852 00:41:26,370 --> 00:41:31,410 So in this first video, we had a tour of operating systems, 853 00:41:31,410 --> 00:41:33,660 the Desktop, the Start button. 854 00:41:33,660 --> 00:41:36,210 We talked about Windows Explorer, the left 855 00:41:36,210 --> 00:41:37,770 and the right side. 856 00:41:37,770 --> 00:41:40,140 We created some folders. 857 00:41:40,140 --> 00:41:42,000 We created some files. 858 00:41:42,000 --> 00:41:43,920 We talked about file extensions. 859 00:41:43,920 --> 00:41:46,980 We showed how to show those extensions. 860 00:41:46,980 --> 00:41:48,720 We talked about ribbons. 861 00:41:48,720 --> 00:41:53,040 We talked about ribbons, and even the Backstage View. 862 00:41:53,040 --> 00:41:55,090 Now when we come back in our next video, 863 00:41:55,090 --> 00:41:58,260 we're going to just stay in Windows Explorer, 864 00:41:58,260 --> 00:42:01,860 and just see how to create some folders, 865 00:42:01,860 --> 00:42:04,740 and use Windows Explorer to do file management. 866 00:42:04,740 --> 00:42:07,950 Then in our third video for the first week, 867 00:42:07,950 --> 00:42:12,030 we'll create an entire comprehensive system of folders 868 00:42:12,030 --> 00:42:14,280 for our entire class. 869 00:42:14,280 --> 00:42:16,330 All right, that was a lot of fun. 870 00:42:16,330 --> 00:42:19,370 We'll see you next video.