The Excel Hub seeks to enhance your Excel and VBA knowledge by providing value-adding tutorials, techniques and examples in order to help you take your spreadsheet and data analysis skills to the next level.
Subscribe for new videos every month!
For any enquiries, please contact: theexcelhub@outlook.com
Hi @The Excel Club, A help, some how the scatter plot dots are not aligning with the Y Axis. If you have few mins, can you please help docs.google.com/document/d/12pgby_9IUJ7tCo9naeOxBDN3PgQ-GGsfs5TO9M5HxYI/edit?usp=sharing
This is very helpful. Thank you. The one thing that is missing (for me) is a way of inputting into a cell a number so that the password then generated will have that number of characters. To ensure that it has upper or lower case letters, numbers or special characters, there would, ideally, be options to have at least one of each. I've found plenty of guidance online on using Excel to generate passwords, but nothing that explains how to add these options.
I was just wondering how to change it to cover the Scottish Tax Rates. I'm thinking I just need to enlarge the array used by VLOOKUP to include the extra rows...
THIS IS NOT ACCURATE! The error is marginal, but with the biggest numbers the error can increase to millions. You cannot divide the interest directly by months. The interest must be calculated with a higher root =(1 + r) ^ (1/12) -1 (1+1.5%)^(1/12)-1 NOT 1.5%/12
Very nicely explained...unfortunately, the formula doesn't give me the correct rate. I got an answer of over 10% for one bond and I know that that's way overstated. I will keep researching this as it's good to know. Coupon rate really isn't telling us how much return we're getting.