Sir why don't you solve those business questions btw video is very helpful for learning basics and one more thing i genuinely request you to improve your video quality i need one more help like can you please provide me this excel sheet
@Mark-sf4khАй бұрын
Nice job bossss
@high5tutorials135Ай бұрын
Thank you
@zach4hoffАй бұрын
Thanks!
@high5tutorials135Ай бұрын
Welcome!
@wisdom_ubohАй бұрын
Thanks for recording and sharing your knowledge. Bringing in the combo box is a top-notch idea 🔥🔥🔥🔥🔥🔥🔥🔥
@high5tutorials135Ай бұрын
Thank you very much. I very well appreciate you compliments.
@ngoziokafor3891Ай бұрын
You are the real MVP🙌. Thanks Charles
@Moremi-tvАй бұрын
This is the best tutorial ever! I had never done a process chart before and did a picture perfect one with your tutorial! You also saved me a lot of stress. Thanks again!
@olivere977216 күн бұрын
Hes a good guy
@vincentchidiebere16522 ай бұрын
Great explanations. Perhaps you can provide the workbook for practice.
@zararahmed11033 ай бұрын
thank you for this video. 🙂🤝
@high5tutorials1353 ай бұрын
Thank very much for your kind appreciation.
@high5tutorials1353 ай бұрын
Thank you for your kind appreciation
@iyaboishola71653 ай бұрын
To get the end date I can't get the answer,is showing #Value
@high5tutorials1353 ай бұрын
Check your cell that have the start and end date. Make sure the date reads month number/day number/year number. Or dd-mmm-yyyy format. Hopefully, this will help
@dennisappiah-kubi52693 ай бұрын
Thank you for this video. It was very helpful!
@high5tutorials1353 ай бұрын
So happy you enjoyed it.Thank you
@brandsouqriyadh3 ай бұрын
please text sumif formula apply in gross block
@high5tutorials1353 ай бұрын
Check the condition within your sumif function. If you have multiple conditions, use sumifs.
@high5tutorials1353 ай бұрын
Check the condition in your sumif formula. Make sure it matches. Also make sure that the sum and criteria range is completely referenced. If you are using multiple conditions, use sumifs function.
@oluseyeoyeyemisunday48904 ай бұрын
Thank you for helping me understand index match. Your explanation were simple and clear
@MuhammadIrfan-ml5gb4 ай бұрын
Lovely
@ngapuikuemberirua36704 ай бұрын
Very good content
@ngapuikuemberirua36704 ай бұрын
Great stuff
@high5tutorials1354 ай бұрын
Thank you very much
@rajeshparsekar29945 ай бұрын
VERY HELPFUL AND easy to apply
@high5tutorials1355 ай бұрын
Thank you Sir
@raphaelokoye43106 ай бұрын
This is the best explanation of index and match I have seen in a long time time🎉
@high5tutorials1356 ай бұрын
So happy you found it understandable
@ravmon10006 ай бұрын
great content sir!!
@high5tutorials1356 ай бұрын
Thank you for watching. Glad you found it a great content
@oluseyeoyeyemisunday48906 ай бұрын
At the end of video you mentioned something about being unable to reduce the width of the line in the drawing mode. I found out that this could be possible by holding down the shift key and scrolling down with your mouse wheel.
@high5tutorials1356 ай бұрын
Thank you for watching and for adding value to this video. Happy to learn from you.
@karlagranados99217 ай бұрын
Hi Charles! This is a great video. I would love to connect and discuss this template with you. I sent you a LinkedIn invite to connect. Thank you.
@high5tutorials1357 ай бұрын
I am happy you live it. Connected. Thank you.
@peteriruogu89289 ай бұрын
I appreciate the informative video. Currently, I'm experiencing problems with the index formula as it doesn't capture the total amount for a specific asset class, eg for furniture and fittings. The index formulae seems to be missing some asset values when calculating the gross black for the same asset asset class on different rows
@high5tutorials1358 ай бұрын
I am very sorry for late response. I may need to look the spreadsheet with you using not sensitive data. [email protected]. However, the index function returns a value and not the sum of values. The sumifs function should do the job if I understood what you have stated. Thank you for the compliments
@peteriruogu89288 ай бұрын
@@high5tutorials135 Thank you for reaching out. It has been sorted already
@mohitmishra932210 ай бұрын
OMG this was so helpful. Thankyou Sir !
@high5tutorials1358 ай бұрын
Welcome. Happy to know it helped
@Grandmajoe12311 ай бұрын
What a fantastic video and tutorial, thanks for all your help.
@high5tutorials1356 ай бұрын
Welcome and thank you for watching.
@sindhujamilkuri-k2c Жыл бұрын
What is the Report Date and how do I know about the Report Date
@high5tutorials1358 ай бұрын
Just like in monthly reports, the report date is the last day of a report month. However, the report date can be any date from which the report need to be evaluated
@ravindharmadas6729 Жыл бұрын
What is the Report Date and how do I know about the Report Date
@christyo.9125 Жыл бұрын
This video is very helpful, thank you for your time.
@christyo.9125 Жыл бұрын
Very impactful. highly simplified
@micalghebreab1 Жыл бұрын
Thank you a lot!
@high5tutorials1353 ай бұрын
Thanks for the appreciation. You inspire me.
@kingjoseph927 Жыл бұрын
Thanks i enjoyed the lecture.
@annietran8200 Жыл бұрын
Thank you so much
@H-do8tr Жыл бұрын
Great tutorial! Speaking about the disposal, what about if I want to dispose a part of an asset amount not an entire asset?
@komninoskamamis1098 Жыл бұрын
Thank you very much. Very helpful
@khaledhasan6998 Жыл бұрын
Thanx
@michaelrouse5286 Жыл бұрын
Great presentation
@sday2551 Жыл бұрын
Hi - Trying to do the Gross Block - the formula only calculates the first row of figures and not the 10 ( I have 11 rows of assets) any ideas ??
@high5tutorials1358 ай бұрын
Use Sumifs to calculate the gross block
@nyambesimangolwa5755 Жыл бұрын
Golden, thanks!
@tehxii7706 Жыл бұрын
I should probably learn to use Visio but with limited time I am attempting to use Excel.
@hushtoroar16772 жыл бұрын
You are a genius! Thanks so much xx😍
@high5tutorials1352 жыл бұрын
So happy to know you like it
@dabbahprosperprince8622 жыл бұрын
Is a good practical PPE register. I tried it but released that the depreciation per day is not zero when the asset reached its useful life. Therefore push the lapse days more than the uesful life days abd the net effect is in negative
@high5tutorials1358 ай бұрын
Could it be because of the salvage value?
@mawaemmanuelalex41792 жыл бұрын
Was helpful. Thanks.
@kevinassang31582 жыл бұрын
Very good, thanks
@diamondglow79472 жыл бұрын
Great explanation! Thank you for sharing
@high5tutorials1352 жыл бұрын
Thank you very much
@theatmp972 жыл бұрын
Shouldnt you include the effect of the tax shield?
@fredricklangat16772 жыл бұрын
This indeed is very helpful
@high5tutorials1352 жыл бұрын
Happy to know. Thank you
@bhawanihada99862 жыл бұрын
Superb illustration boss
@high5tutorials1352 жыл бұрын
🙏
@Sp181112 жыл бұрын
Do you have the link to download this excel template which u created ?
@kaluanyim14532 жыл бұрын
Thanks for the insightful tutorial, Sir. Can the formula be adjusted to depreciate for a full year irrespective of the purchase date of the asset?
@high5tutorials1352 жыл бұрын
Thanks for watching. Let me get you clear. If I buy the assets at the Middle of the year, do you want it to assume a full year depreciation at the end of the purchase year?
@tongvang7242 жыл бұрын
Why not just use visio?
@high5tutorials1352 жыл бұрын
Because Microsoft made the possibilities in Excel. Anyway Visio was made for flow charts thank you for commenting
@surfmarko2 жыл бұрын
fantastic! Thank you!
@high5tutorials1352 жыл бұрын
Welcome. Thanks for watching
@wavesofhealingssj63032 жыл бұрын
This is very helpful, thank you. How do I create a Legend as shown in the video?