All language subtitles for 1. Workbooks and Worksheets

In this video you will learn how to look at what books and worksheets in an Excel log book you create

Excel worksheets with specific purpose like tracking sales information tracking orders calculating cost

executor you should spend some time to think about the data you are going to store in the worksheets

so you can create a structure best suited to your needs.

Let me first explain you the difference between workbooks and worksheets of all she is a single Excel

spreadsheet just like this.

Each worksheet is defined by a tab in the worksheet tab but down at the bottom here you can switch back

and forth between tabs to go from one worksheet to another all these worksheets are contained within

a Vogue book.

Think of a paper book you read.

Each page of the book is a sheet of paper and all the sheets of paper are combined to create one book.

Similarly in Excel all the worksheets are combined into a single workbook when you click on one of these

steps.

They are called will cheat and when you look at the file name it is the book like monthly sales data

in our case details about each workbook that describes or identify it are called document properties

and are also known as metadata.

To view or edit your document properties click the file that on the input tab.

You can view the log book properties to add or change properties over your pointer over the property

you want to update and put the information if you include the document properties for your files.

You can easily organize and identify them later.

You can add a title adding that that helps in searching the document later.

Let us add taxes Click on Show all properties link Excel displays more properties you can add a subject

that identifies the documents topic or contents act the company name so that later if you distribute

the log book it displays the company name.

You can add an author to see fewer properties click show fewer properties.

Any changes you made are saved automatically.