Recover MS Word and MS Excel password Easily
If you have lost your password for any MS Word or Excel document and are unable to recover it, try using this Free Word / Excel Password Recovery application. It’s a freeware product and all you need to do is install it, open the file that you need to recover. Choose the character set “a to z” and the expected lenght of your password and click GO. It will than try every possible combination that matches your password. It might take a bit time depending on the characters and length of your password, the larger the character set, the longer the search time.
But in the end, it does work great and recovers your ms word / ms excel password.
About MoiN
Random Group Generator (Tool Thursday)
One requirement that you will see as part of a classroom environment is the necessicity to create groups.
One option is to perform this process manually. This is ok if you have ten people. When you have fifty or hundred, then you’re going to spend a long long time creating random groups!
Dave Foord has created a very simple excel file that helps you do just this. All you need to do is enter the names of students in the sheet and specify how many you want in a group and the file will give you the lists and the groups.
The best part is that the file only utilizes formulas and absolutely no macros, so you don’t have to worry about your security settings in Excel.
Download Random Group Generator (from author)
Download Random Group Generator (from Techtites)
About Ajay
A die-hard blogger, web developer, biker, singer, geek, non-stop talker, foodie, movie freak are just some of the words that begin to describe me.
Excel Password Remover 2008 (Tool Thursday)
If you’ve forgotten the password to edit the Excel file Excel Password Remover 2008 can come to your rescue.
Excel Password Remover is a FREE Excel add-in that removes/cracks sheet and workbook password protection in Excel®.
This program will remove passwords of any length, also passwords containing special characters.
However, it can’t remove file protection. Which means that you should be able to open up the Excel file whose password you need to remove.
Download password.xla
zipped: password.zip
About Ajay
A die-hard blogger, web developer, biker, singer, geek, non-stop talker, foodie, movie freak are just some of the words that begin to describe me.
Two Variable Data Tables in Microsoft Excel (Tutorial Thursday)
Three weeks back I covered creating Single Variable Data Tables in Excel. As promised, in this tutorial I will cover creating a two variable data table. This tutorial assumes that you have read the earlier one and are comfortable with creating a single variable data table.
Create a new excel file as shown in the screenshot above. In cell A5, enter the formula =B1 * (1 + B2) ^ B3.
As you can see, the $5000 invested at 7.5% for 5 years will give $7,178.15.
A two variable data table gives you results by varying two different variables in the equation. In our case, the equation is that of compound interest i.e.
Formula for calculating compound interest:
A = P * (1 + r/n) ^ nt
Where:
- P = principal amount (initial investment)
- r = annual interest rate (as a decimal)
- n = number of times the interest is compounded per year
- t = number of years
- A = amount after time t
We will be varying the annual interest rate and the number of years to find the varying results.
After you have created the file according to the screenshot above, select the data range A5:F10.
In Excel 2007, goto Data > What-If Analysis > Data Table. In Excel 2003, the menu path is Data > Table or you can use the shortcut key Alt + D + T in this order.
This will popup a window where you will be asked to enter Row Input Cell and the Column Input Cell. Select the Column Input Cell as $B$2 and the Row Input Cell as $B$3 and hit OK.
The cells will be populated as shown in the screenshot below. As usual, you can choose to format the same currency.
How it works?
Cells B6:F10 hold the formula {=TABLE(B3,B2)}.
Here, the values B4 to F4 are substituted for B3 in the formula in cell A5 and values A6 to A10 are substituted for B2 in the formula in cell A5 and the results are then populated accordingly.
Hence, for 1 year at 8%, the amount is $5,400, for 3 years at 10%, the amount is $6,655.00 and so on.
You can download the sample XLS file for your reference.
Excel File with the example of Two Variable Data Table
About Ajay
A die-hard blogger, web developer, biker, singer, geek, non-stop talker, foodie, movie freak are just some of the words that begin to describe me.
Data Tables in Excel (Tutorial Thursday)
In my last Excel Tutorial, I covered using SUMIFS and SUMPRODUCT.
Data Tables is also an advanced topic in Microsoft Excel that falls under the category of What-If Analysis. What-If or Sensitivity Analysis is carried out to study the variation of the output to changes in the input variable.
Consider a case of compound interest, where you invest a certain amount of money in a bank deposit and the amount is compounded every year.
Formula for calculating compound interest:
A = P * (1 + r/n) ^ nt
Where:
- P = principal amount (initial investment)
- r = annual interest rate (as a decimal)
- n = number of times the interest is compounded per year
- t = number of years
- A = amount after time t
Now, if suppose we want to see what the final amount will be at different interests rates, we can quickly use a data table for the same.
About Ajay
A die-hard blogger, web developer, biker, singer, geek, non-stop talker, foodie, movie freak are just some of the words that begin to describe me.
(4.93 out of 5)
(3.69 out of 5)