1 00:00:01,070 --> 00:00:04,040 Most people using Excel will be on a PC. 2 00:00:04,040 --> 00:00:10,880 We will use the PC version of Excel for all our future courses on data analysis. 3 00:00:10,880 --> 00:00:13,800 Let me take you through a brief tour of the Excel interface. 4 00:00:14,820 --> 00:00:18,630 So here we are looking at a blank spreadsheet in Excel. 5 00:00:18,630 --> 00:00:25,230 You can see the basic tabular format of columns and rows. 6 00:00:25,230 --> 00:00:27,200 Also, there's a sheet down below. 7 00:00:28,550 --> 00:00:33,350 We can add more sheets by clicking the plus button or 8 00:00:33,350 --> 00:00:41,110 by going to the Insert command on the Home tab and scrolling down to Insert Sheet. 9 00:00:42,150 --> 00:00:46,450 Notice that in parenthesis there is a keyboard shortcut of Shift+F11 10 00:00:46,450 --> 00:00:48,020 to add a sheet that way. 11 00:00:50,090 --> 00:00:55,860 At the top of the Excel interface, there is what is called a Quick Access tool bar. 12 00:00:55,860 --> 00:01:02,030 By default, it should have the Save, Undo and repeat commands available. 13 00:01:03,110 --> 00:01:07,510 If you click this arrow on the right you can customize the quick access toolbar. 14 00:01:08,590 --> 00:01:12,520 You can click different commands that you wanna add so I just clicked open and 15 00:01:12,520 --> 00:01:13,520 added it to the toolbar. 16 00:01:14,900 --> 00:01:17,290 You can also click to remove commands. 17 00:01:18,510 --> 00:01:21,190 Then we have what is called the ribbon in Excel. 18 00:01:23,290 --> 00:01:26,980 There's the Insert tab, the Page Layout tab and so forth. 19 00:01:28,260 --> 00:01:33,240 Each of these tabs has there own tool bar beneath it. 20 00:01:33,240 --> 00:01:36,070 For example if I click on the Data tab in the ribbon 21 00:01:37,340 --> 00:01:38,980 beneath it is the Data tool bar. 22 00:01:40,120 --> 00:01:43,840 And this is where you can see the Sort command, and the Filter command, 23 00:01:43,840 --> 00:01:47,100 and other features and commands related to data analysis. 24 00:01:48,130 --> 00:01:54,030 Under the View tab, you can freeze panes, or set page layouts. 25 00:01:55,150 --> 00:01:56,890 You can adjust the Zoom level as well. 26 00:01:58,180 --> 00:02:00,550 This is really helpful when you're on a video call and 27 00:02:00,550 --> 00:02:02,297 are sharing your screen with someone. 28 00:02:07,870 --> 00:02:11,527 Then we have the Formula Bar below the Tool Bar. 29 00:02:15,561 --> 00:02:19,897 Excel has a ton of features and commands, it also gives you several different 30 00:02:19,897 --> 00:02:23,560 options to customize the software, for your needs. 31 00:02:23,560 --> 00:02:28,540 In just a few seconds, I'll briefly cover some of the customization options. 32 00:02:28,540 --> 00:02:31,390 In future courses we'll cover more of the features and 33 00:02:31,390 --> 00:02:34,410 commands available to you in Excel. 34 00:02:34,410 --> 00:02:39,480 Some of you might have been wondering why my ribbon has the developer cabinet and 35 00:02:39,480 --> 00:02:40,790 yours does not. 36 00:02:40,790 --> 00:02:43,590 Well it is because that view isn't set by default. 37 00:02:44,910 --> 00:02:51,930 If you click on the File tab and go to Options down at the bottom, this 38 00:02:51,930 --> 00:02:56,880 is where you can change default settings and customize excel to suit your needs. 39 00:02:57,980 --> 00:03:03,790 For example, if I click Customize Ribbon, I can change what 40 00:03:03,790 --> 00:03:09,548 tabs are visible on the ribbon and what commands are on those tab's tool bars. 41 00:03:10,610 --> 00:03:13,820 So here, Developer is checked. 42 00:03:13,820 --> 00:03:18,860 If I uncheck it, and et's just remove view as well then click OK. 43 00:03:18,860 --> 00:03:21,210 Now you can see those tabs are removed from the ribbon. 44 00:03:24,690 --> 00:03:27,760 But I want those on there, so I'm gonna go back and add them back in. 45 00:03:30,330 --> 00:03:34,920 You can also create your own custom tabs here, by adding new tabs and 46 00:03:34,920 --> 00:03:37,240 then creating groups of commands underneath them. 47 00:03:38,640 --> 00:03:41,340 There's other ways that you can change the preferences as well. 48 00:03:41,340 --> 00:03:45,407 So if I go to general, I can change the Office theme color for example. 49 00:03:50,804 --> 00:03:54,142 There are lots of customization options. 50 00:03:54,142 --> 00:03:55,633 As you continue to use Excel, 51 00:03:55,633 --> 00:03:59,700 you may find yourself having to repeatedly change certain formats or settings. 52 00:04:00,720 --> 00:04:03,723 That is a good sign for you to consider changing your preferences. 53 00:04:05,562 --> 00:04:08,808 My favorite feature by far for Excel on PCs, 54 00:04:08,808 --> 00:04:12,510 is the robust Keyboard Shortcut functionality. 55 00:04:13,660 --> 00:04:17,320 You can get to almost any command using Keyboard Shortcuts. 56 00:04:17,320 --> 00:04:24,980 So, if I press Alt, you can see a bunch of letters pop up across the different tabs. 57 00:04:24,980 --> 00:04:26,490 Those are the keyboard shortcuts. 58 00:04:27,560 --> 00:04:31,430 Let's go back and change our theme again using only keyboard shortcuts. 59 00:04:31,430 --> 00:04:33,050 So I've pressed ALT. 60 00:04:33,050 --> 00:04:34,500 I pressed F to go to File. 61 00:04:34,500 --> 00:04:39,050 You can see that, if I wanted to go to Page Layout I'd press P. 62 00:04:39,050 --> 00:04:43,260 But we know that we need to go to the Options settings so I'm gonna do AL+ F. 63 00:04:44,710 --> 00:04:47,720 And then again, there's all these letters as shortcuts. 64 00:04:47,720 --> 00:04:49,635 I'm gonna go down to options and it says T. 65 00:04:49,635 --> 00:04:53,820 Now here we are in this window and 66 00:04:53,820 --> 00:04:59,090 you can see the underlined letters signify keyboard shortcut. 67 00:05:00,200 --> 00:05:03,856 So if I wanted to change this show mini toolbar on selection. 68 00:05:03,856 --> 00:05:06,257 I press Alt+M, 69 00:05:06,257 --> 00:05:10,620 and you can see that without using my mouse, I was able to change that setting. 70 00:05:10,620 --> 00:05:12,510 I've just added it back. 71 00:05:12,510 --> 00:05:14,150 But we wanna change the theme. 72 00:05:14,150 --> 00:05:19,160 So if we look down here, we can see Office Theme, 73 00:05:19,160 --> 00:05:23,620 T is the keyboard shortcut so I press Alt+T. 74 00:05:23,620 --> 00:05:26,200 So now it has that selected I press the up arrow. 75 00:05:27,570 --> 00:05:32,224 And here I can go I can change it so I'm going up and I'm gonna go back to 76 00:05:32,224 --> 00:05:38,060 Colorful, return and- We're good. 77 00:05:38,060 --> 00:05:42,010 This robust keyboard shortcut functionality means you can speed up your 78 00:05:42,010 --> 00:05:44,229 workflow by avoiding using your mouse. 79 00:05:45,280 --> 00:05:49,040 As you use Excel try to memorize the shortcuts for commands you use a lot. 80 00:05:50,060 --> 00:05:53,780 It's even better if you can get in the habit of starting by pressing Alt 81 00:05:55,060 --> 00:05:58,030 to navigate around the spreadsheet instead of using your mouse. 82 00:05:59,430 --> 00:06:03,070 I have heard of some investment banking analyst programs requiring 83 00:06:03,070 --> 00:06:06,880 that their analysts don't use a mouse as part of their training. 84 00:06:06,880 --> 00:06:10,480 I want to leave you with my favorite keyboard shortcut for Excel on a PC, 85 00:06:10,480 --> 00:06:12,310 which is paste special. 86 00:06:13,380 --> 00:06:19,203 So I'm just gonna create a very simple formula here, 4+4, 8. 87 00:06:19,203 --> 00:06:26,214 So I use paste special all the time, and I'm just gonna copy this 8. 88 00:06:27,690 --> 00:06:30,728 And then the shortcut for paste special is Alt+E+S. 89 00:06:30,728 --> 00:06:34,970 And then that gets us to paste special. 90 00:06:34,970 --> 00:06:38,240 And then you can see there's all these different versions of it. 91 00:06:38,240 --> 00:06:42,510 But each of these all have underlined letters which will allow you to continue 92 00:06:42,510 --> 00:06:43,708 with the shortcuts. 93 00:06:43,708 --> 00:06:47,550 So I'm gonna escape and then just show you this real quickly again. 94 00:06:47,550 --> 00:06:51,160 I'm going to copy this 8 and then I'm going to paste the value here. 95 00:06:51,160 --> 00:06:54,680 So paste special values Alt+E+S+V. 96 00:06:54,680 --> 00:07:00,970 Return for OK and you can see that we've pasted the value not the formula.