How To Protect Your Excel File

Encrypt an Excel file with a password so that it requires a password to open it.
1. Open a workbook.
2. On the green File tab, click Save As.

3. Click on the Tools button and click General Options.

4. In the Password to open box, enter a password and click OK.

5. Reenter the password and click OK.

Note: this feature also encrypts your Excel file. If you lose or forget the password, it cannot be recovered.
6. Enter a file name and click Save.

It requires a password to open this Excel file now. The password for the downloadable Excel file is "easy".

Template In MS. Excel

Instead of creating an Excel workbook from scratch, you can create a workbook based on a template. There are many free templates available, waiting to be used.

Existing Templates

To create a workbook based on an existing template, execute the following steps.
1. On the green File tab, click New.
2. To choose a template from one of the sample templates (these are already installed on your computer), click on Sample templates.

3. To choose a template from the Office.com Templates, click a category. For example, click Calendars.

4. To download a template, select a template and then click Download.

Excel creates a workbook (UniversalCalendar1.xlsx) based on this template. Excel also stores the template (UniversalCalendar.xltx) in the Templates folder. You can access this folder by clicking on My templates (see first picture). Read on for more information about the Templates folder.

Create a Template

If you create your own template, you can safely store it in the Templates folder. As a result, you can create new workbooks based on this template without worrying that you overwrite the original file.
To create a template, execute the following steps.
1. Create a workbook.
2. On the green File tab, click Save As.
3. Enter a file name.
4. Select Excel Template (*.xltx) from the drop-down list.

Excel automatically activates the Templates folder. Notice the location of the Templates folder on your computer. It's usually located here:
C:\Users\<username>\AppData\Roaming\Microsoft\Templates
5. Click Save.

To create a workbook based on this template, execute the following steps.
6. On the green File tab, click New.
7. Click My Templates.

8. Select WeddingBudget.
9. Click OK.

Excel creates a workbook (WeddingBudget1.xlsx) based on this template.
Note: to edit a template, on the green File tab, click Open to open the template. Edit the file and save the file to its original location.

How To Create Line Chart in MS. Excel

Line charts are used to display trends over time. Use a line chart if you have text labels, dates or a few numeric labels on the horizontal axis. Use a scatter chart (XY chart) to show scientific XY data.
To create a line chart, execute the following steps.
1. Select the range A1:D7.
2. On the Insert tab, in the Charts group, choose Line, and select Line with Markers.

Result:

Note: only if you have numeric labels, empty cell A1 before you create the line chart. By doing this, Excel does not recognize the numbers in column A as a data series and automatically places these numbers on the horizontal (category) axis. After creating the chart, you can enter the text Year into cell A1 if you like.