WEBVTT Kind: captions Language: en 00:00:06.629 --> 00:00:10.910 Let's begin by taking a look at your Excel environment and some of the things you can 00:00:10.910 --> 00:00:16.460 do to set up your Excel environment to make working in Excel easier for you. 00:00:16.460 --> 00:00:21.689 Down at the bottom of the Excel window you have the Sheet tabs, which are each separate 00:00:21.689 --> 00:00:25.720 worksheets. They remind me of pages in a book. 00:00:25.720 --> 00:00:30.710 All the Sheets together make up the workbook, or spreadsheet. 00:00:30.710 --> 00:00:35.720 To the right, is the Zoom tool. You can zoom in and out by left-clicking the 00:00:35.720 --> 00:00:42.720 slider and dragging it back and forth. You can also use the scroll bar above it to 00:00:42.920 --> 00:00:49.920 scroll left and right in the worksheet. In this same area, you also have access to 00:00:50.490 --> 00:00:56.430 the page view tabs. By default, the Normal View is selected, but 00:00:56.430 --> 00:01:02.850 you can change to Page Layout or Page Break View by left-clicking either option. 00:01:02.850 --> 00:01:08.570 Let's just leave it as the default. At the top of the page, you have the Ribbon, 00:01:08.570 --> 00:01:12.130 which is the new menu system that is arranged in tabs. 00:01:12.130 --> 00:01:16.600 On each tab you'll find commands organized in groups. 00:01:16.600 --> 00:01:20.090 Above the Ribbon, you'll see the Quick Access toolbar. 00:01:20.090 --> 00:01:25.399 One of the simplest things you can do to make accomplishing basic tasks faster is to customize 00:01:25.399 --> 00:01:30.219 the Quick Access toolbar. The Quick Access toolbar resides right next 00:01:30.219 --> 00:01:35.619 to the Microsoft Office Button in all the Office 2007 applications and allows you to 00:01:35.619 --> 00:01:41.969 reach commonly used commands quickly. By default, the Save, Undo, and Redo commands 00:01:41.969 --> 00:01:46.659 have already been added. To view the commands you can add, simply click 00:01:46.659 --> 00:01:52.009 the down arrow next to the Quick Access toolbar and a menu will appear. 00:01:52.009 --> 00:01:56.149 Let's see. Sort Ascending and Sort Descending are two 00:01:56.149 --> 00:02:01.749 commands that are used often in Excel, depending on the type of spreadsheet you work with. 00:02:01.749 --> 00:02:07.490 To add the Sort Ascending command, just left-click it to select it. 00:02:07.490 --> 00:02:12.319 And now we can see that it appears on the toolbar. 00:02:12.319 --> 00:02:16.630 As you can see, a check mark appeared beside Sort Ascending. 00:02:16.630 --> 00:02:19.680 This means it is selected and appears on the toolbar. 00:02:19.680 --> 00:02:26.680 To remove a command, just left-click any command with a check mark, and it will no longer appear. 00:02:26.840 --> 00:02:32.770 See how easy it is to add and remove commands? I'm actually going to add the Sort Ascending 00:02:32.770 --> 00:02:37.240 and Sort Descending commands. I think I may need to use them when I start 00:02:37.240 --> 00:02:42.450 working with some of my spreadsheets. You can add more commands than the ones that 00:02:42.450 --> 00:02:48.660 appear on the drop-down list. Just select More Commands, and from the dialog 00:02:48.660 --> 00:02:54.720 box that appears, select the command you wish to add, click the Add button, and then click 00:02:54.720 --> 00:02:58.890 OK. This gives you the ability to really customize 00:02:58.890 --> 00:03:02.260 Excel. While working with Excel, you may find that 00:03:02.260 --> 00:03:06.780 there are times that you want to work on your worksheet without the Ribbon. 00:03:06.780 --> 00:03:11.060 Microsoft gives you the ability to minimize and maximize the ribbon. 00:03:11.060 --> 00:03:17.030 To minimize the ribbon, click the drop-down arrow next to the Quick Access toolbar. 00:03:17.030 --> 00:03:21.530 Select Minimize Ribbon from the list. And the Ribbon disappears. 00:03:21.530 --> 00:03:25.590 Click the arrow again. You can see that a check mark appears next 00:03:25.590 --> 00:03:30.140 to Minimize the Ribbon, which indicates this feature is toggled on. 00:03:30.140 --> 00:03:34.880 To Maximize the Ribbon, just select Minimize the Ribbon to toggle the feature off, and 00:03:34.880 --> 00:03:39.250 the ribbon will appear. In addition to the Quick Access toolbar and 00:03:39.250 --> 00:03:43.790 the Ribbon, the Microsoft Office Button appears at the top of your window. 00:03:43.790 --> 00:03:47.350 When you left-click the button, you access a menu. 00:03:47.350 --> 00:03:54.350 From this menu, you can create a new document, open existing documents, save documents in 00:03:55.420 --> 00:04:02.420 a variety of ways, and print. You can also add security features, send the 00:04:05.660 --> 00:04:15.200 document, publish, and close the document. You can also click the Excel Options button 00:04:15.200 --> 00:04:19.819 to open a dialog box where you can make some changes to the default settings. 00:04:19.819 --> 00:04:26.160 In the Popular section, Show MiniToolbar is selected. 00:04:26.160 --> 00:04:32.290 This shows the information that appears when you hover over a command like this. 00:04:32.290 --> 00:04:36.570 If you're new to Excel, this information is helpful. 00:04:36.570 --> 00:04:40.930 If you're a poweruser, this may be more of an annoyance. 00:04:40.930 --> 00:04:43.810 You can turn this feature off here if you'd like. 00:04:43.810 --> 00:04:49.460 I'm actually going to leave this on. There are a lot of things you can change here. 00:04:49.460 --> 00:04:54.520 For instance, if you want four worksheets to appear by default, you can change that 00:04:54.520 --> 00:04:59.350 here. In the Formulas section, there are some more 00:04:59.350 --> 00:05:03.960 complicated settings. As you learn more about Excel and become proficient 00:05:03.960 --> 00:05:08.950 at using it, you may want to revisit these settings, but for now, we'll leave it as the 00:05:08.950 --> 00:05:11.780 default. Well I'm pretty comfortable with 00:05:11.780 --> 00:05:17.190 the setup of my workbook so now that I know where everything is, I think I'll 00:05:17.190 --> 00:05:17.750 get started!