Тёмный
The Excel Hub
The Excel Hub
The Excel Hub
Подписаться
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
Комментарии
@georgelampropoulos1704
@georgelampropoulos1704 13 дней назад
Commenting for the algorithm - your solution was the best, thank you!
@theexcelhub
@theexcelhub 13 дней назад
Thank you very much!
@shantilalparmar4723
@shantilalparmar4723 14 дней назад
please send me same tamplate for my use
@anantraj3961
@anantraj3961 14 дней назад
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
@pipo441
@pipo441 16 дней назад
You can change/adjust in Series options and put 9 hence the today's date line will hit the top of the chart...
@philcrawford325
@philcrawford325 16 дней назад
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.
@olodium6755
@olodium6755 19 дней назад
could be hourly?
@sammaakter7540
@sammaakter7540 21 день назад
Amazing! Thank you
@samirparmar3318
@samirparmar3318 23 дня назад
Please if you can make vedio on material stock also in projects
@samirparmar3318
@samirparmar3318 23 дня назад
It's very useful n easy
@johnfitzgerald8203
@johnfitzgerald8203 26 дней назад
Thanks for sharing, well done
@vinhwizard
@vinhwizard Месяц назад
Thank you
@theexcelhub
@theexcelhub Месяц назад
Thanks for watching!
@philhoward
@philhoward Месяц назад
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...
@michaelbennett5568
@michaelbennett5568 Месяц назад
TY for reminding me that there are more format choices besides custom ones that I typically use.
@theexcelhub
@theexcelhub Месяц назад
Glad you found it useful!
@laurenceoliver4900
@laurenceoliver4900 Месяц назад
A Truly excellent tutorial. Concise, yet not rushed. Well laid out and not overly complicated. Well done sir!
@MrLRankin2
@MrLRankin2 Месяц назад
Perfect! Straight to the point! I thank you, so very much, for this very well done tutorial.
@bpclubsport7879
@bpclubsport7879 Месяц назад
Thanks. Can I ask if a chart is created based on table it doesn’t automatically update ?
@scajoh3001
@scajoh3001 Месяц назад
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
@joshpeters813
@joshpeters813 Месяц назад
Why did you use 2 for the upper and lower band?
@serenadesay2334
@serenadesay2334 Месяц назад
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?
@olabisiakinyele810
@olabisiakinyele810 Месяц назад
This video is excellent! Thank you for sharing!!
@michael47359
@michael47359 Месяц назад
This is AWESOME TY
@umarkhalid8905
@umarkhalid8905 2 месяца назад
big help dawg
@osamamohd007
@osamamohd007 2 месяца назад
Great video, thanks for sharing
@rubinipriya37
@rubinipriya37 2 месяца назад
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?
@desertjedi
@desertjedi 2 месяца назад
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.
@hulkgaming1390
@hulkgaming1390 2 месяца назад
Hey, do you have a tutorial for this video, how to make assessment
@nursingconnections
@nursingconnections 2 месяца назад
Perfect
@tibbytx1
@tibbytx1 2 месяца назад
/When I get to the Axis Format page, I don't have the date options. Why is that?
@philr3630
@philr3630 3 месяца назад
Thank you. I am going to try to create a template according to this. Good idea.
@km2612
@km2612 3 месяца назад
Great video, how can we exclude weekend in the progress bar?
@sachinryanv1
@sachinryanv1 3 месяца назад
Why is the Error bar grayed out on my Excel?
@digitlizer
@digitlizer 3 месяца назад
How can we connect table and pivot table with single slicer?
@ArminasDesign
@ArminasDesign 3 месяца назад
thank you
@lmac222
@lmac222 3 месяца назад
how would someone do this in google sheets?
@fjrxj1134
@fjrxj1134 3 месяца назад
How do you set up the % progress, what formula do you use?
@srinivasvallamdas8311
@srinivasvallamdas8311 3 месяца назад
Free
@srinivasvallamdas8311
@srinivasvallamdas8311 3 месяца назад
Hi I want learn us taxation and accounting
@victoriaokewole6281
@victoriaokewole6281 3 месяца назад
Finally!..An accent I can understand, thank you.
@theexcelhub
@theexcelhub 3 месяца назад
Happy to help!
@ehsaan2089
@ehsaan2089 3 месяца назад
Very helpful, thanks a lot
@redfielddonato4196
@redfielddonato4196 3 месяца назад
How to do this for combo chart?
@andrewjohnclaveria-mk1jh
@andrewjohnclaveria-mk1jh 3 месяца назад
Thank you heaps
@elainec.1444
@elainec.1444 3 месяца назад
why is if the total income is 120000 pounds, the taxable rate is 45 percent based on your formulas?
@elainec.1444
@elainec.1444 3 месяца назад
why is if the total income is 120000 pounds, the taxable rate is 45 percent based on your formulas?
@rayanabouali1261
@rayanabouali1261 3 месяца назад
Hey bro you dropped this 👑
@provaid82
@provaid82 3 месяца назад
Just quick asking , are you gone make it one for 2024 - 2025? Thanks
@bounyoothammavong5712
@bounyoothammavong5712 3 месяца назад
Wow, I just found this video, very useful and share thanks for your share🤩
@enzovitaloni7327
@enzovitaloni7327 3 месяца назад
Sir! I really appreciate for this video. It was really helpful and easy to follow to prepare an activity tracker!.
@lilyrosenbaum5908
@lilyrosenbaum5908 3 месяца назад
THIS VIDEO WAS SO HELPFUL!!! THANK YOU!!!!
@abderrahmaneazibi8056
@abderrahmaneazibi8056 3 месяца назад
In my opinion it's far more interesting. Many thanks for sharing.
@pawanrai722
@pawanrai722 4 месяца назад
What a video....extremely informative and useful. Thanks a lot for this video.