Відео

Can this example be downloaded

00:02:02, When you don't know maths you use =PMT()... when you know maths, you know exactly what you are doing... just use: =($A$12*(1+$A$6/100/12)^($A$10*12)*$A$6/100/12/((1+$A$6/100/12)^($A$10*12)-1) Where: $A$12 = mortgage $A$6 = interest (yearly) $A$10 = Term (years)

It changes chart into a line rather than keeping my chart

How to downlaod excel file?

Is there a tweak for the FV function to work from day one? Also why does the function give a negative value and that I have to add a negative sign at the beginning?

orange is too hard to read

the duration bar does come in the center of days complete and percentage bar. any idea how to make it at the bottom of it ? plz

Thanks

This is awesome! Question - how do you the same, but for charts created with Smart Art - when i use the same formula (i named my graph prior to lbk - IF($C$60="LBK 1441",lbk,"NA"), i receive a display of 15 horizontal and 30 vertical chart or cells with "#Ref!" in them. If i change the text of C60 to something else, i receive NA (which is expected). Again, i have named lbk the chart i created from Smart Art

Phenomenal!

Commenting for the algorithm - your solution was the best, thank you!

please send me same tamplate for my use

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

You can change/adjust in Series options and put 9 hence the today's date line will hit the top of the chart...

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.

could be hourly?

Amazing! Thank you

Please if you can make vedio on material stock also in projects

It's very useful n easy

Thanks for sharing, well done

Thank you

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...

TY for reminding me that there are more format choices besides custom ones that I typically use.

A Truly excellent tutorial. Concise, yet not rushed. Well laid out and not overly complicated. Well done sir!

Perfect! Straight to the point! I thank you, so very much, for this very well done tutorial.

Thanks. Can I ask if a chart is created based on table it doesn’t automatically update ?

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

Why did you use 2 for the upper and lower band?

What if I contribute monthly with different amount and I put it in Term deposit of 1 year and rollover principle + interest. How do I calculate that?

This video is excellent! Thank you for sharing!!

This is AWESOME TY

big help dawg

Great video, thanks for sharing

Hi, if there are a total of 3 levels, what do you do? Do you sum up the level 2 and multiply it by the level 1 weight?

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.

Hey, do you have a tutorial for this video, how to make assessment

Perfect

/When I get to the Axis Format page, I don't have the date options. Why is that?

Thank you. I am going to try to create a template according to this. Good idea.

Great video, how can we exclude weekend in the progress bar?

Why is the Error bar grayed out on my Excel?

How can we connect table and pivot table with single slicer?

thank you

how would someone do this in google sheets?

How do you set up the % progress, what formula do you use?

Free

Hi I want learn us taxation and accounting

Finally!..An accent I can understand, thank you.

Very helpful, thanks a lot

How to do this for combo chart?