From the course: Excel 2016 Essential Training

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Understanding workbooks and worksheets

Understanding workbooks and worksheets

From the course: Excel 2016 Essential Training

Start my 1-month free trial

Understanding workbooks and worksheets

- There are certain Excel terms that we should use consistently. In Excel, a file is a workbook. A workbook is a file. And, nearly always, we can use those two terms interchangeably. The current workbook is called 01 - Getting Started. You see the name at the top of the screen. If you've just opened Excel, you're probably seeing a file with a temporary name, Book1, possibly Book2, something like that. Every workbook is comprised of at least one worksheet. Although the term spreadsheet is widely used by people who use Excel, officially and formally in Excel, every workbook has at least one worksheet in it. If you start a new workbook, it will have three empty worksheets in it. At the bottom of the screen, we see worksheet tabs. This particular workbook, we've got a tab called Revenue chart by department. To the left of that, 2015 HOME products revenue. Far off to the right, a Profits sheet. These are worksheets, often abbreviated, we simply call them sheets. We can add sheets. We can…

Contents