Workbooks Fundamentals

Education is not limited to just classrooms. It can be gained anytime, anywhere... - Ravi Ranjan (M.Tech-NIT)

Workbooks Fundamentals

Introduction

We have seen that a document in Microsoft Excel is made of one or more worksheets. In reality, a document in Microsoft Excel is called a workbook. In other words, a workbook is the group of worksheets that belong to the same document. This also means that when you start a document in Microsoft Excel, you actually start a workbook. When you save the document, you are said to save a workgroup. When you open a document, you are said to open a workbook. Based on this, for the rest of our lesson, we will use the word "workbook" to refer to any document in Microsoft Excel.

Practical LearningPractical Learning: Introducing Workbooks

  1. Start Microsoft Excel
  2. To close the current document, click the system close below the first one
     

Creating a Workbook

When you start Microsoft Excel, it directly creates a workbook for you. You can use that workbook as you see fit. At any time, you can create a new workbook. To support the ability to create workbooks, Microsoft Excel provides many templates. The default workbook with blank cells is just one of the templates. Instead of using the default workbook, Microsoft Excel provides many designed and ready-to-use workbooks with complete functionality.

To create a workbook based on the samples provided by Microsoft Excel, click the Office Button and click New. This would display the New Workbook dialog box. In the left frame, under Templates, you can click a category. In the middle frame, click one of the button to see a preview in the right frame:

New Workbook

If you see a template you like, click it and click Create. If none of the templates suits you and if you are connected to the Internet, in the left frame, under Microsoft Office Online, click a category and select a template in the middle frame. Then click Download. You can also check for new files on the Microsoft Office web site.

Practical LearningPractical Learning: Creating Workbooks

  1. To create a workbook based on a template, click the Office Button
  2. In the left frame of the New Workbook dialog box, click Installed Templates
  3. In the middle frame, click Blood Pressure Tracker
  4. Click Create
  5. To add another workbook based on a template, click the Office Button
  6. In the left frame of the New Workbook dialog box, click Installed Templates
  7. In the middle frame, click Time Card and click Create
  8. To add one more workbook from on a template, click the Office Button
  9. In the left frame of the New Workbook dialog box, click Installed Templates
  10. In the middle frame, click Expense Report and click Create