WEBVTT 00:00.000 --> 00:19.720 The best way to learn about Excel 2013 is to start using it. 00:19.720 --> 00:23.040 This is what you see when you start Excel for the first time. 00:23.040 --> 00:27.160 You can open an existing workbook over here or start with a template. 00:27.160 --> 00:31.720 Once this is our first time, let's keep it simple and select blank workbook. 00:31.720 --> 00:35.880 The area down here is where you create your worksheet, and you'll find all the tools 00:35.880 --> 00:37.400 you need to work on it. 00:37.400 --> 00:40.400 Up here, in this area, called the ribbon. 00:40.400 --> 00:44.320 In this area, you'll find the name, box, and formula bar. 00:44.320 --> 00:47.040 You'll see what those do as we go along. 00:47.040 --> 00:49.280 Now click somewhere in the work area. 00:49.280 --> 00:54.560 These little rectangles, called cells, each hold one piece of information, some text, 00:54.560 --> 00:56.760 a number, or a formula. 00:56.760 --> 01:01.520 Let's say we want to create a worksheet to track expenses on an expansion project. 01:01.520 --> 01:04.360 Type the first budget item and press enter. 01:04.360 --> 01:08.840 There are literally millions of cells in a worksheet, but each one can be identified using 01:08.840 --> 01:11.240 this grid system of rows and columns. 01:11.240 --> 01:17.200 For example, the address of this cell is D7, column D, row 7. 01:17.200 --> 01:20.040 The name box shows which cell is selected. 01:20.040 --> 01:22.640 You'll see why addresses are important later. 01:22.640 --> 01:25.200 Next, type the other budget items. 01:25.200 --> 01:28.960 This is a breakdown of the work required for the expansion project. 01:28.960 --> 01:32.840 If the text doesn't fit in the cells, come up here and hold the mouse over the column 01:32.840 --> 01:35.720 border until you see a double-headed arrow. 01:35.720 --> 01:39.080 Then click and drag the border to widen the column. 01:39.080 --> 01:43.440 Now to make our worksheet more interesting, let's add rough estimates for each work item 01:43.440 --> 01:46.960 in the next column. 01:46.960 --> 01:51.120 To make the numbers look like dollars amounts, we'll add some formatting. 01:51.240 --> 01:56.240 First, select the numbers by clicking the first number and dragging the mouse down the list. 01:56.240 --> 01:59.800 The gray highlighting and green border mean the cells are selected. 01:59.800 --> 02:04.200 Right-click the selection, and the right-click menu opens along with this box up here called 02:04.200 --> 02:05.720 the mini toolbar. 02:05.720 --> 02:09.000 The mini toolbar changes depending on what you select. 02:09.000 --> 02:12.720 In this case, it contains commands for formatting the cells. 02:12.720 --> 02:15.960 Click the low sign to format the numbers as two amounts. 02:15.960 --> 02:18.840 Now it is beginning to look more like a worksheet. 02:18.840 --> 02:23.360 To make it official, let's add a header row up here so that anyone who looks at the 02:23.360 --> 02:26.800 worksheet will know what the data means in each column. 02:26.800 --> 02:31.640 Next, let's do something to the data to make it easier to work with. 02:31.640 --> 02:33.560 Select the header and data. 02:33.560 --> 02:37.440 Click the top left corner and drag the mouse to the bottom right. 02:37.440 --> 02:42.400 This time, instead of right-clicking, just hold the mouse over the selection and a button 02:42.400 --> 02:43.720 appears. 02:43.720 --> 02:46.560 Click it and the quick analysis lens opens. 02:46.560 --> 02:50.400 This contains a set of tools for helping you analyze your data. 02:50.400 --> 02:52.880 Click tables and then click table. 02:52.880 --> 02:55.160 The data is converted to a table. 02:55.160 --> 03:00.040 You don't have to do this, but working with data as a table has certain advantages. 03:00.040 --> 03:04.480 For example, you can click these arrows to quickly sort or filter the data. 03:04.480 --> 03:09.400 You also have a lot of commands and options to choose from, up here on the ribbon. 03:09.400 --> 03:14.480 For example, we can add a total row to the table or remove the banded rows. 03:14.480 --> 03:17.800 While we're up here, let's take a closer look at the ribbon. 03:17.800 --> 03:21.960 The commands and options you can work with are organized into these tabs. 03:21.960 --> 03:24.560 Most of the commands you'll need are on the home tab. 03:24.560 --> 03:29.840 For example, you can come here to format text and numbers or change a cell style. 03:29.840 --> 03:34.720 The insert tab has commands for inserting things, like pictures and charts. 03:34.720 --> 03:38.680 We'll look at some of the other tabs later in the course. 03:38.680 --> 03:41.680 The table tools. 03:41.680 --> 03:45.800 The second tab is called a contextual tab, because it appears only when you are working 03:45.800 --> 03:47.280 on the table. 03:47.280 --> 03:51.240 When you select a cell outside the table, the tab goes away. 03:51.240 --> 03:55.640 You'll also see contextual tabs when you are working with other insertable objects, 03:55.640 --> 03:58.240 like spark lines and pivot charts. 03:58.240 --> 04:02.800 Our worksheet is pretty small now, but there's plenty of room to grow and excel as your project 04:02.800 --> 04:03.800 expands. 04:03.800 --> 04:07.280 However, before we do any more work, let's save the workbook.