From the course: Excel 2016 Essential Training
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Understanding workbooks and worksheets
From the course: Excel 2016 Essential Training
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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
What is Excel used for?2m 14s
-
(Locked)
Using the menu system5m 50s
-
(Locked)
Using the Quick Access Toolbar6m 49s
-
(Locked)
Understanding workbooks and worksheets4m 45s
-
(Locked)
Using the Formula bar1m 37s
-
(Locked)
Using the Status bar5m 20s
-
(Locked)
Using navigation tools3m 24s
-
(Locked)
Using shortcut menus and the Mini toolbar4m 25s
-
(Locked)
Creating new workbooks2m 37s
-
(Locked)
Using Excel Help5m 28s
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-