estafet

Read More

Excel 2007 Password Protection

---

Many of my friends were asking me, how they can password protect their excel 2007 sheets. So, this time I am going to show you, how to password protect your excel files without any software.

Scenario I : Data in Single Excel Sheet
You have important data in an excel file and you do not want others to make changes in sheet. They are allowed to make changes in your sheet only when they have password. Follow these instructions.

1.  Right click on Sheet1 tab at the bottom left corner of excel.
2.  Click on "protect sheet".
3.  Un-check all the text boxes (See Picture). If you un-check all the check boxes, then others can only view your excel sheet. But they cannot make any changes without a password. 
4.  Enter your password and click OK
5. Confirm password by typing again in pop up and then click OK.

Your worksheet is now protected. You and others can make changes in the worksheet only after typing in the password to unprotect it. To unprotect it

1. Right click on the sheet.
2. Click "Unprotect Sheet".
3. Type in your password in text box and click OK.

Scenario II : Data in Multiple Excel Sheet

If you have multiple sheets, then choose the sheet you want to password protect. Then follow the instruction given above for data in single excel sheet.

Read More

Excel 2007 Password Protection

---

Many of my friends were asking me, how they can password protect their excel 2007 sheets. So, this time I am going to show you, how to password protect your excel files without any software.

Scenario I : Data in Single Excel Sheet
You have important data in an excel file and you do not want others to make changes in sheet. They are allowed to make changes in your sheet only when they have password. Follow these instructions.

1.  Right click on Sheet1 tab at the bottom left corner of excel.
2.  Click on "protect sheet".
3.  Un-check all the text boxes (See Picture). If you un-check all the check boxes, then others can only view your excel sheet. But they cannot make any changes without a password. 
4.  Enter your password and click OK
5. Confirm password by typing again in pop up and then click OK.

Your worksheet is now protected. You and others can make changes in the worksheet only after typing in the password to unprotect it. To unprotect it

1. Right click on the sheet.
2. Click "Unprotect Sheet".
3. Type in your password in text box and click OK.

Scenario II : Data in Multiple Excel Sheet

If you have multiple sheets, then choose the sheet you want to password protect. Then follow the instruction given above for data in single excel sheet.

Read More

Excel: Combine Charts

---

What are combination charts?

Combining charts are charts made by combining two types of charts in one single chart.

What is the use of combining charts?

It makes the data more interpretable. In my previous tutorial I covered comparison chart. It compared three data in one graph, but it lacks interpretability. Combination charts are very easy to understand, especially when a comparison is made between two data.

Creating Chart

Let us make a comparison between inflation and unemployment rate in India during the period of year 2002 to 2010. These are the actual data I found at Index Mundi. Start with making a table in the picture.

Go to Insert > Charts > Line and click Stacked Line with Markers to make a graph as in the picture below. See create simple charts in excel on how to make graphs in excel.

Combining Chart

1. Right click on line representing inflation (blue line) in the graph.
2. Select "Change series chart type".
3. Click " Clustered Column " from change chart type pop-up.
4. Click OK.

Formatting Chart

1. Click "Chart Tools".
2. Select layout 3 form chart layouts.
3. Right click on chart title and select edit text.
4. Type Inflation Vs Unemployment.

The final result is:

From the above chart you can compare inflation and unemployment with ease as compared to above line chart. It can easily be interpreted that column chart is showing inflation rate and the line graph is showing unemployment rate over the years. If you like this post leave a comment and share with your friends.

Read More

Excel: Combine Charts

---

What are combination charts?

Combining charts are charts made by combining two types of charts in one single chart.

What is the use of combining charts?

It makes the data more interpretable. In my previous tutorial I covered comparison chart. It compared three data in one graph, but it lacks interpretability. Combination charts are very easy to understand, especially when a comparison is made between two data.

Creating Chart

Let us make a comparison between inflation and unemployment rate in India during the period of year 2002 to 2010. These are the actual data I found at Index Mundi. Start with making a table in the picture.

Go to Insert > Charts > Line and click Stacked Line with Markers to make a graph as in the picture below. See create simple charts in excel on how to make graphs in excel.

Combining Chart

1. Right click on line representing inflation (blue line) in the graph.
2. Select "Change series chart type".
3. Click " Clustered Column " from change chart type pop-up.
4. Click OK.

Formatting Chart

1. Click "Chart Tools".
2. Select layout 3 form chart layouts.
3. Right click on chart title and select edit text.
4. Type Inflation Vs Unemployment.

The final result is:

From the above chart you can compare inflation and unemployment with ease as compared to above line chart. It can easily be interpreted that column chart is showing inflation rate and the line graph is showing unemployment rate over the years. If you like this post leave a comment and share with your friends.

Read More

astro n dart

Read More

alice in excelland

untuk istriku yang hari ini sedang berulang tahun...
cup cup cup mmmmuach.. :)

Read More