WEBVTT Kind: captions Language: en 00:00:08.720 --> 00:00:14.840 Excel is a spreadsheet program that allows you to store, organize, and analyze information. 00:00:14.840 --> 00:00:22.260 You can use it to create contact lists… budgets… invoices… and just about anything 00:00:22.260 --> 00:00:24.700 else you can imagine. 00:00:24.700 --> 00:00:29.090 When you open Excel, there's a good chance you'll be taken to the start screen first. 00:00:29.090 --> 00:00:33.680 From here you can access recent workbooks, or create something new—either from scratch, 00:00:33.680 --> 00:00:35.180 or from a template. 00:00:35.180 --> 00:00:40.350 In this example, we'll click Blank Workbook. 00:00:40.350 --> 00:00:43.730 Next you might want to take a minute to explore the interface, and make sure you know your 00:00:43.730 --> 00:00:44.730 way around. 00:00:44.730 --> 00:00:48.430 Let’s begin with the ribbon - which is the collection of tools and features at the top 00:00:48.430 --> 00:00:50.370 of the screen. 00:00:50.370 --> 00:00:53.680 The ribbon is divided into tabs like Page Layout… 00:00:53.680 --> 00:00:58.510 Insert… and Home, so you can easily find what you're looking for. 00:00:58.510 --> 00:01:02.300 There are also commands on each tab that have been organized into groups. 00:01:02.300 --> 00:01:06.310 For example, if you look closely at the Font group, you'll find it has everything you need 00:01:06.310 --> 00:01:12.330 to work with text, including options like bold, italics, font color, and size. 00:01:12.330 --> 00:01:16.110 Some groups even have an arrow in the bottom right corner that you can click to view even 00:01:16.110 --> 00:01:19.900 more commands. 00:01:19.900 --> 00:01:23.760 If you ever feel like the ribbon is taking up too much space, you can always hide or 00:01:23.760 --> 00:01:25.110 minimize it. 00:01:25.110 --> 00:01:29.400 All you have to do is click the arrow in the upper right corner… then choose the option 00:01:29.400 --> 00:01:31.880 you want. 00:01:31.880 --> 00:01:35.479 Also in the upper right corner is a place where you can access your Microsoft account. 00:01:35.479 --> 00:01:39.670 Here you can update your photo, manage your account settings, or switch to a different 00:01:39.670 --> 00:01:42.810 account all together. 00:01:42.810 --> 00:01:47.030 You can even customize your copy of Excel to make certain commands more convenient. 00:01:47.030 --> 00:01:50.050 Take the quick access toolbar in the upper left corner. 00:01:50.050 --> 00:01:54.729 This area gives you access to frequently used commands like Save and Undo, no matter where 00:01:54.729 --> 00:01:56.390 you are on the ribbon. 00:01:56.390 --> 00:02:00.530 To add more commands, just click the tiny arrow next to the toolbar… then choose the 00:02:00.530 --> 00:02:01.810 ones you want. 00:02:01.810 --> 00:02:06.670 I'm going to add New and also Quick Print because I use both of these commands pretty 00:02:06.670 --> 00:02:07.670 frequently. 00:02:07.670 --> 00:02:12.810 In Excel 2016, you’ll also find a new feature called Tell Me. 00:02:12.810 --> 00:02:17.620 It works like a search bar to help you quickly find tools or commands you want to use. 00:02:17.620 --> 00:02:20.560 Just type in what you want to do, in your own words. 00:02:20.560 --> 00:02:24.280 The results will give you a few options, and then guide you through the process, as well 00:02:24.280 --> 00:02:27.280 as offering additional resources. 00:02:27.280 --> 00:02:31.350 Now let's take a look at the workbook itself (which is also sometimes referred to as a 00:02:31.350 --> 00:02:33.300 worksheet, or a spreadsheet). 00:02:33.300 --> 00:02:37.050 In this example, I've opened an order list that I'm working on. 00:02:37.050 --> 00:02:42.560 Every worksheet contains cells, columns, and rows for entering data, plus the formula bar 00:02:42.560 --> 00:02:44.849 for working with your data. 00:02:44.849 --> 00:02:48.950 If you need to scroll up or down, or even side to side, you can use the scroll bars 00:02:48.950 --> 00:02:52.709 here… and here. 00:02:52.709 --> 00:02:56.520 In the bottom right corner, you'll find several tools that let you change the way your worksheet 00:02:56.520 --> 00:02:58.150 is displayed. 00:02:58.150 --> 00:03:01.690 To zoom in or out, click and drag the zoom control. 00:03:01.690 --> 00:03:05.960 The number next to the slider will tell you what the zoom percentage is. 00:03:05.960 --> 00:03:10.170 You can also switch between different worksheet views using the three commands here. 00:03:10.170 --> 00:03:12.280 Normal is selected by default. 00:03:12.280 --> 00:03:16.590 This mode is great for everyday tasks like entering and editing data. 00:03:16.590 --> 00:03:20.190 Page Layout shows you what the worksheet will look like on the printed page. 00:03:20.190 --> 00:03:23.250 You can also add headers and footers here. 00:03:23.250 --> 00:03:27.760 Page Break Preview makes it easy to change the location of page breaks in your workbook. 00:03:27.760 --> 00:03:31.700 This can be especially useful if you're printing lots of data. 00:03:31.700 --> 00:03:35.430 Last but not least, let’s take a quick tour of the backstage view. 00:03:35.430 --> 00:03:40.320 You can get there by clicking the File tab—just look for it on the far left of the ribbon. 00:03:40.320 --> 00:03:46.180 Here you can access all kinds of information related to your current workbook, and more. 00:03:46.180 --> 00:03:48.230 This includes commands like New… 00:03:48.230 --> 00:03:49.230 Open… 00:03:49.230 --> 00:03:51.590 Save… and Print. 00:03:51.590 --> 00:03:56.160 All you have to do is click an item… and it'll open in the right pane. 00:03:56.160 --> 00:04:00.290 This makes it easy to find what you're looking for—and review your options—all in one 00:04:00.290 --> 00:04:02.209 place. 00:04:02.209 --> 00:04:05.069 That covers the basics of Excel 2016! 00:04:05.069 --> 00:04:10.520 Now that you're comfortable with the interface—including the backstage view, the ribbon, and the work 00:04:10.520 --> 00:04:12.519 area—you're ready to start your first worksheet.