An Excel workbook—also called a file—contains one or more worksheets. You can add, delete, move, and copy sheets. Worksheets contain over 16,000 columns and over a million rows.
- [Instructor] In Excel, there's some terms that we must use consistently. And one of them is workbook. When you open Excel, you will see an empty workbook at the top of the screen, typically it will say book one. A workbook and a file are two terms we us interchangeably. A file is a workbook, a workbook is a file. Every workbook initially has one worksheet in it. Typically sheet one. We see this on the bottom of the screen. We can add sheets. This current workbook, 01 Examples, has other sheets in it. We can add sheets, we can delete them, we can move them from left to right.
The more you work with Excel, the more likely you are to see files that have more than one worksheet. Every worksheet has the same number of columns, those are vertical and identified by letters, and the same number of rows, those are horizontal, identified by numbers. If I use the right arrow key on my keyboard here, I can quickly come down to column Z, just to point out that the lettering scheme starts all over again, AA, AB, etc. If I want to go to the very last column on the right, I'll hold down the control key and press the right arrow. There is the last column, it's over 16,000.
That's how many columns we have Excel. How do we get back to that upper left corner? Hold down control, press the home key, here. As I start to press the down arrow here, it will take me a really, really long time to get to the bottom, because there are over a million rows in Excel. I'm gonna hold down the control key, and with it held down press the down arrow. There it is. And how do I get back up top again? Control home. As we work with Excel, and we put data in this location, that location, each one of these cells here has a name, a location.
I'm using the arrow keys right now, I'm about to put in some data here. That's in column B, row 3, therefore it's cell B3. And at any given time we see that same address as it's called, in what we call the name box. Just to the left above the worksheet area. Right here, that's the name box, cell B3. And that becomes important as you work with formulas in Excel. Cell addresses are vital. And so once again, the terms we've been using. An Excel workbook is an Excel file. Every workbook has at least one worksheet in it.
Every worksheet has columns and rows identified by letters and numbers.
- Navigating Excel tabs and menus
- Entering data
- Creating formulas and functions
- Formatting rows, columns, cells, and data
- Working with alignment and text wrap
- Adjusting rows and columns
- Finding and replacing data
- Printing and sharing worksheets
- Creating charts and PivotTables
- Inserting and deleting sheets
- Using power functions such as IF and VLOOKUP
- Password-protecting worksheets and workbooks
- Sorting data
- Analyzing data with Goal Seek and Solver
- Creating and running macros