1 00:00:02,200 --> 00:00:02,660 Excel's menu 2 00:00:02,660 --> 00:00:05,370 is referred to as the ribbon. 3 00:00:05,390 --> 00:00:09,270 It consists of different sections which are called Tabs. 4 00:00:09,320 --> 00:00:12,880 Currently I'm in the Home tab which is the most common tab. 5 00:00:13,040 --> 00:00:18,690 If I click on insert, the menu options change by giving me different choices. 6 00:00:18,740 --> 00:00:23,440 These are basically different buttons grouped together in categories. 7 00:00:23,540 --> 00:00:29,530 Some of these, you're never gonna need. Some you're going to use a lot, and some from time to time. 8 00:00:29,690 --> 00:00:34,600 If you move your mouse over an icon, you're going to get more information on the feature. 9 00:00:34,820 --> 00:00:37,320 Sometimes you're going to get a shortcut 10 00:00:37,340 --> 00:00:44,420 You can use to get to that feature. On some of the sections on the menu, you're going to see a tilted 11 00:00:44,540 --> 00:00:46,730 arrow on the side here. 12 00:00:46,730 --> 00:00:48,480 Not all of them have it. 13 00:00:48,500 --> 00:00:50,080 Some of them do. 14 00:00:50,150 --> 00:00:56,240 If you click on it, it's going to bring up another dialog box that's going to offer you more options 15 00:00:56,360 --> 00:00:58,690 than the ones you have here. 16 00:00:58,820 --> 00:01:04,519 You also have the option to collapse the ribbon so you have more space to work with. 17 00:01:04,519 --> 00:01:06,470 So just click on that arrow here. 18 00:01:06,650 --> 00:01:12,550 The ribbon gets collapsed and every time you click on a tab, it's going to show you the icons there. 19 00:01:12,560 --> 00:01:16,850 Once you click away, it's going to disappear. To bring back the ribbon. 20 00:01:16,850 --> 00:01:22,520 Just click on any of these tabs and click on this pin icon on the side. 21 00:01:22,580 --> 00:01:28,610 The search box here can come in really handy if you're looking for features but you're not sure where 22 00:01:28,610 --> 00:01:29,630 they are. 23 00:01:29,630 --> 00:01:35,300 So for example, if I want to do a spell check I can just start typing here. 24 00:01:35,720 --> 00:01:37,280 I see spelling here. 25 00:01:37,280 --> 00:01:40,730 I can even see the shortcut key. If I click on it, 26 00:01:40,790 --> 00:01:45,020 It's actually gonna run that feature. Spell check is complete. 27 00:01:45,050 --> 00:01:46,070 I'm good to go. 28 00:01:46,070 --> 00:01:47,970 No spelling mistakes. 29 00:01:48,260 --> 00:01:51,120 The File tab is different to the rest. 30 00:01:51,170 --> 00:01:57,470 It takes us to another interface of Excel which is commonly referred to as the backstage view. 31 00:01:57,470 --> 00:02:00,620 Here you see information about your document. 32 00:02:00,650 --> 00:02:05,830 So if you've saved a few versions of it you can see the version history right here. 33 00:02:05,840 --> 00:02:12,950 If someone asks you what version of Excel do you have, you can see it under account information right 34 00:02:12,950 --> 00:02:14,030 here. 35 00:02:14,030 --> 00:02:18,890 If you want to check out the printing layout or some printing options you can do that here. 36 00:02:18,890 --> 00:02:21,790 Now to get back to your workbook. 37 00:02:21,800 --> 00:02:25,720 You can either click on this arrow or use the escape key. 38 00:02:25,730 --> 00:02:31,040 What I suggest you do is take a few moments and take a look at the ribbon and the different options 39 00:02:31,130 --> 00:02:32,550 and features we have. 40 00:02:32,570 --> 00:02:34,440 You don't have to understand what they are. 41 00:02:34,450 --> 00:02:39,050 We're going to be covering all of the essential ones in the course but it's just good that you get a 42 00:02:39,050 --> 00:02:42,490 feeling of what is where. To get you started, 43 00:02:42,500 --> 00:02:47,780 I'm gonna share my most common features that I use when I use Excel. 44 00:02:47,860 --> 00:02:51,360 A lot of the features on the Home tab come in really handy. 45 00:02:51,380 --> 00:02:57,680 So for example font, alignment, number, etc. Just keep in mind that this is the most expensive real estate 46 00:02:57,680 --> 00:03:02,390 on the ribbon so only features that are useful to a wide variety of users 47 00:03:02,420 --> 00:03:05,480 Actually make it here. In the view tab, 48 00:03:05,600 --> 00:03:09,550 You can remove grid lines or show grid lines. 49 00:03:09,680 --> 00:03:14,510 So this is one of the most common features I use. 50 00:03:14,510 --> 00:03:17,730 From the insert tab, I use charts tables and pivot tables. 51 00:03:17,820 --> 00:03:23,630 Now you might not have the developer tab, this is something I've activated to be able to work with 52 00:03:23,630 --> 00:03:25,990 form controls and Visual Basic. 53 00:03:26,060 --> 00:03:29,930 It's something that you might need when you become advanced in Excel. 54 00:03:30,140 --> 00:03:36,440 So take a few moments before you move on and check out the options available in the ribbon. 55 00:03:36,440 --> 00:03:36,950 In the next lecture 56 00:03:37,100 --> 00:03:43,820 let's take a look at how we can customize the Excel interface so it's easier to find the stuff we work 57 00:03:43,820 --> 00:03:44,890 with the most.