Login
Copyright

What is a Workbook in Excel? - Characteristics and Options

An error occurred trying to load this video.

Try refreshing the page, or contact customer support.

Coming up next: How to Modify the Worksheet Tab in Excel

You're on a roll. Keep up the good work!

Take Quiz Watch Next Lesson
 Replay
Your next lesson will play in 10 seconds
  • 0:23 Microsoft Excel
  • 0:50 Workbooks vs. Worksheets
  • 2:03 Multiple Workbooks
  • 3:25 Lesson Summary
Add to Add to Add to

Want to watch this again later?

Log in or sign up to add this lesson to a Custom Course.

Login or Sign up

Timeline
Autoplay
Autoplay
Create an account to start this course today
Try it free for 5 days!
Create An Account
Lesson Transcript
Instructor: Natalie Boyd

Natalie is a teacher and holds an MA in English Education and is in progress on her PhD in psychology.

Excel allows users to organize data, but to organize your information most effectively, you should understand the difference in workbooks and worksheets, and how to use workbooks. Watch this lesson to find out how.

Microsoft Excel

Harry is working on a report about test scores at different middle schools. He's trying to put together some data for one of his classes, and his friend suggested that he use Microsoft Excel software. Harry has heard of Excel, but he doesn't know exactly what it is or what to expect. How can it help Harry with his data?

Excel is a spreadsheet software. It allows users to create spreadsheets of data, which in turn lets them organize information. For example, Harry has a lot of data. He has the test scores of every student in the 8th grade for five different schools. That's a ton of information! By putting those test scores into an Excel workbook, Harry can use the data more easily.

To help Harry out, let's look closer at Excel, including the difference between workbooks and worksheets, and how to create and work with multiple workbooks at once.

Workbooks vs. Worksheets

Harry has a lot of information, and from what he's heard, Excel is a good place to organize that information. But he's also heard that there are workbooks and worksheets in Excel. He doesn't know the difference between the two, or which he should be using.

In Excel, a worksheet is a single spreadsheet of data. On the other hand, a workbook is an Excel file with one or more worksheets.

Think about it kind of like a 3-ring binder. A workbook would be the entire binder, with everything in it. In contrast, a worksheet would be like one section in that binder.

So, how should Harry organize his information using workbooks and worksheets? Remember that he has the test scores for every 8th grade student in five different schools. That's a lot of information!

One way that Harry might want to organize his information is to create one workbook for all the data. Within that workbook, he could have a different worksheet for each different school. That way, he can see how all the different students did based on their schools.

Multiple Workbooks

That all sounds pretty good, but Harry isn't sure. He thinks it might be better to create an entirely new workbook, or Excel file, for each school.

It isn't as easy to work with multiple workbooks as it is to work with multiple worksheets. However, it is possible to create and work with multiple workbooks at once.

To switch between different workbooks, Harry can use the ribbon, or series of menus at the top of the software. If he clicks on the ribbon menu titled 'View,' he can choose 'Switch windows' to go back and forth between different Excel workbooks.

To unlock this lesson you must be a Study.com Member.
Create your account

Register for a free trial

Are you a student or a teacher?
I am a teacher

Unlock Your Education

See for yourself why 30 million people use Study.com

Become a Study.com member and start learning now.
Become a Member  Back

Earning College Credit

Did you know… We have over 95 college courses that prepare you to earn credit by exam that is accepted by over 2,000 colleges and universities. You can test out of the first two years of college and save thousands off your degree. Anyone can earn credit-by-exam regardless of age or education level.

To learn more, visit our Earning Credit Page

Transferring credit to the school of your choice

Not sure what college you want to attend yet? Study.com has thousands of articles about every imaginable degree, area of study and career path that can help you find the school that's right for you.

Create an account to start this course today
Try it free for 5 days!
Create An Account
Support