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