Join Dennis Taylor for an in-depth discussion in this video Understanding workbooks and worksheets, part of Excel Essential Training (Office 365).
- [Instructor] The exercise file that we're using for this movie is at the top of the screen, 01 Examples. In Excel, there's certain terms that we must use consistently. This workbook is called 01 Examples. A workbook is a file, a file is a workbook, and nearly always in Excel we can use those two terms interchangeably. Every workbook has at least one worksheet, and if we were to create a new workbook, we'd see one sheet in it. We can add sheets, we can take them out. At the bottom of the screen here, we can see in this workbook, there is a Sheet 1 tab, but also a tab for Profits, and you can see the other names, 2019 Budget, Customers, and so on.
We can add many, many sheets. As you can see, we can have color as well, too. We never want to make those terms be used interchangeably. Every worksheet has exactly the same number of columns, the same number of rows. On my keyboard, I'm pressing the right arrow here. As we see this cell moving across the screen, we see the column letters, these are columns. Columns are vertical, and they're identified by letters. After we come to the letter Z, you see how the lettering scheme starts all over again with AA, AB, and so on.
To get to the far right, normally, we won't need to do this, I'll hold down the Control key and then press right arrow. Takes us all the way to the end. That's the last column. If you were to figure that out, it's well over 16,000. How do we get back to the upper left corner? We hold down Control and press the Home key. Moving down on the left hand side, it'll take us a very long time to get to the bottom, because the rows, which are always horizontal and numbered, here, I will hold down Control down like I did before, but this time, down arrow. How many rows are here? Well over a million.
Now, you don't have to use them all, in fact, most people don't even come close and why would you. But it's there anyway and all worksheets have that attribute. How do we get back home? Upper left corner, Control + Home. That location, by the way, has a name, and every one of these cells, whether you use the arrow keys to get to this cell, that cell, or you slide the mouse around and click with the left mouse button, that's a different cell. Every cell has a column and row location. This cell is in column C, row 4, therefore, we call it cell C4.
If there's any doubt, look right above the main body of the worksheet here. This is called the Name Box, that's cell C4. This is D2, this is F2. These addresses become very important, particularly as you start to work with formulas. All these worksheets are the same initially, and as I just click on a different sheet at the bottom, you can see how the column widths have been varied on some of these. I didn't change the row height on any of these, but that can be done, too. You can see certain different column differences here.
Every Excel workbook is a file, a file is a workbook, and a workbook has multiple sheets. They all have, at least initially, the same layout. Those are features we keep in mind as we work with Excel.
- Working with the Excel interface
- Entering data
- Creating formulas and functions
- Formatting your data
- Adjusting rows and columns
- Finding and replacing data
- Inserting and deleting sheets
- Sorting and filtering data
- Creating charts and PivotTables
- Printing and sharing worksheets
- Protecting worksheets and workbooks
Skill Level Beginner
Q: This course was updated on 1/7/2019. What changed?
A: A new video was added that covers working with Excel Ideas.