WEBVTT Kind: captions Language: en 00:00:11.460 --> 00:00:17.910 Excel 2013 is a spreadsheet program that allows you to store, organize, and analyze information. 00:00:17.910 --> 00:00:25.970 You can use it to create contact lists… budgets… invoices… and just about anything 00:00:25.970 --> 00:00:29.460 else you can imagine. 00:00:29.460 --> 00:00:34.270 When you open Excel, there's a good chance you'll be taken to the start screen first. 00:00:34.270 --> 00:00:38.710 From here you can access recent workbooks, or create something new—either from scratch, 00:00:38.710 --> 00:00:40.210 or from a template. 00:00:40.210 --> 00:00:44.380 In this example, we'll click Blank Workbook. 00:00:44.380 --> 00:00:47.620 Next you might want to take a minute to explore the interface, and make sure you know your 00:00:47.620 --> 00:00:48.660 way around. 00:00:48.660 --> 00:00:51.940 Why don't we begin with the ribbon (which is the collection of tools and features at 00:00:51.940 --> 00:00:54.219 the top of the screen)? 00:00:54.219 --> 00:00:57.329 The ribbon is divided into tabs like Page Layout… 00:00:57.329 --> 00:01:02.120 Insert… and Home, so you can easily find what you're looking for. 00:01:02.120 --> 00:01:05.449 There are also commands on each tab that have been organized into groups. 00:01:05.449 --> 00:01:09.970 For example, if you look closely at the Font group, you'll find it has everything you need 00:01:09.970 --> 00:01:15.390 to work with text, including options like bold, italics, font color, and size. 00:01:15.390 --> 00:01:18.909 Some groups even have an arrow in the bottom right corner that you can click to view even 00:01:18.909 --> 00:01:24.290 more commands. 00:01:24.290 --> 00:01:27.790 If you ever feel like the ribbon is taking up too much space, you can always hide or 00:01:27.790 --> 00:01:28.899 minimize it. 00:01:28.899 --> 00:01:33.600 All you have to do is click the arrow in the upper right corner… then choose the option 00:01:33.600 --> 00:01:36.360 you want. 00:01:36.360 --> 00:01:40.930 Also in the upper right corner is a place where you can access your Microsoft account. 00:01:40.930 --> 00:01:44.619 Here you can update your photo, manage your account settings, or switch to a different 00:01:44.619 --> 00:01:47.159 account all together. 00:01:47.159 --> 00:01:51.469 You can even customize your copy of Excel to make certain commands more convenient. 00:01:51.469 --> 00:01:54.920 Take the quick access toolbar in the upper left corner. 00:01:54.920 --> 00:01:59.170 This area gives you access to frequently used commands like Save and Undo, no matter where 00:01:59.170 --> 00:02:00.810 you are on the ribbon. 00:02:00.810 --> 00:02:05.250 To add more commands, just click the tiny arrow next to the toolbar… then choose the 00:02:05.250 --> 00:02:06.830 ones you want. 00:02:06.830 --> 00:02:11.290 I'm going to add New and also Quick Print because I use both of these commands pretty 00:02:11.290 --> 00:02:14.480 frequently. 00:02:14.480 --> 00:02:18.790 Now let's take a look at the workbook itself (sometimes referred to as a worksheet, or 00:02:18.790 --> 00:02:19.790 a spreadsheet). 00:02:19.790 --> 00:02:24.490 In this example, I've opened an order list that I'm working on. 00:02:24.490 --> 00:02:29.370 Every worksheet contains cells, columns, and rows for entering data, plus the formula bar 00:02:29.370 --> 00:02:31.890 for working with your data. 00:02:31.890 --> 00:02:36.080 If you need to scroll up or down (or even side to side), you can use the scroll bars 00:02:36.080 --> 00:02:41.230 here and here. 00:02:41.230 --> 00:02:45.190 In the bottom right corner, you'll find several tools that let you change the way your worksheet 00:02:45.190 --> 00:02:46.590 is displayed. 00:02:46.590 --> 00:02:50.190 Here's what they look like up close. 00:02:50.190 --> 00:02:56.170 To zoom in or out, click and drag the zoom control. 00:02:56.170 --> 00:03:00.980 The number next to the slider will tell you what the zoom percentage is. 00:03:00.980 --> 00:03:06.140 You can also switch between different worksheet views using the three commands here. 00:03:06.140 --> 00:03:08.510 Normal is selected by default. 00:03:08.510 --> 00:03:13.230 This mode is great for everyday tasks like entering and editing data. 00:03:13.230 --> 00:03:16.930 Page Layout shows you what the worksheet will look like on the printed page. 00:03:16.930 --> 00:03:20.250 You can also add headers and footers here. 00:03:20.250 --> 00:03:24.950 Page Break Preview makes it easy to change the location of page breaks in your workbook. 00:03:24.950 --> 00:03:29.510 This can be especially useful if you're printing lots of data. 00:03:29.510 --> 00:03:33.570 Last but not least, I'd like to give you a quick tour of the backstage view. 00:03:33.570 --> 00:03:39.480 You can get there by clicking the File tab—just look for it on the far left of the ribbon. 00:03:39.480 --> 00:03:44.090 Here you can access all kinds of information related to your current workbook (and more). 00:03:44.090 --> 00:03:46.010 This includes commands like New… 00:03:46.010 --> 00:03:47.010 Open… 00:03:47.010 --> 00:03:49.450 Save… and Print. 00:03:49.450 --> 00:03:53.790 All you have to do is click an item… and it'll open in the right pane. 00:03:53.790 --> 00:03:57.680 This makes it easy to find what you're looking for—and review your options—all in one 00:03:57.680 --> 00:03:59.540 place. 00:03:59.540 --> 00:04:02.890 That covers the basics of Excel 2013! 00:04:02.890 --> 00:04:07.890 Now that you're comfortable with the interface—including the backstage view, the ribbon, and the work 00:04:07.890 --> 00:04:09.790 area—you're ready to start your first worksheet.