1 00:00:01,340 --> 00:00:06,920 Let's take a look at some simple ways you can customize the Excel interface so you can easily find the 2 00:00:06,920 --> 00:00:10,220 files and also features you use often. 3 00:00:10,220 --> 00:00:12,150 Let's start with files first. 4 00:00:12,280 --> 00:00:14,030 Go to the File menu. 5 00:00:14,060 --> 00:00:17,430 Here you see the most recent files you've used. 6 00:00:17,450 --> 00:00:20,300 If there is a file you need to come back too often. 7 00:00:20,330 --> 00:00:25,940 You can pin it. Hover over the file name and click on the pin icon here. 8 00:00:25,970 --> 00:00:28,390 Let's say I also need to come back to this one. 9 00:00:28,520 --> 00:00:31,150 I'm going to click on the pin icon here. 10 00:00:31,160 --> 00:00:35,220 What happens is these files get pinned right here. 11 00:00:35,300 --> 00:00:40,910 So no matter what your recent files where, these documents are going to be available under the pinned items. 12 00:00:40,970 --> 00:00:47,480 To unpin something just hover over it and click to unpin. 13 00:00:47,480 --> 00:00:53,070 Now let's take a look at finding some of the common Excel features you use from the ribbon. 14 00:00:53,120 --> 00:00:55,710 How about customizing the ribbon. 15 00:00:55,730 --> 00:00:57,410 What options do we have? 16 00:00:57,440 --> 00:01:01,700 Just right mouse click on the ribbon, select customize the ribbon. 17 00:01:01,700 --> 00:01:08,440 This takes you automatically to Excel options, to customize ribbon. On the right hand side here 18 00:01:08,600 --> 00:01:14,480 you can see your tabs and the grouping which are the current categories inside the tab. 19 00:01:14,480 --> 00:01:16,200 So take a look at your home tab. 20 00:01:16,310 --> 00:01:17,320 We have clipboard. 21 00:01:17,330 --> 00:01:19,220 We have font alignment. 22 00:01:19,220 --> 00:01:20,930 Everything we see here. 23 00:01:21,050 --> 00:01:23,000 They have a check mark. By default 24 00:01:23,000 --> 00:01:24,290 they're available. 25 00:01:24,410 --> 00:01:27,560 So notice for me I have the developer tab activated. 26 00:01:27,560 --> 00:01:29,930 There's a check mark beside mine. 27 00:01:30,020 --> 00:01:34,670 If you're using add-ins to other systems you'll see them here as well. 28 00:01:34,670 --> 00:01:40,460 One option to customize the ribbon is to create your own tab. Just click on new tab. 29 00:01:40,460 --> 00:01:42,890 You can give your tab a name. 30 00:01:42,890 --> 00:01:45,920 I'm going to rename mine to Leila. 31 00:01:45,980 --> 00:01:50,270 Now I can add the different features or groups I often use. 32 00:01:50,270 --> 00:01:53,570 I can make my selection from the popular commands. 33 00:01:53,650 --> 00:02:00,520 If it's not easy to find something you can change your view here to see all tabs. 34 00:02:00,530 --> 00:02:06,290 This is going to show it in this view that we currently see, so it may be easier to find something. 35 00:02:06,290 --> 00:02:08,690 So let's see from the Home tab. 36 00:02:08,870 --> 00:02:11,850 I want to add the entire font grouping. 37 00:02:11,960 --> 00:02:16,040 I'm just going to click on Add. From The View tab, 38 00:02:16,040 --> 00:02:18,710 I want to add the grid lines. 39 00:02:18,740 --> 00:02:20,410 So show grid lines. 40 00:02:20,540 --> 00:02:22,280 Let's just click on new group. 41 00:02:22,280 --> 00:02:23,870 That's where I to add it. 42 00:02:23,870 --> 00:02:24,970 Click on add. 43 00:02:25,010 --> 00:02:28,640 Let's also add some zoom options here. 44 00:02:28,640 --> 00:02:33,680 Let's click on new group and click on add. Under review, proofing. 45 00:02:33,680 --> 00:02:35,320 Let's add the spelling. 46 00:02:35,570 --> 00:02:38,550 So I can add it to this group or create a new group. 47 00:02:38,570 --> 00:02:42,830 Just click on add and I can rename this to what I want. 48 00:02:42,860 --> 00:02:44,450 Once I'm done click on Ok. 49 00:02:44,570 --> 00:02:50,990 Do you notice what happened? I got a new tab here called Leila. 50 00:02:51,260 --> 00:02:57,950 I have my new group here with the features from the different tabs all under one tab. 51 00:02:57,950 --> 00:03:02,840 So once you've worked with Excel for a bit and you notice there is specific features that you need 52 00:03:02,870 --> 00:03:08,350 often you can bring them all together in your own tab. To remove the tab, 53 00:03:08,360 --> 00:03:14,680 You just have to go back to customizing the ribbon and just uncheck the new tab. 54 00:03:14,690 --> 00:03:16,630 So this basically hides it. 55 00:03:16,670 --> 00:03:21,170 It keeps it there so if you need it you can go back and put a checkmark. If you don't need it 56 00:03:21,170 --> 00:03:26,900 You can uncheck it. To fully delete it, click on remove and then click on Ok 57 00:03:26,950 --> 00:03:26,960 . 58 00:03:27,020 --> 00:03:34,160 and it's gone. Another way to make your most common features accessible is to use the quick access toolbar. 59 00:03:34,190 --> 00:03:39,280 So this Mini Toolbar you see here is called the QAT, quick access toolbar. 60 00:03:39,290 --> 00:03:45,410 Now in my case I've added print preview and print and sending the document as an email attachment in 61 00:03:45,410 --> 00:03:51,200 here. Because this means that every time I need to do those actions it doesn't matter where I am. 62 00:03:51,230 --> 00:03:53,000 I just have to click here. 63 00:03:53,030 --> 00:03:54,420 How did I add these? 64 00:03:54,560 --> 00:03:57,510 We'll just click on this down arrow here. 65 00:03:57,530 --> 00:03:59,900 The most common options are available here. 66 00:03:59,900 --> 00:04:05,600 So for email you just have to select it to put a checkmark. Then print preview and print just select it 67 00:04:05,600 --> 00:04:12,710 to get it added. If you want to add spelling or quick print just select it once and that adds it to your 68 00:04:12,710 --> 00:04:19,279 quick access toolbar. If there is a feature that you use often and you don't see it here, you can go to 69 00:04:19,339 --> 00:04:20,589 more commands. 70 00:04:20,600 --> 00:04:23,250 This again takes you to your Excel options. 71 00:04:23,360 --> 00:04:29,840 But this time to your quick access toolbar and here you can find the command you're looking for. 72 00:04:29,840 --> 00:04:34,280 Just select it and add it to your quick access toolbar. 73 00:04:34,490 --> 00:04:39,440 Again if you don't find it here, you can switch your view by selecting the actual tab. 74 00:04:39,440 --> 00:04:45,110 So if it's something inside the Home tab just select the Home tab here, find the feature you're looking for 75 00:04:45,200 --> 00:04:47,050 and send it to the other side. 76 00:04:47,060 --> 00:04:53,680 You can also organize your commands by using these up and down arrows and then click on OK. 77 00:04:53,690 --> 00:05:00,740 Now an easier way of adding features to your quick access toolbar is to right mouse click on the icon 78 00:05:00,760 --> 00:05:02,370 directly on the ribbon. 79 00:05:02,590 --> 00:05:08,740 So let's say in the view tab I use the grid lines often. I just have to right mouse click it and say 80 00:05:08,850 --> 00:05:16,450 add to quick access toolbar. It adds it here. So I can click it and click it again to show and remove 81 00:05:16,450 --> 00:05:17,280 grid lines. 82 00:05:17,290 --> 00:05:21,340 The advantage of this is that it doesn't matter which Tab I'm in. 83 00:05:21,340 --> 00:05:25,010 These features are always going to be accessible to me. 84 00:05:25,090 --> 00:05:29,510 If this gets too long, so my list of features comes all the way here. 85 00:05:29,560 --> 00:05:35,140 I can also switch to show the toolbar below the ribbon. To switch it back, 86 00:05:35,140 --> 00:05:39,380 Click on the down arrow and select show above the ribbon. 87 00:05:39,380 --> 00:05:45,250 If there is something you added in there that you don't need anymore, right mouse click, remove from quick 88 00:05:45,250 --> 00:05:46,580 access toolbar. 89 00:05:46,630 --> 00:05:52,720 The great thing is that what I've showed you in this lecture is also applicable to other office programs 90 00:05:53,020 --> 00:05:54,850 like Word and PowerPoint. 91 00:05:54,850 --> 00:06:00,100 These tips will make it easier for you to find the files and features you use often.