WEBVTT Kind: captions Language: en 00:00:12.090 --> 00:00:17.830 What's a row? Where's the Formula Bar? How do you zoom in on a worksheet? If you're new 00:00:17.830 --> 00:00:22.270 to Excel, or just need a refresher, reviewing how to navigate the environment and access 00:00:22.270 --> 00:00:24.990 basic tools can be very helpful. 00:00:24.990 --> 00:00:28.619 Let's start with the Ribbon, which is the collection of tools and features at the top 00:00:28.619 --> 00:00:34.640 of the screen. The Ribbon is divided into tabs - like Page Layout, Insert, and Home 00:00:34.640 --> 00:00:39.600 - to help you find what you're looking for quickly and easily. Also making things easier 00:00:39.600 --> 00:00:43.870 to find is the fact that all the commands are kept together in groups. For example, 00:00:43.870 --> 00:00:50.320 the Font group contains everything we need to work with text, including font color, size, 00:00:50.320 --> 00:00:51.960 and more. 00:00:51.960 --> 00:00:56.329 If you look closely at the upper left corner above the Ribbon, you'll find the Quick Access 00:00:56.329 --> 00:01:01.149 Toolbar. This little toolbar is designed to give you access to frequently used commands 00:01:01.149 --> 00:01:05.289 like Save and Undo no matter where you are on the Ribbon. 00:01:05.289 --> 00:01:11.149 Now let's take a look at the workbook itself. A workbook is what we call an Excel file; 00:01:11.149 --> 00:01:16.560 and each workbook contains one or more worksheets, also known as spreadsheets. Kind of like a 00:01:16.560 --> 00:01:22.179 book contains many sheets of paper. New workbooks contain three sheets by default, which you 00:01:22.179 --> 00:01:24.929 can navigate here. 00:01:24.929 --> 00:01:30.509 Every worksheet contains cells that are divided into columns and rows. Rows run from left 00:01:30.509 --> 00:01:37.099 to right and are identified by a number; for example, 1, 2, 3. Columns run from top to 00:01:37.099 --> 00:01:41.959 bottom and are identified by a letter, such as A, B, C. 00:01:41.959 --> 00:01:46.240 Just above the worksheet is a feature called the Name Box, which tells you the location 00:01:46.240 --> 00:01:51.399 (or "name") of the cell you currently have selected. Let me show you what I mean by selecting 00:01:51.399 --> 00:01:59.800 a random cell here. The one I've selected is right where column E and row 5 intersect, 00:01:59.800 --> 00:02:04.280 making the location or the name of the cell E5. 00:02:04.280 --> 00:02:08.440 To the right of the Name Box is the Formula Bar, where you can enter text, functions, 00:02:08.440 --> 00:02:13.260 or formulas for the cell you have selected. Notice how what I type here appears in both 00:02:13.260 --> 00:02:17.510 the Formula Bar and my selected cell, E5. 00:02:17.510 --> 00:02:21.420 Now I'm going to switch back to the first sheet in my workbook so we can take a look 00:02:21.420 --> 00:02:26.030 at the tools in the bottom right corner. That includes the horizontal scroll bar, which 00:02:26.030 --> 00:02:30.670 lets you scroll your worksheet from left to right so you can see more columns. And below 00:02:30.670 --> 00:02:35.749 that is the zoom control. Use the plus or minus signs - or just click and drag the slider 00:02:35.749 --> 00:02:38.299 - to zoom in and out. 00:02:38.299 --> 00:02:42.609 Finally, you have the ability to change the way you view your worksheet using the page 00:02:42.609 --> 00:02:48.200 view buttons here. Normal is selected by default. Page Layout lets you see what your spreadsheet 00:02:48.200 --> 00:02:52.810 is going to look like when you print it. And Page Break shows you an overview of what you're 00:02:52.810 --> 00:02:55.819 working on, which is helpful if you're using page breaks. 00:02:55.819 --> 00:03:01.189 All right! Now that we know where everything is, we can get into exploring the Excel environment 00:03:01.189 --> 00:03:08.189 in detail, and customizing it to fit our needs.