WEBVTT Kind: captions Language: en 00:00:12.259 --> 00:00:16.299 Before you get started on your first workbook, you might want to take a minute to explore 00:00:16.299 --> 00:00:21.100 your Excel environment in detail, and customize it in a way that will work for you. 00:00:21.100 --> 00:00:25.710 For example, the Ribbon contains multiple tabs, each with several groups of commands. 00:00:25.710 --> 00:00:29.780 Did you know you can create your own tabs and your own groups to make your favorite 00:00:29.780 --> 00:00:31.279 commands more convenient? 00:00:31.279 --> 00:00:32.279 It's easy. 00:00:32.279 --> 00:00:37.960 Just right click anywhere on the Ribbon, and choose Customize the Ribbon. 00:00:37.960 --> 00:00:41.440 Now click New Tab to add a new tab of your own. 00:00:41.440 --> 00:00:45.791 Your new tab appears on the list, along with a new group, which is the part of the tab 00:00:45.791 --> 00:00:47.629 that will hold your commands. 00:00:47.629 --> 00:00:51.579 You can even add commands to any of the main tabs - like the Home tab - as long as you 00:00:51.579 --> 00:00:53.929 create a new group in that tab. 00:00:53.929 --> 00:00:58.350 Now, make sure your new group is selected, then look to the list on the left for the 00:00:58.350 --> 00:00:59.909 commands you'd like to add. 00:00:59.909 --> 00:01:04.680 I want my custom tab to have a group devoted to design elements like borders, fill colors, 00:01:04.680 --> 00:01:08.500 and graphics, so - I immediately see Borders at the top. 00:01:08.500 --> 00:01:11.650 All you have to do is click the command, then Add. 00:01:11.650 --> 00:01:21.390 Another way to add commands is to drag and drop them from one list to the other. 00:01:21.390 --> 00:01:25.550 Now I'd like to give my tab a name, something personalized that'll help me find it on the 00:01:25.550 --> 00:01:26.550 Ribbon. 00:01:26.550 --> 00:01:31.030 Just select the tab, click Rename, and enter it here. 00:01:31.030 --> 00:01:38.150 I'm going name mine "Design Shortcuts." 00:01:38.150 --> 00:01:41.200 When you're done, click OK. 00:01:41.200 --> 00:01:42.930 And here's my custom tab. 00:01:42.930 --> 00:01:47.800 Now, if you find the Ribbon is taking up too much space on your screen, you can minimize 00:01:47.800 --> 00:01:51.170 it by clicking the tiny arrow in the upper right corner. 00:01:51.170 --> 00:01:55.240 When the Ribbon is minimized, you can make it reappear by clicking any one of the tabs, 00:01:55.240 --> 00:01:58.560 but it will disappear again when you're not using it. 00:01:58.560 --> 00:02:02.420 We're going to go ahead and expand the Ribbon again, then turn our attention to the Quick 00:02:02.420 --> 00:02:05.710 Access Toolbar in the upper left corner. 00:02:05.710 --> 00:02:09.110 Designed to give you access to frequently used commands no matter where you are on the 00:02:09.110 --> 00:02:15.390 Ribbon, it includes Save, Undo, and Repeat by default, but can be customized to also 00:02:15.390 --> 00:02:16.970 include your favorites. 00:02:16.970 --> 00:02:21.790 I personally use New and Open a lot, for creating and opening workbooks, so I'm going to click 00:02:21.790 --> 00:02:26.819 the drop-down arrow here to customize the toolbar, and add those commands. 00:02:26.819 --> 00:02:32.349 Finally, if you're familiar with Excel 2007, you may have noticed that the Office button 00:02:32.349 --> 00:02:33.680 is missing. 00:02:33.680 --> 00:02:36.250 It's been replaced by the File tab. 00:02:36.250 --> 00:02:40.430 The File tab takes you to the new Backstage view, where you can explore all the options 00:02:40.430 --> 00:02:43.159 related to your current workbook and more. 00:02:43.159 --> 00:02:49.260 That includes things like Print, Save & Send, and Recent files. 00:02:49.260 --> 00:02:53.099 It's everything you would have found in the old Office or File menu, except now you have 00:02:53.099 --> 00:02:54.930 a nice full-page view. 00:02:54.930 --> 00:02:58.750 For example, I like the convenience of being able to see all the workbooks I've worked 00:02:58.750 --> 00:03:03.709 on most recently, so I can pick up right where I left off. 00:03:03.709 --> 00:03:06.430 That covers the Excel environment in detail. 00:03:06.430 --> 00:03:10.540 Now that we know how to use and customize the different features - including the Backstage 00:03:10.540 --> 00:03:40.230 view, the Ribbon, and the Quick Access Toolbar - we can start our first workbook!